Expand/Shrink

sqlite3_open

Definition: include pSQLite.e

sqlite3 db = sqlite3_open(string filename)
Description: Open the sqlite database file "filename".

If the database file does not exist, then a new database will be created as needed.
The opening and/or creating of the database file is deferred until the file is actually needed.

There is no requirement for database names to have a ".sqlite" suffix, but it seems generally sensible. Note that imho ".sql" suffix files should contain / be reserved for text source code files consisting of statements such as "INSERT INTO table VALUES (1,2,3);", and certainly not something wholly incompatible with the likes of, say, MySQL.

Resources associated with the returned handle should be released by passing it to sqlite3_close() when it is no longer required
pwa/p2js: Not supported
Example:
include pSQLite.e
sqlite3 db = sqlite3_open("log.sqlite")
    ...
sqlite3_close(db)
See Also: sqlite3_close