ScramDB is under active development. The following features are not yet supported or have known limitations.
SQL Features - Not Yet Supported
| Feature | Status | Target |
|---|
Recursive CTEs (WITH RECURSIVE) | ⚠️ Planned | - |
Prepared statements (PREPARE / EXECUTE) | ⚠️ Planned | v28 |
EXPLAIN ANALYZE (per-operator metrics) | ⚠️ Planned | v28 |
MERGE (UPSERT) | ⚠️ Planned | v28 |
LATERAL joins | ⚠️ Planned | v28 |
| Stored procedures / functions | ❌ Not planned | - |
| Triggers | ❌ Not planned | - |
| Foreign data wrappers | ❌ Not planned | - |
Full-text search (tsvector) | ❌ Not planned | - |
Data Types - Not Yet Supported
| Type | Status | Target |
|---|
UUID | ⚠️ Planned | v28 |
JSONB | ⚠️ Planned | v28 |
ARRAY types | ⚠️ Planned | v28 |
BYTEA | ⚠️ Planned | - |
SERIAL / BIGSERIAL | ⚠️ Planned | v27 |
NUMERIC(p,s) arbitrary precision | ⚠️ Planned | v28 |
MONEY | ❌ Not planned | - |
XML | ❌ Not planned | - |
Known Limitations
- Single-node only: No distributed query execution (planned)
- No collation support: String comparisons are byte-wise (UTF-8 binary order)
- No partial indexes:
CREATE INDEX ... WHERE is not supported
- No expression indexes:
CREATE INDEX ... ON (lower(name)) is not supported
- COUNT(DISTINCT): Performance is not yet fully optimized for scale factor 10 or larger
- STDDEV / VARIANCE: Performance for large datasets may be slower than basic aggregations
- Connection pooling: No built-in connection pooler - use PgBouncer or similar