{"repo":"benmerckx/rado","free":true,"listed":false,"github":"https://github.com/benmerckx/rado","clone":"git clone https://github.com/benmerckx/rado.git","description":"🍃 Fully typed, lightweight query builder","language":"TypeScript","stars":44,"topics":["sql","sqlite","typescript","orm","query-builder","bun","node","deno"],"license":"MIT","category":"databases-storage","readme_excerpt":"rado A fully typed, lightweight TypeScript query builder for SQLite, PostgreSQL and MySQL. If you've used Drizzle ORM, the code above looks familiar. That's intentional. Rado deliberately aligns its query building syntax with Drizzle, while making a few different choices under the hood: simpler types, immutable queries, a much smaller footprint and queries that can run on any of the supported databases. Read about the project's history in Taking the Drizzle challenge. Features - Fully typed : schema definitions drive query and result types, with plain, readable TypeScript types - Immutable queries : every method returns a new query, so you can branch and reuse query fragments without surprises - Universal queries : write a query once, run it on SQLite, PostgreSQL or MySQL, chosen at runtime - First-class JSON columns : select and filter on typed JSON fields with plain property access - include instead of an ORM : fetch related rows as nested arrays or objects inside the query builder, no relations setup required - Auto-migrations : diff your schema against the database and update it anywhere, including the browser - Zero dependencies, small bundle : rado + the PostgreSQL utilities bundle to roughly 8.5 kB gzipped - No code generation step : your schema is just TypeScript Installation Rado is also published on JSR as @rado/rado for Deno users. Quick start Documentation The full documentation lives in docs. A map of the territory: Section What's inside -------------------------","default_branch":null,"files":null,"tree":[],"storefront":"/r/benmerckx","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/benmerckx/rado/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."}