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.