2] Beekeeper Studio. Just like the first option, Beekeeper Studio is a free, open-source, cross-platform, SQL editor and database manager. It supports various databases such as MySQL, SQLite, SQL ...

Basically, you call sqlite_open() to connect to a database, in which you provide the filename and access mode. Then, you implement a callback function, which SQLite calls for each record it retrieves ...