sqlx4k-sqlite/io.github.smyrgeorge.sqlx4k.sqlite/SQLite

SQLite

class SQLite(url: String, options: QueryExecutor.Pool.Options = QueryExecutor.Pool.Options()) : ISQLite(source)

A database driver for SQLite, implemented with connection pooling and transactional support. This class provides mechanisms to execute SQL queries, manage database connections, and handle transactions in a coroutine-based environment.

sqlite::memory: | Open an in-memory database. sqlite:data.db | Open the file data.db in the current directory. sqlite://data.db | Open the file data.db in the current directory. sqlite:///data.db | Open the file data.db from the root (/) directory. sqlite://data.db?mode=ro | Open the file data.db for read-only access.

Parameters

url

The URL string for connecting to the SQLite database.

options

Configuration options for the connection pool, such as minimum and maximum connections, timeout durations, etc.

Constructors

SQLite

constructor(url: String, options: QueryExecutor.Pool.Options = QueryExecutor.Pool.Options())

Types

class Cn(rt: <Error class: unknown class><out <Error class: unknown class>>, cn: <Error class: unknown class><out <Error class: unknown class>>) : Connection

Represents a native database connection that implements the Connection interface.

Companion

object Companion

class Tx(rt: <Error class: unknown class><out <Error class: unknown class>>, tx: <Error class: unknown class><out <Error class: unknown class>>) : Transaction

Represents a specific implementation of the Transaction interface. This class facilitates the management of database transactions, including methods to commit, roll back, execute queries, and fetch results.