>
>
> Would something like SQLite support the full functionality that we get
> from PostgreSQL: subqueries, transactions, views, triggers and stored
> procedures? MySQL does not (yes I know they are adding some or all of
> this but it isn't all there or proven to be reliable yet).
>
> I will check SQLite out but MySQL is probably NOT a good option for
> this. Historically it did not support subqueries (an absolute must
> for any serious database user) - not sure if they have added subquery
> support recently or not.
>
SQLite goes for SQL '92 compliance whereas PostgresQL goes for I think
it is) '99 (or is it '95?) compliance.
http://sqlite.org/omitted.html tells you what is missing from the
software against the '92 standard. Against PostgresQL SQLite will lose
in the features department almost every time.
My only real issue with PostgresQL is that it is a client/server
database, that is not embeddable. If it was embeddable then I could use
it with no issue, and would in fact rather use it. I recall some people
are working on that, but don't have any links. You might want to try
www.postgresql.org and see if they any info on there.
AmadeusZ.-