Reading SQLite databases in Windows

sqlite2009-proI recently had to get some data out of a .db file from an Adobe Air application, a few quick searches on Google turned up that the file is, as I suspected, a SQLite database. (Way to go Adobe!)

A few searches later and I had found this neat little application called SQLite2009 Pro its a free download and works pretty well. It allows you to view the database structure and import/export data as well as run SQL queries against it. It also comes with a ODBC driver but I haven’t gotten that to work, but admittedly I haven’t read any of the docs yet.

For those of you wondering, the file I was reading is the database file for the SARS (South African Revenue Service) E@syFile software.