absurder-sql 0.1.23

AbsurderSQL - SQLite + IndexedDB that's absurdly better than absurd-sql
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66

// Filesystem Persistence Demo
// Compile with: cargo run --example persist_demo --features fs_persist

#[cfg(not(target_arch = "wasm32"))]
use absurder_sql::storage::BlockStorage;

#[cfg(not(target_arch = "wasm32"))]
#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    println!("📁 Filesystem Persistence Demo\n");

    // Create database with filesystem persistence
    let mut storage = BlockStorage::new("my_database").await?;
    println!("Created database (data stored in ./absurdersql_storage/my_database/)\n");

    // Allocate and write blocks
    println!("Writing data...");
    let block1 = storage.allocate_block().await?;
    let block2 = storage.allocate_block().await?;

    storage.write_block(block1, vec![1u8; 4096]).await?;
    storage.write_block(block2, vec![2u8; 4096]).await?;
    println!("Wrote 2 blocks (block {} and {})", block1, block2);

    // Sync to disk
    println!("\nSyncing to filesystem...");
    storage.sync().await?;
    println!("Data persisted to disk");
    println!("  Files created:");
    println!(
        "    - ./absurdersql_storage/my_database/blocks/block_{}.bin",
        block1
    );
    println!(
        "    - ./absurdersql_storage/my_database/blocks/block_{}.bin",
        block2
    );
    println!("    - ./absurdersql_storage/my_database/metadata.json");
    println!("    - ./absurdersql_storage/my_database/allocations.json");

    // Close and reopen
    drop(storage);
    println!("\n🔄 Reopening database from disk...");

    let storage2 = BlockStorage::new("my_database").await?;
    println!("Database reopened");

    // Read persisted data
    let data1 = storage2.read_block(block1).await?;
    let data2 = storage2.read_block(block2).await?;

    println!("\nRead persisted data:");
    println!("  Block {}: first byte = {}", block1, data1[0]);
    println!("  Block {}: first byte = {}", block2, data2[0]);

    println!("\nFilesystem persistence working!");
    println!("\nCheck ./absurdersql_storage/my_database/ to see the .bin files");

    Ok(())
}

#[cfg(target_arch = "wasm32")]
fn main() {
    // This example is not supported on WASM
    panic!("persist_demo is only supported on native targets with fs_persist feature");
}