{"repo":"chaisql/chai","free":true,"listed":false,"github":"https://github.com/chaisql/chai","clone":"git clone https://github.com/chaisql/chai.git","description":"Modern embedded SQL database","language":"Go","stars":1704,"topics":["database","sql","embedded-database","go","golang"],"license":"MIT","category":"databases-storage","readme_excerpt":"ChaiSQL ChaiSQL is a modern embedded SQL database, written in pure Go, with a PostgreSQL-inspired API. It’s designed for developers who want the familiarity of Postgres with the simplicity of an embedded database. ✨ Highlights - Postgres-like SQL – the syntax you already know, embedded in your Go app. - Pure Go – no CGO or external dependencies. - Flexible Storage – keep data on disk or run fully in-memory. - Built on Pebble – powered by CockroachDB’s Pebble engine. 🔎 Current Capabilities ChaiSQL already supports a useful core of SQL features, including: - Creating and dropping tables & indexes (with composite indexes) - Inserting, updating, deleting rows - Basic SELECT queries with filtering, ordering, grouping - DISTINCT, UNION / UNION ALL 👉 Joins and many advanced features are not implemented yet. The goal is steady growth toward broader PostgreSQL compatibility, but today ChaiSQL is best suited for simpler schemas and embedded use cases . 🗺 Roadmap ChaiSQL is still in active development and not production-ready. Planned milestones include: - [ ] Finalize stable on-disk storage format (90% complete) - [ ] Broader SQL-92 coverage - [ ] Drivers for other languages (JS/TS, Python, …) - [ ] RocksDB backend support - [ ] Compatibility with PostgreSQL drivers/ORMs Installation Install the ChaiSQL driver and CLI: Quickstart Here’s a simple Go example that creates a table, inserts rows, and queries them: In-memory Database For ephemeral databases, just use :memory: : Chai shell","default_branch":null,"files":null,"tree":[],"storefront":"/r/chaisql","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/chaisql/chai/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}