{"repo":"DallasHoff/sqlocal","free":true,"listed":false,"github":"https://github.com/DallasHoff/sqlocal","clone":"git clone https://github.com/DallasHoff/sqlocal.git","description":"SQLocal makes it easy to run SQLite3 in the browser, backed by the origin private file system.","language":"TypeScript","stars":742,"topics":["sqlite","typescript-library","sqlite-wasm","local-first","opfs"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQLocal SQLocal makes it easy to run SQLite3 in the browser, backed by the origin private file system. It wraps the WebAssembly build of SQLite3 and gives you a simple interface to interact with databases running on device. Documentation - GitHub - NPM - Fund Features - 🔎 Locally executes any query that SQLite3 supports - 🧵 Runs the SQLite engine in a web worker so queries do not block the main thread - 📂 Persists data to the origin private file system, which is optimized for fast file I/O - 🚀 Simple API; just name your database and start running SQL queries - ⚡️ Subscribe to query results and receive changes, even across tabs - 🔒 Each user can have their own private database instance - 🛠️ Works with Kysely and Drizzle ORM for making type-safe queries - 🤝 Get set up quickly with hooks for UI frameworks and a Vite plugin Examples Log: Or, you can use SQLocal as a driver for Kysely or Drizzle ORM to make fully-typed queries. Kysely See the Kysely documentation for getting started. Drizzle See the Drizzle ORM documentation for declaring your schema and making queries. Install Install the SQLocal package in your application using your package manager. Cross-Origin Isolation In order to persist data to the origin private file system, this package relies on APIs that require cross-origin isolation, so the page you use this package on must be served with the following HTTP headers. Otherwise, the browser will block access to the origin private file system. How this is configu","default_branch":null,"files":null,"tree":[],"storefront":"/r/DallasHoff","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/DallasHoff/sqlocal/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."}