the reality tunnel

• web form uinit testing that can handle javascript : jWebUnit
• creating a PDF with PHP
• creating a PDF with PHP for free!
• CSS for Printing
• Utility to power off windows xp system from a batch file
• Windows Resource Kit (use to install stunnel as services)
• Real-World PHP Security
• sending jabber message from php:

  http://phpjabber.g-blog.net/HomePage

• connecting access and mysql
• remote stunnel command:
  /usr/sbin/stunnel -P/tmp/ -p cert/mysql-server.pem -d 33306 -r localhost:3306

  stunnel local command:
  stunnel.exe stunnel.conf

• securing replication process
  i want to use stunnel to encrypt the data traveling between the computer at Boxcar and the MySQL server
• unicode in MySQL

  so i was having problems in my python script inserting data into the MySQL database from Access b/c I guess Access uses unicode and python was trying to automagically encode some weird character into latin-1 when doing the insert.

  This code shows the problem:

  >>> s = u'\u2026'
  >>> s.encode('latin-1')
  Traceback (most recent call last):
  File "", line 1, in ?
  UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2026' in position 0: ordinal not in range(256)
  >>> s.encode('ascii')
  Traceback (most recent call last):
  File "", line 1, in ?
  UnicodeEncodeError: 'ascii' codec can't encode character u'\u2026' in position 0: ordinal not in range(128)
  >>> s.encode('utf-8')
  '\xe2\x80\xa6'
  

  this post proved to be a little helpful:

  http://mail.python.org/pipermail/python-list/2003-December/200090.html

  this document was even more helpful:

  http://python.active-venture.com/tut/node5.html

• raw string literals in python

  when constructing the DSN be sure to use r”DSNSTRING” because the \b was getting interpretted wrong

• I always suspected that the Boxcar Database design was cludgy. Check out http://vbmysql.com/articles/database-design/normalize.html for ideas on making it cleaner
• accessing ms access databases in python using ado
• Puffin - a framework for testing web applications. An article on Puffin is available here
• getting older versions of files out of cvs
• Introduction to SQL Joins and Subqueries
• printing out the contents of an array
  use print_r
• Tutorial on using PHPDoc
• backing up table structure only of mysql database

  mysqldump --no-data

• testing web applications - webunit
• allowing only SSL requests for a particular URL

  
        SSLRequireSSL
  

• basic mysql tutorial

  this is real helpful in refreshing my memory
  http://www.devshed.com/c/a/MySQL/Beginning-MySQL-Tutorial/

http://www.filesoup.com/forum/index.php?showtopic=6780