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

SQLite configuration and PRAGMA utilities. More...

Classes
enum	JournalMode
	SQLite journal modes. More...
class	SQLiteConfig
	Configuration for SQLite database connections. More...
class	SQLitePragmas
	Utility to apply SQLite PRAGMA settings to a connection. More...
enum	SynchronousMode
	SQLite synchronous modes. More...

Detailed Description

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

• dev.rafex.ether.database.sqlite.config.SQLiteConfig - Configuration builder
• dev.rafex.ether.database.sqlite.config.JournalMode - Journal mode enum
• dev.rafex.ether.database.sqlite.config.SynchronousMode - Synchronous mode enum
• dev.rafex.ether.database.sqlite.config.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