📌 Marque-pages Pinboard

Dumping a SQLite database to a text file can make it much smaller, which means you can download it faster.

Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite - vlcn-io/cr-sqlite

LiteSync makes easy to replicate and synchronize SQLite databases. All nodes can write to the database, even when off-line

This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.

Visual tool to explore SQLite databases page-by-page, the way they're stored on disk and the way SQLite sees them. - QuadrupleA/sqlite-page-explorer

The ultimate set of SQLite extensions. Contribute to nalgeon/sqlean development by creating an account on GitHub.

An interesting twist in my recent usage of SQLite was the fact that I noticed my research scripts and the database intertwine more. SQLite is unique in that it really lives in-process, unlike standalone database servers. There is a feature to that which does not get used very frequently, but can be indispensable in some situations. By the way, the talk about the system that made me me to explore SQLite in anger can now be seen here. Normally it is your Ruby (or Python, or Go, or whatever) program which calls SQLite to make it “do stuff”. Most calls will be mapped to a native call like sqlite3_exec() which will do “SQLite things” and return you a result, converted into data structures accessible to your runtime. But there is another possible direction here - SQLite can actually call your code instead.

Some of the interesting and insane facts I learned about SQLite

libSQL is a fork of SQLite that is both Open Source, and Open Contributions. - tursodatabase/libsql

Open Source backend in 1 file with realtime database, authentication, file storage and admin dashboard

Optimize your Django SQLite configuration for production.

SQLite database explorer. Contribute to frectonz/sqlite-studio development by creating an account on GitHub.

Harlequin is a drop-in replacement for the DuckDB CLI, SQLite CLI, psql, etc. that brings SQL IDE features to your terminal.

Web-based SQLite database browser written in Python - coleifer/sqlite-web: Web-based SQLite database browser written in Python

A SQLite extension for efficient vector search, based on Faiss! - asg017/sqlite-vss: A SQLite extension for efficient vector search, based on Faiss!

Replicate postgres to SQLite on the edge. Contribute to zknill/sqledge development by creating an account on GitHub.

DocuLite lets you use SQLite like Firebase Firestore. It's written in Typescript and an adapter on top of sqlite3 and sqlite. It support listeners on documents, collections, and basic queries. Feedback & Bugs to thedoculite@gmail.com. This is early work, . Latest version: 1.0.3, last published: 2 hours ago. Start using doculite in your project by running `npm i doculite`. There are no other projects in the npm registry using doculite.

None

SQLite: Past, Present, and Future

SQL OnLine - SQLite, MySQL / MariaDB, PostgreSQL, MsSQL, Oracle. User-friendly interface for Data Science. No DownLoad, No Install.

SQLite is the most popular database in the world. Native support for SQLite in Python makes SQLite a popular database to start a project with, with most projects eventually needing to migrate to a…

Let's take a peek at how the rollback journal works.

A SQLite extension for reading large files line-by-line (NDJSON, logs, txt, etc.) - asg017/sqlite-lines: A SQLite extension for reading large files line-by-line (NDJSON, logs, txt, etc.)

Let's open a hex editor and see what this thing is made of

SQLite & SQL Server Compact Toolbox extension for Visual Studio, SSMS (and stand alone) - ErikEJ/SqlCeToolbox: SQLite & SQL Server Compact Toolbox extension for Visual Studio, SSMS (and stand alone)

Database conversion and synchronization software for MySQL, SQL Server, Oracle, SQLite, Access, PostgreSQL, and more.