On 24 Jul 2010, at 9:56am, Gilles Ganault wrote: > So from the above, it looks like this binary supports access to > MySQL(i) and SQLite2/3, in both procedural and (PDO) object-oriented > modes. > > If that's correct, and provided the application doesn't need to be > DB-agnostic... why should I choose PDO instead of the procedural > functions to SQLite3?
The main advantage of the PDO is that the calls for each SQL engine are identical. In other words, you can write your code as if you're going to use SQLite, then one day find you have to move to MySQL, and you'll only have to change one line of code -- the one that says which engine you want it to use. If you're in a profession where you have to use many SQL engines this can save you from having to learn the different rules and foibles of each one. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
