Support matrix

The durable record — every installation method, interface, SQL area, vector capability, and operational feature with verified status.

Version
Latest
v0.1.0 · latest 5 min read
On this page
  1. Installation methods
  2. Interfaces
  3. SQL
  4. Vectors
  5. Operations and security
  6. Compatibility deltas (PostgreSQL users)

Status labels: Supported (verified working) · Limited (works with stated restrictions) · Experimental (available, not established) · Planned (not available; roadmap only) · Unsupported (not available). Evidence for key claims is recorded in the restructure report (docs/DOCS_RESTRUCTURE_REPORT.md); tutorials link to the authoritative reference for each feature.

Installation methods#

Method Status Notes
Native binaries (.dmg, .exe/.zip, .deb, .rpm, .tar.gz + SHA256SUMS.txt) Supported Per tagged release; verify checksums.
Shell installer (install.sh, macOS/Linux) Supported Checksum-enforced; Windows explicitly out of scope.
Docker image (plomid/plomid:<tag>) Supported Binary-only runtime, unprivileged user, volume required.
Build from source Supported Pinned Rust toolchain; contributor gates documented.
Offline / air-gapped (pre-staged artifacts) Supported Same binaries; installer needs network, so not used here.
Docker Compose file Unsupported None ships; the docker run path is verified.
Kubernetes / Helm / operator Planned Nothing ships; do not expect manifests.
Hosted package repos (apt/yum/Homebrew as hosted repos) Limited Homebrew tap refresh is best-effort per release; no hosted apt/yum repos.

Interfaces#

Interface Status Notes
PostgreSQL wire protocol v3 (simple + extended, prepared statements) Supported Verified with psql, psycopg 3, node-postgres.
psql / DBeaver / GUI PG clients Supported Same parameters as any PostgreSQL connection.
Python (psycopg) Supported Parameters incl. text vector params; see Python guide.
JavaScript/TypeScript (pg) Supported BIGINT arrives as strings (driver behavior); text vector params.
Other PG drivers Limited Same protocol, unverified per-driver — test prepared statements + typing.
Official PLOMID SDK Unsupported None exists; use PostgreSQL drivers.
TLS transport (sslmode=require) Supported Handshake verified live; --tls-required refuses plaintext.
Binary wire values Limited Text only, except vector results (binary-encodable shapes).

SQL#

Area Status Notes
DDL/DML, joins (incl. lateral), subqueries, CTEs (WITH [RECURSIVE]), set ops, window functions, GROUPING SETS/ROLLUP/CUBE, DISTINCT [ON], FILTER, ON CONFLICT, RETURNING, EXPLAIN [ANALYZE], COPY … STDIN/STDOUT, sequences, enums/domains/composites, pg_catalog/information_schema Supported See SQL reference.
JSON/JSONB operators, constructors, JSON_TABLE Supported See JSON section.
Temporal types, EXTRACT, date_trunc, age, interval arithmetic Supported See time-series guides.
Transactions (BEGIN/COMMIT/ROLLBACK), MVCC snapshots Supported Single-writer; see transaction guides.
ILIKE Limited Parses; behaves as case-sensitive LIKE.
TABLE name, bare VALUES, SQL PREPARE/EXECUTE, RESET/DISCARD ALL, TABLESAMPLE Unsupported Syntax errors; extended-protocol prepared statements are supported.
setval() Unsupported Sequences advance via nextval only.
Savepoints Supported (connection layer) True partial rollback over ordinary connections; drivers that prepare savepoint statements may see rejection — keep transactions retryable.
EXTRACT fields Limited year month day quarter dow isodow doy hour minute second milliseconds microseconds century decade; week/epoch/millennium rejected.
GROUP BY ordinals Unsupported GROUP BY 1 rejected; repeat the expression or name the column. ORDER BY ordinals work.
FOR UPDATE Limited Accepted, ignored.
CREATE FUNCTION/PROCEDURE/TRIGGER/EXTENSION/MATERIALIZED VIEW Limited Parse to stubs without execution.
DROP ROLE / DROP USER, RENAME DATABASE Unsupported Rejected with descriptive errors.
UPDATE…FROM / COPY inside explicit transactions Unsupported Run in autocommit.
Foreign-key enforcement, cursors, stored-procedure execution, plpgsql beyond subset, file COPY, LISTEN/NOTIFY effects Unsupported See compatibility page.
CREATE/DROP DATABASE authorization Unsupported (bypass open) Any authenticated user can run them — see beta status. Do not share.
CREATE/DROP DATABASE inside a transaction Unsupported Refused; use autocommit.

Vectors#

Capability Status Notes
Dense VECTOR (FLOAT32/16, BFLOAT16, INT8/UINT8/INT4), dims 1–65536 Supported Bracket literals; strict validation.
Operators <-> <=> <#> + functions (l2/cosine/neg_inner/dot/similarity family) Supported Ordering: distances ascending, similarities descending.
Exact top-k (ORDER BY distance LIMIT k, ≤1M) Supported Deterministic (distance, row id) ordering.
HNSW index (dense × L2/cosine/dot) Supported Autocommit creation; engages with scale.
flat, ivf_flat, ivf_sq, ivf_pq, diskann declarations Limited Accepted; small scans may run exact; quantized promotions apply.
Metadata filtering (WHERE + vector order) Supported Served by exact path.
Binary vectors + Hamming/Jaccard Limited Queries correct; ANN falls back to exact.
Sparse / multivector Experimental DDL parses; no verified SQL write path.
GPU acceleration Unsupported CPU only.
Hybrid (RRF/weighted) SQL surface Unsupported Implement in application.
Distributed vector search Planned Single node only.

Operations and security#

Area Status Notes
Loopback + SCRAM auth, allow-remote-plaintext opt-in Supported Fail-closed startup validation.
TLS + --tls-required Supported Verified handshake.
--copy-dir, --audit-log, --profile Supported File-COPY jail, JSONL audit log, hardware-tier override.
plomid test run non-connectivity modules Unsupported write/persistence/recovery/performance are hard errors.
Roles, GRANT/REVOKE, database-connect gating Limited Connect gating enforced; database-DDL authorization bypass open — single-user only until fixed.
Cold full backup → clean restore (+ inspect) Supported Verified incl. vector data; no hot/incremental/PITR.
Logging, diagnostics, CLI (readiness, health, info, diagnostics, benchmark) Supported Stable connection/query IDs; no SQL values in logs.
Deployment profiles (developer, single-node offline) Supported Local use.
Secure-remote / production profiles Limited Accurate only for single-operator hosts until the DDL bypass is fixed — must not be read as multi-user-safe.
Replication, failover, multi-node, managed cloud Planned Not in v0.1.0.

Compatibility deltas (PostgreSQL users)#

ILIKE (case-fold ignored), NULL AND TRUE → false (is-true checks, not strict 3VL), COUNT(DISTINCT) dedups by text form, AVG(int) returns Numeric, default passwords differ by entrypoint (always set explicitly), no compatibility percentage claimed. Full record: SQL compatibility and For PostgreSQL users.

Was this page helpful?