> > > 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.-
