whichdb

Triplit

maintenance

by Aspen Cloud, Inc. · since 2023 · also known as Triplit DB

Full-stack syncing database for TypeScript apps; development has stalled since 2025.

documentrelationaldatabase engineopen source (copyleft)emerging
Website Docs Source★ 3.1K Compare Find similar

maintenance. No releases since July 2025; co-founder joined Supabase (Oct 2025) and the project website was unreachable during verification. Code stays AGPL on GitHub.

Overview

Triplit is a TypeScript database that runs both in the client (IndexedDB or memory) and on a server (SQLite, Durable Objects and others), syncing over websockets with optimistic local writes, relational-style queries with includes, schemas and role-based permissions. It aimed to give React, Vue, Svelte and Solid apps realtime, offline-capable data without writing a backend. Its last npm release was in July 2025, and co-founder Matt Linkous joined Supabase in October 2025 to work on sync integrations. The AGPL code remains on GitHub with little activity, so treat it as stalled.

Local-first syncMobile & offline

Strengths & trade-offs

Strengths

  • +Same query API on client and server with optimistic local writes
  • +Relational includes and schemas with role-based permissions
  • +Pluggable storage from IndexedDB to SQLite and Durable Objects

Trade-offs

  • −Development has stalled; no releases since mid-2025
  • −AGPL license is a hurdle for some commercial deployments
  • −Small community and uncertain hosted offering

Great for

  • +Existing Triplit apps
  • +Learning or prototyping local-first sync patterns

Think twice for

  • −New production projects needing an active vendor
  • −Large datasets or high write throughput

Capabilities

Native or official first-party support · 6 of 25 tracked

✓Transactions
✓Joins
✓JSON
✓Durable persistence
✓Role-based access
✓Offline sync
–Secondary indexes
–Full-text search
–Vector search
–Geospatial
–Change data capture
–Triggers
–Stored procedures
–Materialized views
–TTL / expiry
–Pub/Sub
–Columnar storage
–In-memory
–Compression
–Encryption at rest
–Time travel
–Branching
–Online schema changes
–Streaming ingest
–Runs in WebAssembly

Scale & consistency

Comfortable data size
Small · ≤ 100 GB
Horizontal scaling
None
Multi-region
No
Transactions
Limited ACID
Consistency
Eventual
Schema
Flexible
Architecture
Client server, Embedded
Query languages
Triplit query builder (TypeScript)

Deployment

Self-hosted Vendor-managed cloud Serverless Embedded Edge Kubernetes operator

Ecosystem

apis & protocolsWebSocket sync protocol, HTTP API
client languagesTypeScript

Alternatives to Triplit

Compare all→
InstantDBGraph20.7

Realtime client-side database with relational queries, auth and permissions; cloud sunsets in 2027.

triplit vs instantdb →
JazzDocument14.2

Local-first database with built-in sync, permissions and edit history, being rebuilt as a relational Jazz 2.

triplit vs jazz →
Zero (Rocicorp)Relational20.8

Query-driven sync engine: clients run ZQL locally against a Postgres-backed cache for instant UIs.

triplit vs rocicorp-zero →
ElectricSQLRelational30.4

Read-path sync engine that streams partial replicas of Postgres to clients over plain HTTP.

triplit vs electricsql →
PowerSyncRelational23.3

Sync engine that keeps on-device SQLite in sync with Postgres, MongoDB, MySQL or SQL Server.

triplit vs powersync →
RxDBDocument20.2

Reactive local-first NoSQL database for JavaScript with pluggable storage and replication.

triplit vs rxdb →

Triplit FAQ

What is Triplit?

Triplit is a document database by Aspen Cloud, Inc., first released in 2023. Triplit is a TypeScript database that runs both in the client (IndexedDB or memory) and on a server (SQLite, Durable Objects and others), syncing over websockets with optimistic local writes, relational-style queries with includes, schemas and role-based permissions. It aimed to give React, Vue, Svelte and Solid apps realtime, offline-capable data without writing a backend. Its last npm release was in July 2025, and co-founder Matt Linkous joined Supabase in October 2025 to work on sync integrations. The AGPL code remains on GitHub with little activity, so treat it as stalled.

Is Triplit open source?

Yes. Triplit is open source. License: GNU AGPL v3.0.

Does Triplit support ACID transactions?

Partly. Triplit offers limited ACID guarantees (for example, single-record or single-partition transactions), with eventual consistency.

Does Triplit scale horizontally?

Triplit does not scale horizontally; it runs on a single node, so you scale it up rather than out. It is comfortable at small scale (≤ 100 GB).

How can I run Triplit?

You can self-host it and embed it in your application.

What is Triplit best for?

Triplit is a strong fit for existing Triplit apps and learning or prototyping local-first sync patterns. Think twice for new production projects needing an active vendor.

What are the best alternatives to Triplit?

Common alternatives to Triplit include InstantDB, Jazz, Zero (Rocicorp), ElectricSQL and PowerSync. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.

Is Triplit still maintained?

Triplit is in maintenance mode. No releases since July 2025; co-founder joined Supabase (Oct 2025) and the project website was unreachable during verification. Code stays AGPL on GitHub.

How popular is Triplit?

Triplit ranks #173 of 844 databases on the WhichDB Score (19.2/100), and #20 among document databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.