Package dev.rafex.ether.database.sqlite.config

package dev.rafex.ether.database.sqlite.config

SQLite configuration and PRAGMA utilities.

This package provides classes for configuring SQLite database connections, including Write-Ahead Logging (WAL) support, synchronous modes, and other SQLite-specific optimizations.

Key Classes

• SQLiteConfig - Configuration builder
• JournalMode - Journal mode enum
• SynchronousMode - Synchronous mode enum
• SQLitePragmas - PRAGMA application utility

Usage Example

SQLiteConfig config = SQLiteConfig.builder()
    .journalMode(JournalMode.WAL)
    .synchronousMode(SynchronousMode.NORMAL)
    .foreignKeys(true)
    .busyTimeout(5000)
    .build();

try (Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db")) {
    SQLitePragmas.apply(conn, config);
    // Use connection...
}

See Also:

• SQLite PRAGMA Documentation

Related Packages

Package	Description
dev.rafex.ether.database.sqlite	SQLite-specific extensions layered on Ether database core APIs.
dev.rafex.ether.database.sqlite.client
dev.rafex.ether.database.sqlite.errors	SQLite error code classification and error helpers.
dev.rafex.ether.database.sqlite.sql	SQLite-specific SQL parameter helpers.

Class	Description
JournalMode	SQLite journal modes.
SQLiteConfig	Configuration for SQLite database connections.
SQLiteConfig.Builder	Builder for SQLiteConfig.
SQLitePragmas	Utility to apply SQLite PRAGMA settings to a connection.
SynchronousMode	SQLite synchronous modes.