ForgeQL (v0.2.0)

The Multi-Table Omni-Channel Database built natively on B+ Trees.

ForgeQL is an embedded, offline-first, high-performance database written entirely in Java. It features a built-in React dashboard for visual management and zero external runtime dependencies.

Quickstart

Run the database server instantly from your terminal:

npx forgeql

Or connect directly in Node.js:

const { ForgeClient } = require('forgeql');

const db = new ForgeClient('http://localhost:8080', 'admin-secret-key');

async function main() {
    await db.insert('users', 101, { name: 'Satoshi Nakamoto' });
    const user = await db.get('users', 101);
    console.log(user);

    // Forge Query Syntax (FQL)
    const results = await db.fql('FIND users WHERE role = ADMIN');
    console.log(results);
}

main();

Core Features

• B+ Tree Storage Engine: Disk-based storage with O(log n) lookups.
• Forge Query Syntax (FQL): Lightweight human-readable string query language (GET, FIND, INSERT, UPDATE, DELETE, INDEX).
• Visual Dashboard: Integrated React UI served directly from the backend.
• Role-Based Access Control (RBAC): Native ADMIN and READ_ONLY authorization.
• Write-Ahead Logging (WAL): ACID durability and automated crash recovery.
• Vector Search (HNSW): Cosine Similarity and K-Nearest Neighbors for AI embeddings.

Engine Architecture

ForgeQL operates offline. Running the CLI command boots a Spring Boot server on port 8080, exposing the REST API and Forge Studio dashboard simultaneously.