PLOMID v0.1.0 Documentation, v0.1.0 docs

PLOMID is an enterprise universal database platform by DSK Solutions. It owns its database engine — it does not wrap PostgreSQL, RocksDB, ClickHouse, DuckDB, or SQLite. One logical database speaks SQL over multiple physical engines.

diagram

flowchart TB
    subgraph Clients["your tools, unchanged"]
        P["psql"] --- D["DBeaver"] --- A["any PostgreSQL driver"]
    end
    Clients -->|"PostgreSQL wire protocol"| PLOMID["PLOMID v0.1.0\none logical database"]
    PLOMID --> SQL["SQL"]
    PLOMID --> REL["relational rows"]
    PLOMID --> DOC["JSON documents"]
    PLOMID --> TS["time-series events"]
    PLOMID --> DISK["WAL + checkpoints\non your disk"]

Diagram source · mermaidcopy included

mermaidsource

flowchart TB
    subgraph Clients["your tools, unchanged"]
        P["psql"] --- D["DBeaver"] --- A["any PostgreSQL driver"]
    end
    Clients -->|"PostgreSQL wire protocol"| PLOMID["PLOMID v0.1.0\none logical database"]
    PLOMID --> SQL["SQL"]
    PLOMID --> REL["relational rows"]
    PLOMID --> DOC["JSON documents"]
    PLOMID --> TS["time-series events"]
    PLOMID --> DISK["WAL + checkpoints\non your disk"]

Version scope: everything in this section describes v0.1.0 only (workspace version 0.1.0, server_version 17.0). Every behavior is traced to the implementation.

Three ways to navigate#

LEARNWhat is PLOMID, data model, SQL fundamentals, architecture, learning paths. BUILDTask guides: create a database, insert, query JSON/time, index, transact, inspect plans. REFERENCEPrecise SQL, CLI, configuration, errors, and pg_catalog answers.

First success in 5 minutes#

Start the server

shsource

./start.sh
# defaults: host 0.0.0.0, port 5432, data ./data, user plomid, password secret

Connect with any PostgreSQL client

shsource

psql "postgresql://plomid:secret@localhost:5432/plomid"

Run your first query

sqlsource

CREATE TABLE users (id BIGINT PRIMARY KEY, name TEXT NOT NULL);
INSERT INTO users VALUES (1, 'ada'), (2, 'grace');
SELECT * FROM users ORDER BY id;

Full path: Quickstart.

What v0.1.0 actually supports#

Area	Status	Start here
SQL DDL/DML (`CREATE TABLE`, `INSERT`, `SELECT`, `UPDATE`, `DELETE`, `TRUNCATE`)	Supported	SQL overview
Joins, subqueries, CTEs (`WITH`, incl. `RECURSIVE`), set ops, window functions	Supported	SELECT, Joins
JSON/JSONB operators, constructors, `JSON_TABLE`	Supported	Query JSON
Temporal types + `EXTRACT`, `date_trunc`, `age`, interval arithmetic	Supported	Query time
B-tree + in-memory ART indexes, unique/PK enforcement	Supported	Indexes
Transactions (`BEGIN`/`COMMIT`/`ROLLBACK`), MVCC snapshots	Supported	Transactions
WAL + checkpoints + crash recovery	Supported	WAL / recovery
PostgreSQL wire protocol v3 (simple + extended, SCRAM/MD5/cleartext)	Supported	Run the server
Vector, graph, blobs, multi-region, distributed	Not available in v0.1.0	Future models

Note

Status labels used everywhere: Supported · Partial · Experimental · Internal · Not available. Roadmap ideas are never listed as supported.

Complete public surface (nothing hidden)#

SQL — full languageSELECT → DDL, CREATE FUNCTION / TYPE / DOMAIN / ROLE, window functions, permissions, compatibility. JSON — document modelOperators, every JSON function, JSON_TABLE, NULL/missing contracts. Time-seriesEvent modeling, windows, rollups, gap-filling, retention recipes. Every functionExhaustive scalar catalog — string, math, array, temporal, session, catalog. Transactions — every shape18 patterns: basics, rollbacks, atomic transfers, DDL-in-txn, conflicts. Architecture deep diveExecutor dispatch, index/storage algorithms, MVCC + filtering pipeline.

Where to go next#

New to databases? What is PLOMID? → Core concepts → SQL fundamentals
Know what to build? Create a table → Cookbook → Complex queries
Need a precise answer? CLI reference · Configuration · Errors
Operating it? Run the server · Logging & diagnostics · Troubleshooting

PLOMID v0.1.0 Documentation

Three ways to navigate#

First success in 5 minutes#

What v0.1.0 actually supports#

Complete public surface (nothing hidden)#

Where to go next#

Continue