DuckDB
The in-process SQL OLAP database — SQLite-style embedding, columnar speed, and 1.5.2 ships DuckLake 1.0 GA.
Triplit is an open-source full-stack database that runs on both server and client and syncs in real-time over WebSockets. It collapses Postgres, an ORM, a websocket layer and a CRDT merge resolver into one TypeScript SDK.
Triplit is an open-source, full-stack syncing database that runs on both server and client — built for developers who want real-time, offline-first apps without writing the sync engine themselves. We rate it 82/100: the most cohesive end-to-end local-first stack you can adopt today, with the caveat that it's still pre-1.0 and best for small-to-medium app data, not analytics or massive multi-tenant workloads.
Triplit is a TypeScript database that lives on both the server and the browser (or React Native), syncs over WebSockets, and resolves conflicts at the property level using CRDTs. It was created by Will Ernst and Matthew Linkous at Aspen Cloud, a Y Combinator W21 company, with the public GitHub repository aspen-cloud/triplit first published on . The first "Show HN" landed on , and as of the project sits at 3,086 GitHub stars, 100 forks and ships under the AGPL-3.0 license.
The pitch is unusually concrete. Most apps want a few of the same things at once — optimistic UI, offline support, multiplayer, server-enforced authorization — and end up gluing together a Postgres, an ORM, a websocket layer, a state library, and a custom merge resolver. Triplit collapses that stack into a single SDK: define a schema in TypeScript, write live queries that update across tabs and devices, and let the server enforce read/write rules. It's aimed squarely at the local-first crowd that's been talking about Linear, Figma and Pitch as exemplars for years.
schema.ts; queries return fully typed results with autocomplete for relations, filters and includes. No code generation step.useQuery returns reactive results that re-render on local optimistic writes and on remote sync events.npx create-triplit-app scaffolds client + server in one step, and a single docker compose up runs the production server image.
The reception on Hacker News and r/reactjs has been notably warm by local-first standards. Recurring praise: the API is small, the docs read like they were written by people who've actually shipped offline apps, and "it just works" out of the React Native box (a low bar that most competitors still trip over). One top-voted commenter wrote that they'd "tried a dozen local-first tools" and Triplit was the first that had thought through schema migrations, auth rules and React Native at the same time.
The honest criticisms are also consistent. Several engineers note that Triplit isn't a Postgres replacement — there's no SQL, no transactions across collections, and the query language is intentionally limited to what can sync efficiently. A common request is better tooling for migrating an existing relational schema in. Others point out that the sync engine, while elegant, is still pre-1.0 and the API has churned a few times during 2024–2025. Compared to Convex, Triplit asks more of you architecturally; compared to ElectricSQL, it gives you a database rather than a sync layer over your existing one.
Triplit Cloud uses a freemium model with a generous free tier and a flat $15/month Pro plan. Self-hosting is fully free under AGPL.
| Plan | Price | Key Limits |
|---|---|---|
| Self Host | $0 | Run on your own infra. Full feature parity. AGPL-3.0. |
| Free (Cloud) | $0/mo | Shared CPU, 512 MB RAM, 1 GB storage included (then $1/GB/mo). Community support. |
| Pro | $15/mo | Dedicated CPU, 2 GB RAM, 5 GB storage included (then $1/GB/mo). Priority email support. |
| Team | $10/user/mo | Multi-user dashboard access, shared queries, schema collaboration. Add-on to any cloud plan. |
| Enterprise | Custom | Triplit-hosted or BYOC, support SLA, data recovery, security review. |
Best for: small-to-mid app teams building collaborative SaaS, internal tools, mobile apps or any product where users expect Linear-style instant interactions and seamless offline mode. Especially compelling for solo founders and 2–5 person teams who don't want to staff a backend specialist just to build a real-time CRUD app.
Not ideal for: teams that need a relational data warehouse, heavy aggregations, or strict SQL compatibility; products with very large per-user datasets (the model assumes the client can hold the working set); or organizations that can't adopt AGPL on the server side without a commercial agreement.
Pros:
npx create-triplit-app gets you to a synced demo in under five minutes per multiple HN reports.Cons:
Convex is the most direct competitor — managed reactive database with TypeScript functions and live queries, but more server-centric and not local-first. PocketBase is simpler and self-hostable, but lacks the local-first sync model. ElectricSQL syncs Postgres into local SQLite and is closer to a sync layer than a database, while RxDB and PowerSync sit at different points on the local-first spectrum.
If you're shipping a collaborative or offline-capable app and you've been dreading wiring up Postgres + websockets + Zustand + a custom merge resolver, Triplit is the most pragmatic shortcut on the market in 2026. The TypeScript ergonomics, free Cloud tier and full self-host story make it low-risk to try, and the AGPL license is fine for most product companies. Subtract a few points for pre-1.0 churn and the deliberately narrow query model — hence 82, not 90 — but for the use case it targets, nothing else feels this complete.
The in-process SQL OLAP database — SQLite-style embedding, columnar speed, and 1.5.2 ships DuckLake 1.0 GA.
DatabasesA Redis-compatible in-memory data store engineered for 25× throughput on a single multi-core box.
DatabasesOpen-source vector database written in Rust for production-scale similarity search and RAG.
DatabasesModern, native database GUI for Postgres, MySQL, SQLite, Redis and 20+ engines — fast, lightweight, and beautifully designed.
SAP to Acquire Prior Labs, Maker of TabPFN, in €1B+ Push to Build a Frontier Tabular AI Lab in Europe (May 4, 2026)
SAP on May 4, 2026 announced it will acquire Prior Labs, the German maker of the open-source TabPFN tabular foundation model, and invest more than €1 billion over four years to build a Europe-based frontier AI lab focused on structured business data.
May 6, 2026
Reserv Raises $125M Series C Led by KKR to Scale AI-Native Insurance Claims TPA to 30M Claims/Year (May 4, 2026)
Reserv, the AI-native third-party administrator for P&C insurance, has closed a $125M Series C led by KKR. With $100M ARR and 200+ customers, the company plans to scale claims processing 60x — from 500,000 to 30 million per year — over the next four years.
May 6, 2026
Moritz, AI-Native Law Firm From Ex-OpenAI Counsel, Raises $9M From YC and 20VC in Four Days (May 5, 2026)
Moritz, the AI-native law firm founded by former OpenAI outside counsel Pamir Ehsas, closed a $9M pre-seed in four days led by Y Combinator and 20VC. The W2026 firm has already helped close $2B+ in deals with same-day turnaround.
May 6, 2026
Is this product worth it?
Built With
Compare with other tools
Open Comparison Tool →