dev.rafex.ether.database.sqlite.config.SynchronousMode Enum Reference

SQLite synchronous modes. More...

Collaboration diagram for dev.rafex.ether.database.sqlite.config.SynchronousMode:

Public Member Functions
int	pragmaValue ()
	Returns the integer value used in PRAGMA synchronous statements.
	SynchronousMode (int pragmaValue)
String	toSql ()
	Returns the SQL string for this synchronous mode.

Public Attributes
	EXTRA =(3)
	Extra synchronous mode similar to FULL but with additional directory sync operations for maximum durability.
	FULL =(2)
	SQLite syncs the database file after every write transaction.
	NORMAL =(1)
	SQLite syncs at the most critical moments, but less often than in FULL mode.
	OFF =(0)
	SQLite continues without syncing as soon as it has handed data off to the operating system.

Detailed Description

SQLite synchronous modes.

Controls how aggressively SQLite writes data to disk. Higher durability comes at the cost of performance.

See also

PRAGMA synchronous

Definition at line 37 of file SynchronousMode.java.

Constructor & Destructor Documentation

SynchronousMode()

dev.rafex.ether.database.sqlite.config.SynchronousMode.SynchronousMode

(

int

pragmaValue

)

Definition at line 66 of file SynchronousMode.java.

Member Function Documentation

pragmaValue()

int dev.rafex.ether.database.sqlite.config.SynchronousMode.pragmaValue

(

)

Returns the integer value used in PRAGMA synchronous statements.

Returns

PRAGMA value

Definition at line 75 of file SynchronousMode.java.

toSql()

String dev.rafex.ether.database.sqlite.config.SynchronousMode.toSql

(

)

Returns the SQL string for this synchronous mode.

Returns

SQL string (e.g., "OFF", "NORMAL", "FULL", "EXTRA")

Definition at line 84 of file SynchronousMode.java.

Member Data Documentation

EXTRA

dev.rafex.ether.database.sqlite.config.SynchronousMode.EXTRA =(3)

Extra synchronous mode similar to FULL but with additional directory sync operations for maximum durability.

Definition at line 62 of file SynchronousMode.java.

Referenced by dev.rafex.ether.database.sqlite.config.SQLitePragmas.apply(), and dev.rafex.ether.database.sqlite.config.SQLitePragmas.setSynchronousMode().

FULL

dev.rafex.ether.database.sqlite.config.SynchronousMode.FULL =(2)

SQLite syncs the database file after every write transaction.

Safest but slowest. Guarantees that data is written to disk.

Definition at line 56 of file SynchronousMode.java.

Referenced by dev.rafex.ether.database.sqlite.config.SQLitePragmas.apply(), and dev.rafex.ether.database.sqlite.config.SQLitePragmas.setSynchronousMode().

NORMAL

dev.rafex.ether.database.sqlite.config.SynchronousMode.NORMAL =(1)

SQLite syncs at the most critical moments, but less often than in FULL mode.

A good compromise between safety and speed.

Definition at line 50 of file SynchronousMode.java.

Referenced by dev.rafex.ether.database.sqlite.config.SQLitePragmas.apply(), and dev.rafex.ether.database.sqlite.config.SQLitePragmas.setSynchronousMode().

OFF

dev.rafex.ether.database.sqlite.config.SynchronousMode.OFF =(0)

SQLite continues without syncing as soon as it has handed data off to the operating system.

Fastest but least safe. Data may be lost in a power loss or operating system crash.

Definition at line 44 of file SynchronousMode.java.

Referenced by dev.rafex.ether.database.sqlite.config.SQLitePragmas.apply(), and dev.rafex.ether.database.sqlite.config.SQLitePragmas.setSynchronousMode().

---

The documentation for this enum was generated from the following file:

• ether-database-sqlite/ether-database-sqlite/src/main/java/dev/rafex/ether/database/sqlite/config/SynchronousMode.java