sqlite database

Opens the file as a sqlite database. This is a read-only SQLite connection. If the connection is successful, the path name of the database is displayed.

Multiple Processes and Multiple Connections

SQLite allows multiple processes to have the database file open at once, and for multiple processes to read the database at once. However, when any process wants to write, it must lock the entire database file for the duration of its update (usually a few milliseconds).

Returns the encoding of the database. This is determined using PRAGMA encoding. The returned string can be either UTF-8, UTF-16le (little-endian UTF-16 encoding) or UTF-16be (big-endian UTF-16 encoding).

Returns a sqlite statement object that can be used to retrieve the results. This property will return error if:

• A syntax error exists, or
• The SQL statement modifies the database in any way. This includes some PRAGMA statments as well.

If successful, SQLite compiles the SQL statement into byte code and is ready to retrieve the results. This property does not have a display format. "This expression evaluates to an unrepresentable object of type sqlite statement" will be shown instead.

SQLite understands most of the standard SQL language. However it does omit some features as well as adding a few features of its own. For more details, visit the SQLite documentation on this subject.

Returns the table with the specified name in the sqlite database. Errors if the table does not exist.

Returns all tables associated with the database file.

Returns the name of the database file.