Triplit - Full-stack Local-first

Full-stack Local-first Database T Applications & Practices

Basic Information

Product Description

Triplit is a complete local-first database solution that includes both server and client components, providing data persistence, state management, and real-time synchronization for web applications. It handles relational queries on the client side, ensures data consistency through Schema definitions, and automatically resolves conflicts using CRDTs. After being acquired by Supabase in 2025, Triplit ceased to exist as an independent company and transitioned into an open-source project.

Core Features/Characteristics

  • End-to-end Type Safety: Full TypeScript type inference from Schema to queries
  • Relational Queries: Full relational query capabilities on the client side
  • Schema-defined Consistency: Ensures data consistency through Schema constraints
  • CRDT Conflict Resolution: Automatically handles concurrent modifications
  • Real-time Synchronization: Real-time data sync between server and client
  • Offline-first: Applications function normally offline
  • Optimistic Updates: Client operations are immediately reflected in the UI

Technical Architecture

  • Triplit Server: Full-stack database server
  • Triplit Client: Client-side database and sync library
  • Schema System: Declarative data model definition
  • Query Engine: Client-side relational query engine
  • Sync Protocol: CRDT-based bidirectional synchronization

Changes After Acquisition

  • Acquired by Supabase in 2025
  • No longer operates as an independent company
  • Transitioned into an open-source project
  • Potentially integrated into Supabase's product line

Business Model

  • Open-source project (AGPL v3)
  • Offered hosting services before acquisition
  • Business model unclear post-acquisition

Target Users

  • Teams heavily reliant on TypeScript
  • Developers requiring end-to-end type safety
  • Teams building real-time collaborative applications
  • Supabase ecosystem users

Competitive Advantages

  • Strongest TypeScript type safety
  • Full-stack solution (server + client integrated)
  • Schema-defined data consistency
  • Potential for greater ecosystem support post-Supabase acquisition

Competitive Landscape

  • PowerSync: Supports more backends, more mature
  • ElectricSQL: Postgres ecosystem
  • Evolu: End-to-end encryption, simpler
  • Jazz: More comprehensive framework
  • Replicache: More flexible sync solution

Relationship with OpenClaw

Triplit's full-stack local-first architecture can provide a structured data management layer for OpenClaw, especially suitable for scenarios requiring TypeScript type safety. However, its development direction post-Supabase acquisition needs to be observed.

Sources

External References

Learn more from these authoritative sources: