Connection Strings Reference

Data Source=path/to/database.witdb;Property1=Value1;Property2=Value2

// Minimal
"Data Source=app.witdb"

// In-memory (testing)
"Data Source=:memory:"

// With encryption
"Data Source=secure.witdb;Encryption=aes-gcm;Password=MySecret123!"

// High-performance writes (LSM-Tree)
"Data Source=/data/logs;Store=lsm;Sync Writes=false"

// Read-only access
"Data Source=archive.witdb;Mode=ReadOnly;Cache Size=10000"

// Production with pooling
"Data Source=/var/app/data.witdb;Encryption=aes-gcm;Password=***;Pooling=true;Max Pool Size=50"

// File-based database
"Data Source=myapp.witdb"
"Data Source=C:\\Data\\myapp.witdb"
"Data Source=/var/lib/myapp/data.witdb"

// In-memory (non-persistent)
"Data Source=:memory:"

// Relative path
"Data Source=./data/app.witdb"

"Data Source=app.witdb;Mode=ReadOnly"
"Data Source=app.witdb;Read Only=true"  // Equivalent
"Data Source=temp;Mode=Memory"          // In-memory

// B+Tree (default) — general purpose
"Data Source=app.witdb;Store=btree"

// LSM-Tree — write-optimized
"Data Source=logs.witdb;Store=lsm"

// In-memory — testing
"Data Source=:memory:;Store=inmemory"

// Simple password encryption
"Data Source=secure.witdb;Encryption=aes-gcm;Password=MySecretPassword123!"

// Multi-tenant (different keys per user)
"Data Source=multi.witdb;Encryption=aes-gcm;User=tenant1;Password=TenantPass123"

// ChaCha20 for Blazor WASM or ARM without AES-NI
"Data Source=app.witdb;Encryption=chacha20-poly1305;Password=MyPassword"

// Fast encryption for Blazor WASM (fewer PBKDF2 iterations)
"Data Source=wasm.witdb;Encryption=aes-gcm;Password=WasmPass;Fast Encryption=true"

// Good: from environment
var password = Environment.GetEnvironmentVariable("DB_PASSWORD");
$"Data Source=app.witdb;Encryption=aes-gcm;Password={password}"

// Good: from configuration
var password = Configuration["Database:Password"];

// Default caching
"Data Source=app.witdb"

// Large cache for read-heavy workload
"Data Source=app.witdb;Cache Size=10000"

// Large page size for BLOB storage
"Data Source=files.witdb;Page Size=16384;Cache Size=2000"

// Memory-constrained (Blazor WASM)
"Data Source=app.witdb;Cache Size=300;Page Size=4096"

// Default (transactions enabled, ReadCommitted)
"Data Source=app.witdb"

// Snapshot isolation (recommended for read-heavy)
"Data Source=app.witdb;Isolation Level=Snapshot"

// Disable transactions (maximum performance, no ACID guarantees)
"Data Source=cache.witdb;Transactions=false"

// Disable MVCC (single-writer scenarios)
"Data Source=app.witdb;MVCC=false"

// Rollback journal instead of WAL
"Data Source=app.witdb;Journal=rollback"

// Default (single writer, file locking)
"Data Source=app.witdb"

// Disable file locking (single-process only!)
"Data Source=app.witdb;File Locking=false"

// Custom lock timeout (60 seconds)
"Data Source=app.witdb;Lock Timeout=60"

// Parallel writes for high-throughput
"Data Source=app.witdb;Parallel Mode=Auto;Max Writers=8"

// Simple file database
"Data Source=dev.witdb"

// In-memory for unit tests
"Data Source=:memory:"

// With encryption and connection pooling
"Data Source=/var/app/data.witdb;Encryption=aes-gcm;Password=***;Pooling=true;Max Pool Size=50;Isolation Level=Snapshot"

// User-specific encrypted database
var appData = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData);
$"Data Source={appData}/MyApp/data.witdb;Encryption=aes-gcm;Password={userPassword}"

// Large cache, LRU for sequential scans
"Data Source=analytics.witdb;Mode=ReadOnly;Cache Size=20000;Cache=lru"

// Optimized for browser: small cache, fast encryption
"Data Source=app.witdb;Encryption=aes-gcm;Password=***;Fast Encryption=true;Cache Size=300"

// High-throughput logging (async writes, large buffers)
"Data Source=/data/logs;Store=lsm;Sync Writes=false;MemTable Size=16777216;Block Cache Size=134217728"

// Memory-constrained environment
"Data Source=/data/app;Store=lsm;MemTable Size=2097152;Block Cache Size=16777216"

// Maximum durability (sync every write)
"Data Source=/data/financial;Store=lsm;Sync Writes=true;LSM WAL=true"

// Disable compaction (manual control)
"Data Source=/data/bulk;Store=lsm;Background Compaction=false"

// Basic pooling for web applications
"Data Source=app.witdb;Pooling=true"

// Production web API with tuned pool
"Data Source=app.witdb;Pooling=true;Min Pool Size=5;Max Pool Size=50"

// High-load API server
"Data Source=app.witdb;Pooling=true;Min Pool Size=10;Max Pool Size=200;Connection Lifetime=3600"

// With encryption
"Data Source=secure.witdb;Encryption=aes-gcm;Password=***;Pooling=true;Max Pool Size=50"

// Clear specific pool
WitDbConnection.ClearPool(connectionString);

// Clear all pools
WitDbConnection.ClearAllPools();

// Indexes on fast SSD, data on HDD
"Data Source=/hdd/data.witdb;Index Directory=/ssd/indexes"

using OutWit.Database.AdoNet;

var builder = new WitDbConnectionStringBuilder
{
    DataSource = "/var/app/data.witdb",
    Store = "btree",
    Encryption = "aes-gcm",
    Password = Configuration["Database:Password"],
    CacheSize = 5000,
    IsolationLevel = WitDbIsolationLevel.Snapshot,
    Pooling = true,
    MaxPoolSize = 50
};

var connectionString = builder.ConnectionString;
// Result: "Data Source=/var/app/data.witdb;Store=btree;Encryption=aes-gcm;Password=***;..."

var builder = new WitDbConnectionStringBuilder(existingConnectionString);

// Read properties
Console.WriteLine(builder.DataSource);      // "/var/app/data.witdb"
Console.WriteLine(builder.Encryption);      // "aes-gcm"
Console.WriteLine(builder.CacheSize);       // 5000

// Modify
builder.CacheSize = 10000;
var newConnectionString = builder.ConnectionString;

var builder = new WitDbConnectionStringBuilder
{
    DataSource = "app.witdb",
    Encryption = "aes-gcm"
    // Missing Password!
};

// Check for errors
var errors = builder.Validate();
foreach (var error in errors)
{
    Console.WriteLine(error);  // "Password is required when encryption is enabled."
}

// Or throw exception
builder.ThrowIfInvalid();  // Throws ArgumentException

public enum WitDbConnectionMode
{
    ReadWriteCreate,  // Default
    ReadWrite,
    ReadOnly,
    Memory
}

public enum WitDbIsolationLevel
{
    ReadUncommitted,
    ReadCommitted,    // Default
    RepeatableRead,
    Serializable,
    Snapshot
}

public enum WitDbParallelMode
{
    None,       // Default - single writer
    Auto,       // Recommended - automatic selection
    Buffered,   // Buffer writes, batch commit
    Latched,    // Page-level latching
    Optimistic  // Optimistic concurrency
}