Completed features: COMPLETED.md | 933 tests passing
Last cleaned: 2026-04-11
✅ Fully complete: Dashboard overview (stats, tables, ingestion chart, drop rate), Cluster dashboard (topology, distribution, time-series), Query editor (all QE-1~15), Table schema browser
| Task | Why | Effort |
|---|
Website (zeptodb.com) | ✅ Astro Starlight site built (zeptodb-site/). All pages complete | — |
↳ Landing page | ✅ Hero + benchmark comparison + use case cards + CTA | — |
↳ Features / Performance / Use Cases | ✅ Features, Benchmarks, 4 use-case pages, 4 competitor comparisons | — |
↳ Pricing / Blog / About | ✅ Pricing (Community/Enterprise), 4 blog posts, About, Contact | — |
Docs site deployment automation | ✅ GitHub Actions build-deploy.yml + sync-docs.mjs | — |
Use Cases page | ✅ Trading, IoT, Robotics, Autonomous Vehicles | — |
Blog (devlog migration) | ✅ 4 posts from devlogs (Intro, ASOF JOIN, Zero-Copy Python, Lock-Free Ingestion) | — |
| Blog: additional devlog migration | Remaining 46 devlogs → blog posts for SEO long-tail | S |
| Task | Why | Effort |
|---|
| YouTube / Loom demo video | 2-minute demo video. Embed in README + landing page. 3x conversion vs text | S |
| Task | Why | Effort |
|---|
Multi-arch Docker (amd64 + arm64) | ✅ Release workflow builds amd64. arm64 build in CI | — |
GitHub Releases + binaries | ✅ Release workflow: amd64 + arm64 tarballs on tag push | — |
Homebrew Formula | ✅ homebrew-tap repo + auto-update workflow on release | — |
PyPI package (pip install zeptodb) | ⚠️ Workflow ready, but PyPI trusted publisher not configured. Manual: pypi.org → Manage → Publishing → add ZeptoDB/ZeptoDB workflow release.yml environment pypi | XS |
| Task | Guide Document | Prerequisites | Effort |
|---|
| Configure PyPI trusted publisher | pypi.org → Manage → Publishing | PyPI account with zeptodb project | XS |
| Configure TestPyPI trusted publisher | test.pypi.org → Manage → Publishing (env: testpypi, workflow: test-pypi.yml) | TestPyPI account | XS |
| Enable GitHub Discussions | repo Settings → Features → Discussions | — | XS |
| Submit Awesome Time-Series DB PR | docs/community/REGISTRY_SUBMISSIONS.md | GitHub repo public | XS |
| Submit DB-Engines registration form | docs/community/REGISTRY_SUBMISSIONS.md | zeptodb.com live | XS |
| Record demo GIF | asciinema rec → convert to GIF → uncomment in README | Docker image | XS |
| Post Show HN | docs/community/LAUNCH_POSTS.md | Docker image + website + Discord | XS |
| Post on Reddit (5 subreddits) | docs/community/LAUNCH_POSTS.md | 1-2 day gap after Show HN | XS |
Runtime license-gated feature tiers. Single binary, license key activates features.
Design principle: features are visible but gated — CLI, Web UI, HTTP API all show upgrade prompts.
| Task | Why | Effort |
|---|
| License key validator | Signed JWT license key — verify edition/expiry at startup. include/zeptodb/auth/license_validator.h | M |
| Feature gate helper | license::hasFeature(Feature::Cluster) check + 402 error response helper | S |
| Startup banner with edition | [INFO] ZeptoDB v0.x.x (Community Edition) + upgrade hints in log | XS |
| Trial key support | 30-day Enterprise trial key generation + expiry enforcement | S |
| Feature to Gate | Where | Effort |
|---|
| SSO / SAML / OIDC login | auth/sso_provider.h — return 402 on Community | S |
| Audit log export | auth/audit_buffer.h — buffer works, export endpoint gated | S |
| Advanced RBAC | Row-level security, column masking — gate in executor | M |
| Per-tenant rate limiting | server/rate_limiter.h — basic=Free, per-tenant=Pro | S |
| Kafka/Pulsar connectors | feeds/kafka_consumer.h — gate on startup | XS |
| Feature to Gate | Where | Effort |
|---|
| Multi-node cluster | cluster/* — gate ClusterNode::start(), addNode() | S |
| Live rebalancing | cluster/rebalance_* — gate rebalance API endpoints | S |
| Geo-replication | Gate when implemented | — |
| EKS/K8s operator | Helm chart available, operator gated | S |
| Rolling upgrade | Gate upgrade coordinator endpoint | S |
| kdb+/ClickHouse migration | migration/* — gate migrator startup | XS |
| Task | Why | Effort |
|---|
| Gated feature cards | Sidebar shows Cluster/SSO/Audit menus → click shows upgrade modal with [View Plans] | S |
/api/license endpoint | Returns current edition + feature list for UI to render gates | XS |
| Pricing page link | zeptodb.com/pricing in all gate messages | XS |
| Task | Why | Effort |
|---|
| 402 response standard | {"error":"enterprise_required","message":"...","upgrade_url":"https://zeptodb.com/pricing"} | XS |
/admin/license endpoint | Show current license info, accept license key upload | S |
✅ Fully complete (Arrow Flight server). No remaining items.
| Task | Why | Effort |
|---|
| ClickHouse wire protocol | Native connection for DBeaver, DataGrip, Grafana | L |
| JDBC/ODBC drivers | Tableau, Excel, Power BI | L |
| Task | Why | Effort |
|---|
| Kafka Connect Sink | Enterprise data pipeline standard | M |
| CDC connector | PostgreSQL/MySQL → real-time sync | M |
| AWS Kinesis consumer | AWS-native streaming | S |
| Apache Pulsar consumer | Kafka alternative | S |
| Task | Why | Effort |
|---|
| Cloud Marketplace | AWS/GCP one-click deployment | M |
| Geo-replication | Multi-region, global trading desks | L |
| SAML 2.0 support | For SAML-only environments such as banks/insurance | L |
✅ Already done: Vault-backed API Key Store, OIDC Discovery, SSO login flow, JWT Refresh, Server-side sessions, IdP group→role mapping
| Task | Engine Impact | Effort |
|---|
| Composite index | 🔴 Major | M |
MV query rewrite | ✅ Done (devlog 064) | — |
| Cost-based planner | 🔴 Major | L |
| JOINs/Window on virtual tables | 🟠 Moderate | M |
| SIMD-ify WindowJoin aggregate loop | 🟠 Moderate | M |
| JIT SIMD emit | — | L |
| DuckDB embedding | — | M |
| Limited DSL AOT compilation | — | M |
✅ Already done: Tier A (INTERVAL, Prepared statements, Query result cache, SAMPLE, Scalar subqueries), FlatHashMap joins
✅ P8-Critical, P8-High, P8-Medium all complete.
| Task | Impact | Effort |
|---|
| WAL replication RDMA PUT | Remove ingest throughput bottleneck. TCP ~50μs → RDMA ~1-2μs | M |
| Remote column scan RDMA GET | Zero DataNode CPU overhead for scatter-gather queries | L |
| Partition migration RDMA GET | Zero service impact on source node during live rebalancing | M |
| Failover re-replication RDMA GET | Minimize replica replication overhead on node failure | M |
remote_ingest_regions_ wire-up | Actual connection of RDMA ingest path | S |
| Task | Why | Effort |
|---|
Live rebalancing | ✅ Done (devlog 055) | — |
Dual-write ingestion wiring | ✅ Done (devlog 055) | — |
Multi-node benchmark execution | ✅ Rebalance load test done (devlog 056) | — |
Partial-move rebalance API | ✅ Done (devlog 058) — start_move_partitions() + HTTP move_partitions action | — |
Rebalance query routing safety | ✅ Done (devlog 057) — recently_migrated() grace period | — |
peer_rpc_clients_ thread safety | ✅ Done (devlog 057) — shared_mutex in ClusterNode | — |
Move timeout enforcement | ✅ Done (devlog 057) — move_timeout_sec in RebalanceConfig | — |
Rebalance progress in Web UI | ✅ Done (devlog 059) — cluster dashboard rebalance panel | — |
Rebalance bandwidth throttling | ✅ Done (devlog 062) — BandwidthThrottler rate limiter, 10 tests | — |
Rebalance history endpoint | ✅ Done (devlog 060) — /admin/rebalance/history + Web UI table | — |
| Tier C cold query offload | Historical data → DuckDB on S3 | M |
PTP clock sync detection | ✅ Done (devlog 063) — PtpClockDetector with strict mode | — |
| Global symbol registry | Distributed string symbol routing — rebalance must migrate symbol dictionary | M |
| Task | Why | Effort |
|---|
| MQTT ingestion | IoT devices | S |
| OPC-UA connector | Siemens S7, industrial PLCs | M |
| ROS2 plugin | ROS2 topics → ZeptoDB | M |
| Task | Why | Effort |
|---|
| User-Defined Functions | Python/WASM UDF | L |
| Pluggable partition strategy | symbol_affinity / hash_mod / site_id | M |
Edge mode (--mode edge) | Single node + async cloud sync | M |
| HyperLogLog | Distributed approximate COUNT DISTINCT | S |
| Variable-length strings | Logs, comments, and other free-text | M |
| HDB Compaction | Parquet merge | S |
| Snowflake/Delta Lake hybrid | — | M |
| Graph index (CSR) | Fund flow tracking | L |
| InfluxDB migration | InfluxQL → SQL | S |
| Priority | Category | Remaining | Next Action |
|---|
| P1 | Demo-ready UI | ✅ 0 | Complete |
| P2 | Website + Distribution | 2 + 8 manual | PyPI trusted publisher, Blog expansion |
| P2.5 | Monetization (Edition) | 18 | License validator, Feature gates |
| P3 | Connectivity | ✅ 0 | Complete |
| P4 | Tool Integration | 2 | ClickHouse protocol, JDBC/ODBC |
| P5 | Data Pipelines | 4 | Kafka Connect, CDC |
| P6 | Enterprise / Cloud | 3 | SAML, Geo-replication, Marketplace |
| P7 | Engine Performance | 7 | Composite index, Cost-based planner |
| P8 | Cluster | 14 | RDMA transport, Rebalance hardening |
| P9 | Physical AI / IoT | 3 | MQTT, OPC-UA, ROS2 |
| P10 | Extensions | 9 | UDF, Edge mode |
Total remaining: 62 items + 8 manual tasks
Critical path: P2.5 (license system) → P8 (cluster) → P4 (Tool Integration)
