Database

Object Hierarchy:

Description:

public class Database

Manages SQLite database connections with in-memory storage and file backup.

The Database class provides a wrapper around SQLite that uses an in-memory database for performance, with the ability to backup to and restore from a file. It maintains a schema cache to avoid repeated schema queries.

The database is configured for serialized access mode, allowing safe multi-threaded access.

Thread safety is ensured via a mutex that protects all database operations, allowing safe concurrent access from multiple threads (e.g., main thread and background async query threads).

Namespace: SQ

Package: ollmchat

Content:

Properties:

public string filename { get; }
The filename used for backup and restore operations.
public bool is_dirty { get; set; }
Whether the database has unsaved changes (dirty flag).

Creation methods:

public Database (string filename, bool autosave = false)
Creates a new Database instance.

Methods:

public void backupDB ()
Backs up the in-memory database to the file.
public void exec (string q)
Executes a raw SQL query.

Fields:

public Database db
The underlying SQLite database connection.
public Mutex db_mutex
Mutex to protect database operations from concurrent access. All operations that use `db` must lock this mutex first.
public HashMap<string,ArrayList<Schema>> schema_cache
Cache of table schemas to avoid repeated PRAGMA queries.