overdrive-db 1.4.1

#afot #OverDriveDb #InCodeSDK #EmbeddedDB

What is OverDrive?

OverDrive is an embeddable, zero-config document database for Rust, Python, Node.js, Java, Go, and C/C++. It stores JSON documents, supports SQL queries, full-text search, secondary indexing, and ACID transactions — all within a single library. No external server. No network. Just a file.

Quick Start

Install

Python:

pip install overdrive-db

Node.js:

npm install overdrive-db

Java (Maven):

<dependency>
    <groupId>com.afot</groupId>
    <artifactId>overdrive-db</artifactId>
    <version>1.4.0</version>
</dependency>

Go:

go get github.com/ALL-FOR-ONE-TECH/OverDrive-DB_IncodeSDK/go@v1.4.0

Rust:

[dependencies]
overdrive-db = "1.4.0"

Note: The Rust crate dynamically loads the prebuilt native library at runtime. Download overdrive.dll / liboverdrive.so / liboverdrive.dylib from GitHub Releases and place it in your project directory.

Hello World — 3 Lines

Python

from overdrive import OverDrive

db = OverDrive.open("myapp.odb")
db.insert("users", {"name": "Alice", "age": 30})  # table auto-created
print(db.query("SELECT * FROM users"))
db.close()

Node.js

const { OverDrive } = require('overdrive-db');

const db = OverDrive.open('myapp.odb');
db.insert('users', { name: 'Alice', age: 30 });  // table auto-created
console.log(db.query('SELECT * FROM users'));
db.close();

Java

import com.afot.overdrive.OverDrive;

try (OverDrive db = OverDrive.open("myapp.odb")) {
    db.insert("users", Map.of("name", "Alice", "age", 30));
    System.out.println(db.query("SELECT * FROM users"));
}

Go

db, _ := overdrive.Open("myapp.odb")
defer db.Close()
db.Insert("users", map[string]any{"name": "Alice", "age": 30})
result, _ := db.Query("SELECT * FROM users")
fmt.Println(result.Rows)

Rust

use overdrive::OverDriveDB;

let mut db = OverDriveDB::open("myapp.odb").unwrap();
db.create_table("users").unwrap();
let id = db.insert("users", &serde_json::json!({"name": "Alice", "age": 30})).unwrap();
let result = db.query("SELECT * FROM users WHERE age > 25").unwrap();
println!("{} users found in {:.2}ms", result.rows.len(), result.execution_time_ms);
db.close().unwrap();

v1.4.0 — What's New

Password-protected databases

db = OverDrive.open("secure.odb", password="my-secret-pass")

RAM engine for sub-microsecond caching

cache = OverDrive.open("cache.odb", engine="RAM")
cache.insert("sessions", {"user_id": 123, "token": "abc"})
cache.snapshot("./backup/cache.odb")   # persist to disk
usage = cache.memoryUsage()            # {"bytes": ..., "mb": ..., "percent": ...}

File integrity monitoring

report = OverDrive.watchdog("app.odb")
if report.integrity_status == "corrupted":
    print(f"Corruption: {report.corruption_details}")

Transaction callbacks

result = db.transaction(lambda txn:
    db.insert("orders", {"item": "widget"})
)  # auto-commits on success, auto-rolls back on exception

Helper methods

user    = db.findOne("users", "age > 25")
users   = db.findAll("users", order_by="name", limit=10)
count   = db.updateMany("users", "status = 'trial'", {"status": "active"})
deleted = db.deleteMany("logs", "created_at < '2025-01-01'")
n       = db.countWhere("users", "active = 1")
exists  = db.exists("users", "users_1")

All 6 Storage Engines

# Select engine on open
db = OverDrive.open("app.odb", engine="RAM")

# Or per-table
db = OverDrive.open("app.odb")
db.createTable("hot_cache", engine="RAM")   # this table in RAM
db.insert("users", {"name": "Alice"})       # this table on disk (auto-created)

Security

# Never hardcode passwords — use environment variables
import os
db = OverDrive.open("secure.odb", password=os.environ["DB_PASSWORD"])

# Or use the env-var method
db = OverDrive.open_encrypted("app.odb", "ODB_KEY")

# Safe parameterized queries
results = db.querySafe("SELECT * FROM users WHERE name = ?", user_input)

Downloads

Documentation

Project Structure

OverDrive-DB_IncodeSDK/
├── Cargo.toml              # Rust crate (dynamic loader)
├── README.md               # This file
├── LICENSE
│
├── src/
│   ├── lib.rs              # OverDriveDB Rust API
│   ├── dynamic.rs          # Runtime native library loader
│   ├── ffi.rs              # C FFI exports
│   ├── shared.rs           # Thread-safe SharedDB wrapper
│   ├── query_engine.rs     # SQL query types
│   └── result.rs           # Error types
│
├── python/overdrive/
│   └── __init__.py         # Python SDK (ctypes)
│
├── nodejs/
│   ├── index.js            # Node.js SDK (koffi)
│   └── index.d.ts          # TypeScript definitions
│
├── java/src/
│   └── .../OverDrive.java  # Java SDK (JNA)
│
├── go/
│   └── overdrive.go        # Go SDK (CGo)
│
├── c/include/
│   └── overdrive.h         # C/C++ header
│
├── docs/                   # Full documentation
├── examples/               # Working code examples
└── .github/workflows/      # CI/CD pipelines

Comparison

Links

License

Licensed under either of:

• MIT License (LICENSE)
• Apache License 2.0 (LICENSE)

at your option.

#afot #OverDriveDb #InCodeSDK #EmbeddedDB #MrV2K #AllForOneTech #HybridDB