sqlite
An unfaithful port of Linq to Sql to Typescript.
A type-safe query builder for TypeScript. Queries are expressed as inline arrow functions, parsed into an expression tree, and compiled into SQL for PostgreSQL or SQLite. The API is similar to DotNet's LINQ-based frameworks.
Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server.
sqldef is a CLI tool for diffing two SQL schemas. You can use it to manage the migration of RDBMSs using regular SQL DDLs.
Supported databases: MySQL, MariaDB, TiDB, PostgreSQL, SQL Server, and SQLite3.
🗄 CLI tool for backup your databases, files to cloud storages in schedully.
GoBackup is a backup tool design for application servers, to backup your databases, files to cloud storages (FTP, SCP, S3, GCS, Aliyun OSS ...) in schedully.
Related contents:
Download and parse data from Garmin Connect or a Garmin watch, FitBit CSV, and MS Health CSV files into and analyze data in Sqlite serverless databases with Jupyter notebooks.
Python scripts for parsing health data into and manipulating data in a SQLite database. SQLite is a light weight database that doesn't require a server.
Related contents:
Index your Gmail account to a SQLite DB and play with the data.
This is a script to download emails from Gmail and store them in a SQLite database for further analysis. I find it extremely useful to have all my emails in a database to run queries on them. For example, I can find out how many emails I received per sender, which emails take the most space, and which emails from which sender I never read.
FerretDB allows you to use MongoDB drivers seamlessly with PostgreSQL as the database backend. Use all tools, drivers, UIs, and the same query language and stay open-source.
Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.
A PostgreSQL protocol adapter for SQLite databases. This project allows PostgreSQL clients to connect to and query SQLite databases using the PostgreSQL wire protocol.
Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript.
SQLite-JS is a powerful extension that brings JavaScript capabilities to SQLite. With this extension, you can create custom SQLite functions, aggregates, window functions, and collation sequences using JavaScript code, allowing for flexible and powerful data manipulation directly within your SQLite database.
Open Source backend for your next SaaS and Mobile app in 1 file.
Related contents:
DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
DB4S is for users and developers who want to create, search, and edit databases. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned.
Offline-first SQL sync with Typescript and Rust cores.
Syncular keeps an SQLite database on each client and synchronizes it through a server-owned commit log. Apps read from local SQLite and continue to work offline. A write updates local state immediately, enters an outbox, and is checked by the server when it syncs.
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day. More Information...
Related contents:
- SQLite File Format Viewer.
- SQLite Transactions and Virtual Tables @ Misframe.
- A faster way to copy SQLite databases between computers @, alexwlchan.
- Scaling SQLite to 4M QPS on a single server (EC2 vs Bare Metal) @ Expensify.
- PSA: SQLite WAL checksums fail silently and may lose data @ blag.
- Lessons learned from building a sync-engine and reactivity system with SQLite @ Antoine's blog.
- From 19k to 4.2M events/sec: story of a SQLite query optimisation @ mnt.io.
- SQLite Is ULTIMATE Choice For 99% of Projects @ DevOps Toolbox's YouTube.
- Subtleties of SQLite Indexes @ Evan Schwartz.
- SQLite concurrency and why you should care about it @ Jellyfin.
- 100000 TPS over a billion rows: the unreasonable effectiveness of SQLite @ anders murphy.
- The Silent Standard: Why the World’s Most Deployed Database Is Killing the Custom File Format @ WebProNews.
- SQLite JSON Superpower: Virtual Columns + Indexing @ DB Pro.
- I don't buy SQLite in the cloud @ Monroe Clinton.
- SQLite 3.52 Released With WAL Corruption Fix and CLI Improvements @ linuxiac.
- Gotchas with SQLite in Production @ Anže's Blog.
- Modern SQLite: Features You Didn’t Know It Had @ slicker.me.
- SQLite is All You Need for Durable Workflows @ Obelisk.
- SQLite improving performance with pre-sort @ anders murphy.
- Detecting Full Table Scans With SQLite @ Tenderlove Making.
- SQLite should have (Rust-style) editions @ Mort's Ramblings.
Open Source Airtable Alternative & Backend as a Service. 🚀 Private first self-hosted no code database & BaaS.
UNDB is a no-code platform that can also serve as a Backend as a Service (BaaS). It is based on SQLite and can be packaged into a binary file using Bun for backend service. Additionally, it can be deployed as a service via Docker, offering a UI for table management.
Feature-rich ORM for modern TypeScript & JavaScript.
Sequelize is a modern TypeScript and Node.js ORM for Oracle, Postgres, MySQL, MariaDB, SQLite and SQL Server, and more. Featuring solid transaction support, relations, eager and lazy loading, read replication and more.
An open-source SQL-Native memory engine for AI. Open-Source Memory Engine for LLMs, AI Agents & Multi-Agent Systems.
One line of code to give any LLM persistent, queryable memory using standard SQL databases.
Memori enables any LLM to remember conversations, learn from interactions, and maintain context across sessions with a single line: memori.enable(). Memory is stored in standard SQL databases (SQLite, PostgreSQL, MySQL) that you fully own and control.
The lightweight, user-friendly, distributed relational database built on SQLite. Fault tolerance and high availability with zero hassle.
Related contents:
AI Text2SQL Tool for Easy Database Management.
🔥🔥🔥 AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL, DB2, SQL Server, DB2, SQLite, H2, ClickHouse, and more.
The SQL Editor and Database Manager Of Your Dreams. A modern, easy to use, and good looking SQL client for MySQL, Postgres, SQLite, SQL Server, and more.
Visual tool to explore SQLite databases page-by-page, the way they're stored on disk and the way SQLite sees them. A small GUI application built in redbean that lets you explore your SQLite databases "page by page" the way SQLite sees them.
A fast, lightweight replacement for SwiftData, powered by SQL and supporting CloudKit synchronization.
Write it Down. Own it Forever.
A clean, quiet space to think. Your notes live in standard Markdown within a local SQLite database. No vendor lock-in, no distractions. Selfhosted notes app. Single golang binary, notes stored as markdown within SQLite, full-text search, very low resource usage
🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite.
SeaQuery is a query builder to help you construct dynamic SQL queries in Rust. You can construct expressions, queries and schema as abstract syntax trees using an ergonomic API. We support MySQL, Postgres and SQLite behind a common interface that aligns their behaviour where appropriate. MS SQL Server Support is available under SeaORM X.
Distributed SQLite.
LiteFS is a distributed file system that transparently replicates SQLite databases. You can run your application like it’s running against a local on-disk SQLite database but behind the scenes the database is replicated to all the nodes in your cluster. With LiteFS, you can run your database right next to your application on the edge. You can run LiteFS anywhere!
Modern, Native Tool for Database Management. Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more
Limbo is a work-in-progress, in-process OLTP database management system, compatible with SQLite.
Related contents:
Self-hosted street address database
A SQLite3 database file with over 150 million U.S. and Canada address records. Indexed for fast queries, even on fairly slow hardware.
yarr (yet another rss reader) is a web-based feed aggregator which can be used both as a desktop application and a personal self-hosted server.
It is written in Go with the frontend in Vue.js. The storage is backed by SQLite.
SQL & noSQL database manager.
Powerful and easy to use (no)SQL database client for MySQL, PostgreSQL, Oracle, SQL Server, SQLite, MongoDB, Redis, …
DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import.
SQL language server written in Go.
sqls aims to provide advanced intelligence for you to edit sql in your own editor.
The database client Mac deserves. Fast, native database client for Mac
Connect to MySQL, Postgres, SQLite, Mongo, Redis, and a dozen more. Built with SwiftUI. Ships under 50 MB. Launches in under a second.
Related contents:
Database schema diagrams visualizer. Open-source database diagrams editor.
Free and open-source database diagrams editor, visualize and design your DB with a single query.
ChartDB is a powerful, web-based database diagramming editor. Instantly visualize your database schema with a single "Smart Query." Customize diagrams, export SQL scripts, and access all features—no account required. Experience seamless database design here.
Nmap Dashboard Mini Project.
nmap-did-what is a Grafana docker container and a Python script to parse Nmap XML output to an SQLite database. The SQLite database is used as a datasource within Grafana to view the Nmap scan details in a dashboard.
The database client every command line junkie deserves.
Interactive client for PostgreSQL, MySQL, SQLite3, Oracle and SQL Server.
SELF — the Structured Executable & Linkable Format: a program that is a SQLite database instead of an ELF file, and the machinery to actually run it on Linux/NixOS.
Related contents:
Open-source database client for PostgreSQL, MySQL/MariaDB and SQLite with SQL notebooks, visual EXPLAIN, AI and MCP built in. Hackable with plugins.
Tabularis is an open-source desktop SQL workspace for PostgreSQL, MySQL/MariaDB, and SQLite, with a built-in MCP server so Claude, Cursor, and Windsurf can read your schema and run queries through the same app you already use.
A lightweight next-gen data explorer - Postgres, MySQL, SQLite, MongoDB, Redis, MariaDB & Elastic Search with Chat interface.
Talk to your databases. database client for developers.
A fast, beautiful client for PostgreSQL, SQLite, Redis & ClickHouse. Browse data, run SQL, visualize schemas — or just describe what you need and let AI write the query.
WebAssembly SQLite with support for browser storage extensions.
This is a WebAssembly build of SQLite with support for writing SQLite virtual filesystems completely in Javascript. This allows alternative browser storage options such as IndexedDB and Origin Private File System. Applications can opt to use either a synchronous or asynchronous (using Asyncify or JSPI) SQLite library build (an asynchronous build is required for asynchronous extensions).
Related contents:
An embedded database. the champagne of beta embedded databases.
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
Related contents:
Atuin replaces your existing shell history with a SQLite database, recording additional context for your commands. It also provides optional and fully encrypted synchronisation of your history between machines
Related contents:
Build Databases As Spreadsheets :No-Coding Required.
NocoDB allows building no-code database solutions with ease of spreadsheets. Bring your own database or choose ours! Millions of rows? Not a problem. Your Data. Your rules. You are in control.
🔥 🔥 🔥 Open Source Airtable Alternative. Turns any MySQL, PostgreSQL, SQL Server, SQLite & MariaDB into a smart spreadsheet.
SQLite on the edge.
HTTP SQLite scale-to-zero database on the edge built on Cloudflare Durable Objects. Open source, scale-to-zero, HTTP SQLite database built on top of Cloudflare Durable Objects.
libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
We aim to evolve it to suit many more use cases than SQLite was originally designed for, and plan to use third-party OSS code wherever it makes sense.
SQLite for modern applications.libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
libSQL is an open source, open contribution fork of SQLite, created and maintained by Turso. We aim to evolve it to suit many more use cases than SQLite was originally designed for, and plan to use third-party OSS code wherever it makes sense.
🛡️A resilient, high-performance asynchronous connection pool layer for SQLite, designed for efficient and scalable database operations.
Streaming SQLite Replication.
Stop building slow, complex, fragile software systems. Safely run your application on a single server.
Litestream is a standalone disaster recovery tool for SQLite. It runs as a background process and safely replicates changes incrementally to another file or S3. Litestream only communicates with SQLite through the SQLite API so it will not corrupt your database.
Related contents:
Redis re-implemented with SQLite.
Redka aims to reimplement the good parts of Redis with SQLite, while remaining compatible with Redis API.
Related contents:
SQLite Multitenancy With Rails.
Related contents:
Knex.js is a batteries-included SQL query builder for JavaScript.
Knex.js (pronounced /kəˈnɛks/) is a "batteries included" SQL query builder for PostgreSQL, CockroachDB, MSSQL, MySQL, MariaDB, SQLite3, Better-SQLite3, Oracle, and Amazon Redshift designed to be flexible, portable, and fun to use.
Local-first data layer for high-performance apps. LiveStore is a next-generation state management framework based on reactive SQLite and git-inspired syncing (via event-sourcing).
LiveStore is a fully-featured, client-centric data layer (replacing libraries like Redux, MobX, etc.) with a reactive embedded SQLite database powered by real-time sync (via event-sourcing).
A vector search SQLite extension that runs anywhere!
This tool helps you explore the SQLite file format internals according to the official specification. It's designed for developers and database enthusiasts who want to understand the internal structure of SQLite database files.
A command line interface for SQLite with auto-completion and syntax highlighting.