Working with an old SQLite2 database

Question

I have a really old, dusty SQLite 2 database lying around on my hard disk that I'd like to search around in.

So far, I've tried opening it with tools such as sqliteman, sqlitebrowser, and simply trying to open it with sqlite3 in Python, but to no avail.

All tools now seem to exclusively support SQLite 3.

Is there a way I can open this old SQLite 2 database in Python?

By the way, I'm pretty sure it's a SQLite database, looking around in the binary contents:

user@host:~ $ head -1 old.db | cut -c 1-48
** This file contains an SQLite 2.1 database **

Why dont you compile an older version of sqlite? – James Mills Dec 10 '13 at 08:06 — James Mills, Dec 10 '13 at 08:06

score 0 · Answer 1 · answered Dec 10 '13 at 08:09

0

You can download the source code and go back to an older version.

I found a version_2 branch by just surfing around their site. Clicking the newest commit takes you to a page where you can download a tarball of the code at that time.

answered Dec 10 '13 at 08:09

Emil Vikström

90,431
16
141
175

Working with an old SQLite2 database

1 Answers1