Enum SyncMode 

pub enum SyncMode {
    Off = 0,
    Normal = 1,
    Full = 2,
}

WAL sync mode - matches SQLite’s PRAGMA synchronous semantics

SochDB	SQLite	Description
Off	OFF (0)	No fsync, risk of data loss on crash
Normal	NORMAL (1)	Fsync at checkpoints, not every commit
Full	FULL (2)	Fsync every commit (safest, slowest)

Performance vs Durability Trade-offs

• Off: ~10x faster than Full, but may lose last ~100ms of data on crash
• Normal: ~5x faster than Full, durable at checkpoint boundaries
• Full: Every commit is fsync’d, no data loss possible

SQLite Compatibility

-- SQLite equivalent settings
PRAGMA synchronous = OFF;    -- SyncMode::Off
PRAGMA synchronous = NORMAL; -- SyncMode::Normal  
PRAGMA synchronous = FULL;   -- SyncMode::Full

Variants

Off = 0

No fsync (equivalent to SQLite PRAGMA synchronous = OFF)

Writes buffered in OS, may lose data on power failure. Use for non-critical data or bulk loading.

Normal = 1

Fsync at checkpoints (equivalent to SQLite PRAGMA synchronous = NORMAL)

Default mode. Syncs WAL at checkpoint boundaries. Good balance of performance and durability.

Full = 2

Fsync every commit (equivalent to SQLite PRAGMA synchronous = FULL)

Safest mode. Every commit is immediately durable. Required for financial/critical data.

Implementations

impl SyncMode

pub fn from_sqlite_pragma(value: u32) -> Self

Convert from SQLite synchronous pragma value

pub fn to_sqlite_pragma(self) -> u32

Convert to SQLite synchronous pragma value

pub fn parse(s: &str) -> Option<Self>

Parse from string (case-insensitive)

Trait Implementations

impl Clone for SyncMode

fn clone(&self) -> SyncMode

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Copy for SyncMode

impl Debug for SyncMode

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Eq for SyncMode

impl PartialEq for SyncMode

fn eq(&self, other: &SyncMode) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl StructuralPartialEq for SyncMode