NYCPHP Meetup

NYPHP.org

[nycphp-talk] PHP5 and SQL Lite...thoughts?

Adam Maccabee Trachtenberg adam at trachtenberg.com
Thu Apr 15 20:37:34 EDT 2004


On Thu, 15 Apr 2004, Matthew Terenzio wrote:

> Can it not be said that in some ways SQLLite is more advanced than
> MySQL?
> Does MySQL support transactions, for instance? (Don't flame me, I'm
> here for PHP but use Postgres, and I haven't kept up with MySQL over
> the last two years).

Yea, MySQL does support transactions. Don't be put off my the "Lite"
in SQLite. It's full featured, but you're essentially accessing a
flatfile, so you can't do things like replication and GRANTs.

Other than that, SQLite supports transactions, triggers, UDFs (written in
PHP! This is wicked awesome!), subselects, and many other advanced
features.

-adam

-- 
adam at trachtenberg.com
author of o'reilly's php cookbook
avoid the holiday rush, buy your copy today!



More information about the talk mailing list