How to access SQL-Lite databases using ODBC on recent Debian/Ubuntu

Many modern applications are using SQLite databases to store their data. I wanted to access to data of Hamster, a very nice time tracking application for the Gnome desktop, to use that data for further analyses in OpenOffice Calc. My experience from Windows is that ODBC is very easy to access to SQL Server or other databases. Is it possible to work that with Linux? Yes, it is! This article describes how you can use ODBC to access to those databases. Also some issues are discussed. [Read more…]