There is a lot of difference between SQLite and PostgreSQL, for sure. PostgreSQL is pretty much on par with Oracle as far as abilities go and SQLite much more like Foxpro tables. I wouldn't think it very feasible to write a complex system that could switch between the two databases.
I think my point is that SQLite has it's place in the world: Utility programs; light weight, low transaction programs; programs where easy deployment and server setup wouldn't be feasible. -K On 01/13/2011 09:39 AM, Stephen Russell wrote: > What is the conversion time for changing the connection to PostgreSQL? > Do you have to change any syntax in statements for fit the new > engine? I know that oracle would be harder in joins depending on > version. > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

