LinkedQL A modern take on SQL and SQL databases Simplify and unify your entire database layer in a single interface 🛸 LinkedQL is a database client ( client.query() ) for PostgreSQL and MySQL/MariaDB, but more broadly, an idea: SQL reimagined for modern apps ↗. LinkedQL solves reactivity, relationships, JSON, schemas, embedding, federation & sync, and more in under 80 KiB min | zip . Note You’re viewing @linked-db/linked-ql — the newest iteration. For the prev 0.3.x branch, see linked-db/linked-ql@0.3.*. Important 🚀 LinkedQL is in active development and evolving daily. Current status = alpha. You’re welcome to experiment, but it’s not yet suited for production apps. Installation LinkedQL is distributed as an npm package. Install it with: npm install @linked-db/linked-ql The package provides clients for all supported SQL dialects — including FlashQL, the in-memory SQL engine for local or offline use. Initialization Import and initialize the client for your use case. You can run either fully in-memory or with a database. Here are two quick examples: Run Locally with FlashQL FlashQL lets you run SQL queries entirely in memory — with zero setup. import { FlashQL } from '@linked-db/linked-ql/flashql' ; const client = new FlashQL ( ) ; await client . query ( `CREATE TABLE users (id INT PRIMARY KEY, name TEXT)` ) ; const result = await client . query ( ` INSERT INTO users (id, name) VALUES (1, 'Ada'), (2, 'Linus'); SELECT * FROM users; ` ) ; console . log ( result . rows ) ; // [{ id: 1, name: 'Ada' }, { id: 2, name: 'Linus' }] FlashQL is ideal for: Local-first and offline-first apps Running SQL over runtime data Testing and prototyping Connect to a Database Connect to your database from the list of supported dialects below. Here’s an example using PostgreSQL: import { PGClient } from '@linked-db/linked-ql/postgres' ; const client = new PGClient ( { host : 'localhost' , port : 5432 , user : 'postgres' , password : 'password' , database : 'myapp' , } ) ; await client . conn...
First seen: 2025-12-13 16:51
Last seen: 2025-12-13 18:52