[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