sqlite
🗄 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:
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:
Smart Edge Databases with Cloud Sync and Intelligence.
SQLiteSync is a local-first SQLite extension using CRDTs for seamless, conflict-free data sync and real-time collaboration across devices.
Related contents:
A fast, lightweight replacement for SwiftData, powered by SQL and supporting CloudKit synchronization.
The best SQLite database editor for macOS
Base is a small, powerful, comfortable SQLite editor for everyone
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:
🛡️A resilient, high-performance asynchronous connection pool layer for SQLite, designed for efficient and scalable database operations.
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
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.
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).
LumoSQL is a modification (not a fork) of the SQLite embedded data storage library, which is among the most-deployed software. LumoSQL adds security, privacy, performance and measurement features to SQLite.
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.
SQLite Multitenancy With Rails.
Related contents:
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.
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.
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!
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:
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.
The lightweight, user-friendly, distributed relational database built on SQLite. Fault tolerance and high availability with zero hassle.
Related contents:
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.
SQL language server written in Go.
sqls aims to provide advanced intelligence for you to edit sql in your own editor.
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.
Limbo is a work-in-progress, in-process OLTP database management system, compatible with SQLite.
Related contents:
Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.
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.
An embedded database. the champagne of beta embedded databases.
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.
A lightweight next-gen data explorer - Postgres, MySQL, SQLite, MongoDB, Redis, MariaDB & Elastic Search with Chat interface.
Modern, Native Tool for Database Management. Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more
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.
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.
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.
An SQLite based, PHP-only fulltext search engine.
A full text search engine with tokenization, stemming, typo tolerance, filters and geo support based on only PHP and SQLite.
The database client every command line junkie deserves.
Interactive client for PostgreSQL, MySQL, SQLite3, Oracle and SQL Server.
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.
A vector search SQLite extension that runs anywhere!
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.
Redis re-implemented with SQLite.
Redka aims to reimplement the good parts of Redis with SQLite, while remaining compatible with Redis API.
Related contents:
A set of extensions to Doctrine 2 that add support for functions available in MySQL, Oracle, PostgreSQL and SQLite.
MariaDB, MySQL, MSSQL, PostgreSQL and SQLite made easy.
HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide.
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
Related contents:
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.
corrosion is a distributed system for propagating SQLite state across a cluster of nodes.
SQLite Developer Experience in an Edge Database.
Turso is an edge-hosted, distributed database based on libSQL, an open-source and open-contribution fork of SQLite. It was designed to minimize query latency for applications where queries come from anywhere in the world. In particular, it works well with edge functions provided by cloud platforms such as CloudFlare, Netlify, and Vercel, by putting your data geographically close to the code that accesses it.
Related contents:
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.
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.
Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.
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:
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.
Replicating SQLite using the Raft consensus protocol. rqlite is a distributed system that provides a replicated SQLite database. rqlite is written in Go and uses Raft to achieve consensus across all the instances of the SQLite databases. rqlite ensures that every change made to the database is made to a quorum of SQLite files, or none at all.