Re: [sqlite] Converting sqlite3 to sqlite2.

Ah! Good to know. Thank you! On Tue, Jun 7, 2011 at 3:10 PM, Richard Hipp wrote: > On Tue, Jun 7, 2011 at 5:41 PM, Joe Goldthwaite > wrote: > > > I didn't realize that the Schema was just a > > place for the developer to leave a note. I assumed that it

Re: [sqlite] Converting sqlite3 to sqlite2.

On Tue, Jun 7, 2011 at 5:41 PM, Joe Goldthwaite wrote: > I didn't realize that the Schema was just a > place for the developer to leave a note. I assumed that it was the sqlite's > internal database schema that was being used to describe some internal > control tables or

Re: [sqlite] Converting sqlite3 to sqlite2.

Thanks Richard. It's good to know exactly what the problem is. I'll stop posting about it here and follow up with the pysqlite forum. And thanks again to you Robert. I didn't realize that the Schema was just a place for the developer to leave a note. I assumed that it was the sqlite's internal

Re: [sqlite] Converting sqlite3 to sqlite2.

On Tue, Jun 7, 2011 at 4:38 PM, Joe Goldthwaite wrote: > 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 >

Re: [sqlite] Converting sqlite3 to sqlite2.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/07/2011 01:52 PM, Joe Goldthwaite wrote: > It says the file is schema version 1, user version 2. That has *nothing* to do with the issue. They are just two fields within a SQLite 3 database. You can change them to any arbitrary numbers you

Re: [sqlite] Converting sqlite3 to sqlite2.

Hi Roger, I posted over there because it started looking like it's more of a pysql problem than a sqlite 2 problem. I copied the cookies.sqlite file from Firefox 3.6 and opened it with the sqlite manager. It says the file is schema version 1, user version 2. That's a big difference from Firefox

Re: [sqlite] Converting sqlite3 to sqlite2.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I see you have now taken this up on the python-sqlite mailing list where we'll deal with the issue. You've seriously mixed up Python, SQLite and pyqlite issues and Firefox's databases are SQLite 3 so SQLite 2 is completely irrelevant. Roger

Re: [sqlite] Converting sqlite3 to sqlite2.

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

Re: [sqlite] Converting sqlite3 to sqlite2.

-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

[sqlite] Converting sqlite3 to sqlite2.

I've got a problem. I need to convert an sqlite3 database back to sqlite2's format on a Windows machine. I've found instructions on how to do it but they require sqlite.exe which I can't seem to find anywhere! Does anyone have a link where they can download the older version? P.S. I know the