On 9 Feb 2010, at 3:17am, Richard Cooke wrote: > I'm trying to teach myself PHP and SQLite and I've tried to understand > whether SQLite and SQLite3 are the same animal or are they completely > different. I am using WAMP on a PC and the PHP version is 5.31. If I > use sqlite_libversion(); I get a result of 2.8.17. If I use > SQLite3::version() I get 3.6.15. Does this make sense? > > If they are completely different animals how do you decide on which one > to use?
SQLite3 is any version of SQLite from 3.0.0 upwards. In the move from 2.x.x to 3.x.x there were so many changes in how SQLite worked internally that it was almost a different product. Nevertheless, version 3 can read the files made by version 2. Needless to say, version 3 is better, faster, has more abilities, and it handles non-ASCII characters better. If you have no reason to use the version 3 libraries, use version 3. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
