Colin Ross wrote:
Speaking stricky of the DB-side of things for a moment though,
shouldn't you be able to design an application using PDO (and SQLite)
and move your datasource to something like pgSQL or MySQL when
concurrency becomes an issue (with very little modification to your
code) ?
Assuming you use only SQL syntax that is portable between difference
implementations, this "should" be true.
In practice, it's fairly easy for some of your SQL code to contain
vendor-dependent syntax, even if you use an abstraction layer. Take for
example the various ways to do string concatentation in different RDBMS
brands.
It's even trickier when there are vendor-dependent semantics
differences. That is, the syntax is identical but the result of the
query varies from brand to brand.
Regards,
Bill Karwin
