Category Archives: mysql

php DB adapter, with magic

I would like to encapsulate the handling of database connections, and maintain a loose coupling between database connections and application and data-access code. I'll not focus on connection pooling since that can be handled at the driver level independent of … Continue reading

Posted in mysql, php

mysql \c

The mysql command line interface provides several very useful shortcuts. For example, the 'tee' command will append everything to a specified outfile: mysql> \T logfile.txt Logging to file 'logfile.txt' The 'clear' command saves from accidentally hitting Ctrl-C and disconnecting from … Continue reading

Posted in mysql