You're right. It looks like the last release of sqlite 3 released in September '04. It seems like the version of pysqlite that I'm using, which was released Nov '09' would support it. Maybe the version of sqlite isn't my problem. I'm trying to read the Firefox cookies file (cookies.sqlite). It worked fine in Firefox 3.5 and 3.6 but this is the first time I've tried it since I upgraded to Firefox 4. Now I'm getting an error message "DatabaseError: file is encrypted or is not a database". I can open the file with sqlite3.exe and list the cookies. I can also open it with the SQLite Manager firefox add-on.
According to SQLite Manager, the file is Schema Version 5, User Version 4 and it's encoded with UTF-8. I posted a question on the pysqlite list to see if someone there can give me a clue. Thanks for the response Roger. On Tue, Jun 7, 2011 at 11:52 AM, Roger Binns <[email protected]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 06/07/2011 11:41 AM, Joe Goldthwaite wrote: > > The development environment I'm using is locked into > > Python 2.4 and pysql for python 2.4 can only handle the older sqlite > format. > > I'd suggest getting working with SQLite 3. SQLite 2 is positively ancient > and you'll have trouble finding modern tools that work with it correctly. > > The only pysql I can find works only with Oracle. > > My own Python wrapper for SQLite (APSW) supports SQLite 3 and Python 2.3 > onwards. pysqlite is also SQLite 3 only and there are Windows binaries for > Python 2.{5,6,7} but I suspect it will compile just fine against Python > 2.4. > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > > iEYEARECAAYFAk3uc4IACgkQmOOfHg372QQW3QCfXP88Hjpj0qEhoqViAaFZ7eoO > COwAn3p2/dmML9dcuwDbjD4I6X6imLjt > =KQtt > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
