SQLite is a pain to work with.

The problems I'm having:

• Where are the DATE functions!?


• Why can I not modify a table stucture with the MODIFY command!?


• Why don't LIMITs work on deleting and updating!?

Such a pain.

The only good thing about SQLite is that it just comes with PHP5 and you don't need to install anything.

MySQL has been working perfectly as usual.