EKS Architecture Benchmark: amd64 vs arm64, 76/76 PASS
Kubernetes compatibility, HA, and performance evidence from ZeptoDB amd64 and arm64 EKS test runs.
Read articleBlog
Latest Posts
Section titled “Latest Posts”Introducing ZeptoDB
Why we built ZeptoDB: a source-available microsecond time-series database that now adds Agent Memory, prompt cache, and zero-copy Python.
Read articleSSO and JWT Authentication: From JWKS to Multi-IdP Support
How ZeptoDB evolved its authentication from static JWT keys to full SSO with JWKS auto-fetch, multi-IdP routing, group-to-role mapping, OIDC discovery, and token refresh.
Read articleThe Robot Memory Experiment That Changed Our Roadmap
Why a misleadingly successful robot action changed how ZeptoDB thinks about Physical AI memory, replayable evidence, and experiment-driven product boundaries.
Read articleBest Database for AI Agents on Live Data
A concise answer for teams evaluating database for AI agents live data, including when ZeptoDB Agent Memory fits, how it works, and where to start.
Read articleWhat is Agent Memory?
A concise definition of agent memory for operational AI agents, including durable recall, live evidence, prompt cache, and replayable AgentOps context.
Read articleWhy Agent Memory Needs Time-Series Data
Keep agent memory, prompt cache, AgentOps telemetry, and live time-series evidence on one replayable timeline.
Read articleAgent Memory Benchmarks: Search, Context, Cache, and Snapshots
ZeptoDB Agent Memory benchmark results for filtered memory search, context assembly, exact cache lookup, semantic cache lookup, and sidecar snapshot persistence.
Read articleFrom Time-Series to Agent Memory: Real-Time Agents on ZeptoDB
How ZeptoDB adds scoped recall, context assembly, prompt cache, and decision write-back to live time-series data.
Read articleAggressive SIMD/JIT Optimization: From 2x to 4.2x Speedup
How ZeptoDB closed the gap with kdb+ using BitMask filtering, 4-way unrolled accumulators, and LLVM JIT O3 passes — with detailed benchmark results.
Read articleARM Graviton: 766/766 Tests Passing, 3x Faster GROUP BY
Cross-platform ZeptoDB verification on AWS Graviton, covering tests, Highway SIMD, LLVM JIT, and measured performance.
Read articleArrow Flight Server: High-Throughput Data Streaming
Stream ZeptoDB query results to Python, Polars, and DuckDB over gRPC with Arrow Flight and Arrow IPC.
Read articleAutomatic Materialized View Query Rewrite
How ZeptoDB transparently redirects GROUP BY queries to pre-aggregated materialized views — turning O(n) partition scans into O(1) bucket lookups.
Read articleBandwidth Throttling and PTP Clock Sync for Distributed Clusters
How ZeptoDB prevents network saturation during rebalancing with a sliding-window rate limiter, and ensures ASOF JOIN correctness with PTP clock synchronization detection.
Read articleBare-Metal Performance Tuning for Microsecond Latency
A practical guide to CPU pinning, NUMA, huge pages, io_uring, and compiler optimizations — with real benchmark numbers from ZeptoDB on Intel Xeon.
Read articleBuilding a Cost-Based Query Planner from Scratch
How ZeptoDB built a cost-based query planner in 7 phases — from HyperLogLog statistics to physical plan generation to EXPLAIN v2 with cost estimates.
Read articleBuilding a SQL Parser, HTTP API, and JOIN Framework
How ZeptoDB implements a recursive descent SQL parser, ClickHouse-compatible HTTP API, and ASOF JOIN — the three pillars of a queryable time-series database.
Read articleCluster Integrity and Split-Brain Defense
How ZeptoDB prevents data corruption during network partitions using fencing tokens, epoch-based RPC validation, and Kubernetes lease integration.
Read articleCluster Stability Hardening: 15 Fixes for Production Readiness
Distributed-layer fixes for thread pools, connection limits, snapshots, deadlocks, and state-machine migrations.
Read articleComposite Index with Index Intersection
Replacing single-winner index selection with a collect-and-intersect approach that combines multiple indexes per partition scan for multi-predicate queries.
Read articleCoordinator HA and Automatic Failover Recovery
ZeptoDB coordinator failover with Kubernetes leader leases, health detection, and automatic re-replication.
Read articleData Durability: Intra-Day Snapshots and Crash Recovery
How ZeptoDB achieves sub-minute RPO for in-memory data with periodic snapshots, LZ4-compressed binary format, and single-threaded recovery before drain threads start.
Read articleDDL and Schema Management in a Time-Series Database
Implementing CREATE TABLE, DROP TABLE, ALTER TABLE, and TTL-based retention in ZeptoDB — from schema registry to automatic partition eviction.
Read articleDictionary-Encoded String Columns for Time-Series
How ZeptoDB implements kdb+-style symbol interning with dictionary encoding — enabling WHERE symbol = 'AAPL' while maintaining integer-speed query performance.
Read articleDistributed Cluster Architecture: Sharding, Routing, and Replication
How ZeptoDB scales horizontally with CRTP transport abstraction, consistent hashing, and UDP health monitoring — all with zero virtual call overhead on the hot path.
Read articleDistributed Query Correctness: VWAP and ORDER BY Across Nodes
How ZeptoDB decomposes VWAP, HAVING, DISTINCT, and window functions for correct distributed execution using scatter-gather and partial aggregation.
Read articleEmbedding DuckDB for Analytical Offload via Arrow
How ZeptoDB embeds DuckDB as an in-process analytical engine for Parquet queries — with Arrow columnar bridging and a duckdb() table function.
Read articleFailover Data Recovery: Automatic Re-Replication
How ZeptoDB automatically re-replicates data when a node fails — PartitionMigrator integration, async recovery threads, and graceful fallback for unregistered nodes.
Read articleFinancial Functions for Time-Series: xbar, EMA, VWAP, and Window JOIN
Implementing kdb+-style financial analysis in SQL — xbar time bucketing, exponential moving averages, delta/ratio calculations, and Window JOIN for real-time analytics.
Read articleFlatHashMap: Why We Replaced std::unordered_map for JOINs
How a custom open-addressing hash map with CRC32 hardware hashing eliminated pointer chasing and cache misses in ZeptoDB's JOIN operators.
Read articleGranular API Key Access Control
How ZeptoDB implements per-key symbol and table ACLs, tenant binding, key expiry, and in-place editing for fine-grained API key management.
Read articleGROUP BY Optimization with Timestamp Range Index
How ZeptoDB exploits sorted timestamps and partition-per-symbol structure to make GROUP BY and time range queries orders of magnitude faster.
Read articleHDB Tiered Storage: From Memory to Parquet to S3
ZeptoDB hot, warm, and cold storage across memory, compressed NVMe data, Parquet, and S3.
Read articleHealth Monitor: DEAD Recovery and UDP Fault Tolerance
How ZeptoDB's HealthMonitor handles DEAD node recovery via the REJOINING state, consecutive miss counting, TCP heartbeat fallback, and fatal bind failure detection.
Read articleHelm Chart and Zero-Downtime Rolling Upgrades
ZeptoDB Helm upgrade patterns using disruption budgets, config checksums, canaries, and rollback.
Read articleHTTP Server Observability: Structured Logging and Request Tracing
How ZeptoDB's HTTP server provides production-grade observability — structured JSON access logs, slow query detection, X-Request-Id tracing, and Prometheus metrics.
Read articleInternal RPC Security: Shared-Secret HMAC and mTLS
How ZeptoDB secures inter-node RPC communication with FNV-1a HMAC authentication, nonce-based replay protection, and a path toward mutual TLS.
Read articleJIT SIMD Emit: Generating AVX2 Vector IR in LLVM
How ZeptoDB's JIT engine generates four-lane i64 SIMD vector IR in LLVM, including reliable vectorization and cttz mask extraction.
Read articleKubernetes Compatibility and HA Testing
A live EKS test suite for ZeptoDB Helm, pod lifecycle, networking, rolling updates, and failure recovery.
Read articleLive Rebalancing: Zero-Downtime Partition Migration
How ZeptoDB moves partitions between nodes without data loss using dual-write ingestion, a state machine for migration lifecycle, and crash-recoverable checkpoints.
Read articleParallel Query Engine: From Single-Core to Multi-Node
How ZeptoDB's QueryScheduler abstraction enables partition-level parallelism today and distributed execution tomorrow — without changing the executor.
Read articleParquet on S3: Historical Data Storage for Time-Series
ZeptoDB historical storage with partitioned Parquet, compression, S3, DuckDB, and Polars integration.
Read articlePython Ecosystem Integration: NumPy, Pandas, and Polars
ZeptoDB integration with Arrow, NumPy, pandas, Polars, DuckDB, and vectorized batch ingestion.
Read articleQuery Editor: Charts, Multi-Tab, Multi-Statement
ZeptoDB query editor charts, persistent multi-tab editing, and sequential multi-statement execution.
Read articleRingConsensus: Lightweight Partition Ownership Protocol
Why ZeptoDB chose epoch broadcast over Raft for partition router synchronization, and how the pluggable consensus interface keeps the door open for stronger guarantees.
Read articleSIMD-ifying the Window JOIN Aggregate Loop
How ZeptoDB applies a three-tier SIMD strategy to the Window JOIN aggregate loop — contiguous fast-path, gather+SIMD for large windows, and scalar fallback.
Read articleSorted Column Index: 100-1000x Faster Range Queries
Use ZeptoDB sorted-column indexes for range lookups and connection lifecycle hooks for session management.
Read articleSQL DML: INSERT, UPDATE, DELETE for Time-Series Data
Implementing mutation operations on columnar time-series data — INSERT with auto-timestamp, in-place UPDATE, and compaction-based DELETE.
Read articleSQL Phase 2-3: Arithmetic, CASE WHEN, Date/Time, and Set Operations
Extending ZeptoDB's SQL with expression evaluation, CASE WHEN branching, temporal functions, LIKE pattern matching, and UNION/INTERSECT/EXCEPT set operations.
Read articleStorage Tiering and Materialized Views
Automatic hot/warm/cold/drop storage tiering and incremental materialized views for pre-computed aggregations in ZeptoDB.
Read articleVault-Backed API Key Store: Secrets Management for Databases
How ZeptoDB integrates HashiCorp Vault as a write-through backend for API keys, enabling multi-node key sharing and centralized secrets management.
Read articleWAL Replication: Quorum Writes, Retry, and Backpressure
How ZeptoDB's WalReplicator evolved from best-effort async to production-grade replication with quorum acknowledgment, exponential retry, and configurable backpressure.
Read articleXBAR Sorted-Scan Optimization and EXPLAIN Statement
ZeptoDB XBAR sorted scans, EXPLAIN query plans, and consistent NULL handling across executor paths.
Read articleHow ASOF JOIN Works in ZeptoDB
A deep dive into ZeptoDB's ASOF JOIN — from SQL parsing to SIMD-accelerated merge.
Read articleLock-Free Ingestion at 5.52M Events/sec
Inside ZeptoDB's MPMC ring buffer — design decisions, SIMD batch copy, and Highway vectorization.
Read articleZero-Copy Python: 522ns to NumPy
How ZeptoDB achieves sub-microsecond Python query results using memory-mapped column views.
Read articleRelease Notes
Section titled “Release Notes”| Version | Date | Highlights |
|---|---|---|
| 0.1.7 | 2026-07-10 | Current public Docker image. Use the versioned tag for reproducible quick starts and deployment checks. |