SQLite, PHP and ALTER TABLE
Wednesday, 4 August 2004 @ 17:19Since SQLite comes bundled with PHP 5, I thought I’d post this for those interested.
SQLite currently does not support ALTER TABLE statements. This can make developing/modifying an app a bit cumbersome, since modifying a table requires creating a temp table and copying data back and forth. To this end, I’ve created a PHP wrapper for SQLite that does the dirty work for you and supports all types of ALTER TABLE statements. The source is in the public domain, so you may use it however you like.
Documentation:
http://code.jenseng.com/db/
Source:
http://code.jenseng.com/db/sql.txt
I will be releasing an optimized version with cleaner code, more comments, and additional functionality (such as RENAME TABLE) in a few weeks.