SQLite provides the sqlite3_open function to create or open a database file, returning a connection handle on success. The trick is that even if it fails to establish a valid connection, a connection ...

SQLite has an option to create an in-memory database that doesn't rely on an on-disk database file. This avoids the complexity I just mentioned, but can also provide dramatically improved performance.

XnView uses an SQLite database for storing this info and accessing it; Windows uses a flat file for the image metadata and another for the actual image thumbnails.

The SQLite website recommends using the “sl3” extension to signify that we're working with an SQLite version 3 database. If we examine the resulting file, ljdata.sl3 using the strings command, we see ...

What I'm trying to do, is create a batch script that will find a FireFox profile (using things like %appdata% and shit, to make it easier), check if SQLite is installed (just a small EXE), if not ...