Full Kubernetes compatibility and HA/performance benchmarks on both amd64 and arm64 EKS — 76/76 tests passing, 7 bugs fixed, and arm64 confirmed production-ready with ~20% cost savings.
Read articleWhy we built ZeptoDB: a source-available microsecond time-series database that now adds Agent Memory, prompt cache, and zero-copy Python.
Read articleHow 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 articleA grounded explanation of Physical AI memory, Action-Outcome Memory, and what ZeptoDB has validated so far with ROS-style telemetry, SQL replay, and research-only robot safety fixtures.
Read articleA 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 articleA concise definition of agent memory for operational AI agents, including durable recall, live evidence, prompt cache, and replayable AgentOps context.
Read articleAgent memory is weaker when it is detached from the live event stream. ZeptoDB keeps memories, prompt cache, AgentOps telemetry, and time-series evidence on one replayable timeline.
Read articleZeptoDB Agent Memory benchmark results for filtered memory search, context assembly, exact cache lookup, semantic cache lookup, and sidecar snapshot persistence.
Read articleZeptoDB started as a microsecond time-series database. Agent Memory adds scoped recall, context assembly, prompt cache, and decision write-back so agents can reason over live data.
Read articleHow ZeptoDB closed the gap with kdb+ using BitMask filtering, 4-way unrolled accumulators, and LLVM JIT O3 passes — with detailed benchmark results.
Read articleFull cross-platform verification of ZeptoDB on AWS Graviton (aarch64) — identical test results, Highway SIMD and LLVM JIT working natively, and surprising performance wins.
Read articleHow ZeptoDB's Arrow Flight server enables remote Python, Polars, and DuckDB clients to stream query results over gRPC with near-zero-copy efficiency using the Arrow IPC protocol.
Read articleHow ZeptoDB transparently redirects GROUP BY queries to pre-aggregated materialized views — turning O(n) partition scans into O(1) bucket lookups.
Read articleHow ZeptoDB prevents network saturation during rebalancing with a sliding-window rate limiter, and ensures ASOF JOIN correctness with PTP clock synchronization detection.
Read articleA practical guide to CPU pinning, NUMA, huge pages, io_uring, and compiler optimizations — with real benchmark numbers from ZeptoDB on Intel Xeon.
Read articleHow ZeptoDB built a cost-based query planner in 7 phases — from HyperLogLog statistics to physical plan generation to EXPLAIN v2 with cost estimates.
Read articleHow ZeptoDB implements a recursive descent SQL parser, ClickHouse-compatible HTTP API, and ASOF JOIN — the three pillars of a queryable time-series database.
Read articleHow ZeptoDB prevents data corruption during network partitions using fencing tokens, epoch-based RPC validation, and Kubernetes lease integration.
Read articleA batch of critical fixes across ZeptoDB's distributed layer — thread pools, connection limits, 2PC snapshots, deadlock elimination, and state machine migrations — closing the gap between 'works in tests' and 'survives in production'.
Read articleReplacing single-winner index selection with a collect-and-intersect approach that combines multiple indexes per partition scan for multi-predicate queries.
Read articleHow ZeptoDB combines Kubernetes lease-based leader election with automatic re-replication to survive coordinator failures and data node losses without manual intervention.
Read articleHow 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 articleImplementing CREATE TABLE, DROP TABLE, ALTER TABLE, and TTL-based retention in ZeptoDB — from schema registry to automatic partition eviction.
Read articleHow ZeptoDB implements kdb+-style symbol interning with dictionary encoding — enabling WHERE symbol = 'AAPL' while maintaining integer-speed query performance.
Read articleHow ZeptoDB scales horizontally with CRTP transport abstraction, consistent hashing, and UDP health monitoring — all with zero virtual call overhead on the hot path.
Read articleHow ZeptoDB decomposes VWAP, HAVING, DISTINCT, and window functions for correct distributed execution using scatter-gather and partial aggregation.
Read articleHow ZeptoDB embeds DuckDB as an in-process analytical engine for Parquet queries — with Arrow columnar bridging and a duckdb() table function.
Read articleHow ZeptoDB automatically re-replicates data when a node fails — PartitionMigrator integration, async recovery threads, and graceful fallback for unregistered nodes.
Read articleImplementing kdb+-style financial analysis in SQL — xbar time bucketing, exponential moving averages, delta/ratio calculations, and Window JOIN for real-time analytics.
Read articleHow a custom open-addressing hash map with CRC32 hardware hashing eliminated pointer chasing and cache misses in ZeptoDB's JOIN operators.
Read articleHow ZeptoDB implements per-key symbol and table ACLs, tenant binding, key expiry, and in-place editing for fine-grained API key management.
Read articleHow ZeptoDB exploits sorted timestamps and partition-per-symbol structure to make GROUP BY and time range queries orders of magnitude faster.
Read articleHow ZeptoDB manages the hot/warm/cold data lifecycle with tiered storage — in-memory RDB for real-time queries, LZ4-compressed HDB on NVMe, and Parquet on S3 for long-term archival.
Read articleHow ZeptoDB's HealthMonitor handles DEAD node recovery via the REJOINING state, consecutive miss counting, TCP heartbeat fallback, and fatal bind failure detection.
Read articleHow ZeptoDB's Helm chart enables zero-downtime rolling upgrades for an in-memory database — with PodDisruptionBudgets, config checksum annotations, canary deployments, and instant rollback.
Read articleHow ZeptoDB's HTTP server provides production-grade observability — structured JSON access logs, slow query detection, X-Request-Id tracing, and Prometheus metrics.
Read articleHow ZeptoDB secures inter-node RPC communication with FNV-1a HMAC authentication, nonce-based replay protection, and a path toward mutual TLS.
Read articleHow ZeptoDB's JIT engine generates four-lane i64 SIMD vector IR in LLVM, including reliable vectorization and cttz mask extraction.
Read articleHow we built and executed a 38-test Kubernetes compatibility and high-availability test suite against a live EKS cluster — covering Helm validation, pod lifecycle, networking, rolling updates, and failure recovery.
Read articleHow ZeptoDB moves partitions between nodes without data loss using dual-write ingestion, a state machine for migration lifecycle, and crash-recoverable checkpoints.
Read articleHow ZeptoDB's QueryScheduler abstraction enables partition-level parallelism today and distributed execution tomorrow — without changing the executor.
Read articleHow ZeptoDB writes Apache Parquet files and uploads them to S3 for long-term historical storage — with partition-based file layout, compression codec selection, and direct query integration with DuckDB and Polars.
Read articleHow ZeptoDB integrates with the Python scientific stack — zero-copy Arrow paths, vectorized batch ingestion, and seamless DataFrame conversion for pandas, Polars, and DuckDB.
Read articleThree enhancements to ZeptoDB's web query editor — interactive chart visualization with Recharts, multi-tab editing with localStorage persistence, and sequential multi-statement execution.
Read articleWhy ZeptoDB chose epoch broadcast over Raft for partition router synchronization, and how the pluggable consensus interface keeps the door open for stronger guarantees.
Read articleHow 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 articleHow ZeptoDB's s# sorted attribute enables binary search on arbitrary columns, turning full-partition scans into sub-millisecond range lookups — plus connection lifecycle hooks for session management.
Read articleImplementing mutation operations on columnar time-series data — INSERT with auto-timestamp, in-place UPDATE, and compaction-based DELETE.
Read articleExtending ZeptoDB's SQL with expression evaluation, CASE WHEN branching, temporal functions, LIKE pattern matching, and UNION/INTERSECT/EXCEPT set operations.
Read articleAutomatic hot/warm/cold/drop storage tiering and incremental materialized views for pre-computed aggregations in ZeptoDB.
Read articleHow ZeptoDB integrates HashiCorp Vault as a write-through backend for API keys, enabling multi-node key sharing and centralized secrets management.
Read articleHow ZeptoDB's WalReplicator evolved from best-effort async to production-grade replication with quorum acknowledgment, exponential retry, and configurable backpressure.
Read articleExploiting timestamp monotonicity to eliminate hash lookups in GROUP BY XBAR, adding EXPLAIN for query plan inspection, and standardizing NULL handling across all executor paths.
Read articleA deep dive into ZeptoDB's ASOF JOIN — from SQL parsing to SIMD-accelerated merge.
Read articleInside ZeptoDB's MPMC ring buffer — design decisions, SIMD batch copy, and Highway vectorization.
Read articleHow ZeptoDB achieves sub-microsecond Python query results using memory-mapped column views.
Read article| Version | Date | Highlights |
|---|---|---|
| 0.1.7 | 2026-07-10 | Current public Docker image. Use the versioned tag for reproducible quick starts and deployment checks. |
