#sqlite
4 notes and posts, 17 links.
Notes and posts
Redbean
Redbean single-file distributable web server is built using cosmopolitan. Redbean's home page does a great job of explaining what the software does: rebean is an open source webserver in a zip executable that runs on…
Duckdb
davidgasquez/awesome-duckdb: 🦆 A curated list of awesome DuckDB resources Papers Notes on the SQLite DuckDB paper Articles Why DuckDB is my first choice for data processing; Mar 2025. Build a poor man’s data lake from…
datasette
Datasette is a tool for exploring and publishing data. Uses sqlite for storing data and is written in python and exposes the db over a web interface. support adhoc querying (made posible by mounting the database file in…
Sqlite
I wrote an article about SQLite for DeveloperIQ magazine published in Jan 2005 -- Move Over MySQL, SQLite is here!! --- Query Parquet files in SQLite | Colin Dellow Importing csv into sqlite: see this page for extended…
Links Open in the Archive
marcboeker/gmail-to-sqlite: Index your Gmail account to a SQLite DB and play with the data.
via https://news.ycombinator.com/item?id=43943236
Hosting SQLite databases on GitHub Pages or any static file hoster | Hacker News
superfly/ltx: Go library for the LTX file format
The LTX file format provides a way to store SQLite transactional data in a way that can be encrypted and compacted and is optimized for performance.
SQLite: Past, Present, and Future
JSON improvements in SQLite 3.38.0
dsq: Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
Bashing JSON into Shape with SQLite - Xe
nalgeon/sqlean: The ultimate set of SQLite extensions
bibliothecula
document organizer with tags and full-text-search, in a simple and clean sqlite3 schema
Hosting SQLite databases on Github Pages - (or any static file hoster) - phiresky's blog
"Hosting SQLite databases on Github Pages" is absolutely brilliant: it adds a virtual filesystem to SQLite-compiled-to-WebAssembly in order to fetch pages from…
Standard Deviations » Simple Data Analysis with SQLite
Postgres for the win!
Good points on the strengths of PG and also comapritive analysis of SQLite in the comments AFAICT.
ZODB vs. pysqlite with SQLObject
two good options for an embedded, transactional database that can be conveniently used in a non-free Python application: the ZODB and sqlite.
Comparison of different SQL implementations
APSW - Another Python SQLite Wrapper
APSW provides an SQLite 3 wrapper that provides the thinnest layer over SQLite 3 possible. Everything you can do from the C API to SQLite 3, you can do from…
Mozilla related blog
Move Over MySQL, SQLite is here!!
SQLite allows you to create full-fledged databases on the fly without using traditional databases