NYCPHP Meetup

[Adam Maccabee Trachtenberg]

On Sat, 24 Jul 2004, Joe Crawford wrote:

> i was asking if anyone has used sqlite and if it was better than using
> mysql etc...

Okay. In that case my answer is SQLite is better than MySQL in some
instances and worse in others. :)

In many ways this is a somewhat vague question because you haven't
qualified your question with the type of application you're trying to
develop.

SQLite is better:
  * When your application requires a database and you can't depend on
one being installed.
  * When you have mostly read only data.
  * When you want triggers.
  * When you want typeless fields.
  * When you want to write custom UDFs in PHP.
  * When you don't want to worry about the GPL.

MySQL is better:
  * When you have lots of reads mixed in with writes.
  * When you need access control, such as what's done using the GRANT command.
  * When you need replication.
  * When you want to communicate using SSL.
  * When you want typed fields.
  * When want to chose a GPL product.
  * When you want paid support.

SQLite and MySQL both have subselects and transactions.

-adam

-- 
adam at trachtenberg.com
author of o'reilly's "upgrading to php 5" and "php cookbook"
avoid the holiday rush, buy your copies today!