Archive

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 six operating systems. The basic idea is if you want to build a web app that runs anywhere, then you download the redbean.com file, put your .html and .lua files inside it using the zip command, and then you've got a hermetic app you can deploy and share.

redbean embeds Lua, SQLite, and MbedTLS into a fork() driven application server that benchmarks at 1.1 million qps on a personal computer. It's got a live bestline REPL with code completion and a UNIX module too, that lets you directly use the Cosmopolitan Libc system call interface. redbean furthermore provides sandboxing and system call tracing for security. This makes redbean a great fit for when you want to build an app that's vertically integrated into a single tiny file that runs on nearly all PCs and servers.

--

Deploying a redbean app to Fly from Simon Willison’s TILs

Redbean Tiddlywiki Saver: rpdillon.net; Nov 2022.

shmup/awesome-cosmopolitan: List of Cosmopolitan Libc related resources and projects

Fullmoon is a Fast and minimalistic Redbean-based Lua web framework in one file by Paul Kulchenko, the creator of ZeroBraneStudio, a Lua IDE.

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 scratch with DuckDB | Dagster Blog; Oct 2022.
• DuckDB as the New jq; Mar 2024.
• DuckDB isn't just fast
• Why Semantic Layers Matter — and How to Build One with DuckDB - MotherDuck Blog; Aug 2025.

Products

• Why We Built Rill with DuckDB; Apr 19, 2023
• MotherDuck
  • MotherDuck: Duck and Roll: MotherDuck is Open for All With $100M in the Nest

Videos

• DuckDB Tutorial For Beginners - YouTube

Tutorials

• Ducklicious DuckDB Cookbook
• mehd-io/pypi-duck-flow: end-to-end data engineering project to get insights from PyPi using python, duckdb, MotherDuck & Evidence

Tools

• DuckDB-Wasm Playground - Sekuel; lambda example

• Show HN: PretzelAI - Open-source, browser-local data exploration using DuckDB-WASM and PRQL | Hacker News

  • PretzelAI Playground
  • Can plugin your OpenAI code to use AI.
  • can generate charts against data
  • all in the browser
  • can load data from a URL.

• duckdb proxy

Discussion

• who uses duckdb for real: reddit -- examples of real world use cases. Excellent use cases.

Integration

• In-Memory Analytics for Kafka using DuckDB – Robert Yokota using kwak (Java).

• 🚜 Query.Farm  "is a product studio focused on extending DuckDB. We write DuckDB extensions, build developer tools, and help teams embed DuckDB into modern data systems."

Greybeam as an alternative for expensive Snowflake workloads using DuckDB.

• Greybeam provides compute infrastructure to automatically route each query to its optimal engine.
• Greybeam caches your Snowflake data as Apache Iceberg tables in a bucket you own. Provision it with Terraform, CloudFormation, or any IaC tool you already use.
• If your tool connects to Snowflake, it already works with Greybeam. Just replace your connection string and your analytics tools will work exactly as they do today.
• Greybeam manages the query engines, translates your SQL, and automatically routes each query to the most efficient engine. You don't change a single query.

--

See also: Parquet

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 Readonly mode, so destructive operations are possible).

The author -- Simon Willison has substack newsletter for the project.

How he uses datasette -- "What is the killer app for datasette"; Oct 2022.

datasette.io, an official project website for Datasette -- a blog post detailing how datasette is used to publish a website, in this case the website of the project itself. which uses the The Baked Data architectural pattern.

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 usage

sqlite> .import myfile.csv mytable

SQLite as a document database using Generated Columns and The JSON1 Extension

Tutorials

SQLite Date & Time - How To Handle Date and Time in SQLite (The site sqlitetutorial.net seems to have handy reference for common tasks with sqlite.)

SQLite as a Collaborative & Multiplayer Application File Format - YouTube

Optimizing SQLite for servers

60K RPS out of sqlite on a $5 VPS

Django

• Optimal SQLite settings for Django – Giovanni Collazo; June 2024.

Tools around SQLite

sqlpkg

The list of packages are here - https://sqlpkg.org.

#TODO SQLPkg is written in go. install it manually.

Sqlite-utils

can do things like:

• Running queries and returning JSON, CSV, markdown table
• Inserting JSON data: `echo | sqlite-utils insert dogs.db dogs -
• Inserting CSV data: sqlite-utils insert dogs.db dogs docs.csv --csv
• Insert-replacing data.

sqlite-http

Introducing sqlite-http: A SQLite extension for making HTTP requests / Alex Garcia | Observable

Sqlean

nalgeon/sqlean: The ultimate set of SQLite extensions

• crypto: hash functions
• define: user-defined functions and dynamic sql
• fileio: read and write files
• fuzzy: fuzzy string matching and phonetics
• ipaddr: IP address manipulation
• json1: JSON functions
• math: math functions
• regexp: regular expressions
• stats: math statistics
• text: string functions
• unicode: Unicode support
• uuid: Universally Unique IDentifiers
• vsv: CSV files as virtual tables

Pocketbase

Pocketbase is an open source backend that can be used to build API applications.

• single binary download
• written in Go
• embedded database (SQLite)
• built in user and files managment
• built in admin UI
• simple REST UI

Sqlsync

orbitinghail/sqlsync SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.

Example use cases

• A web app with a structured file oriented data model like Figma. Each file could be a SQLSync database, enabling real-time local first collaboration and presence
• Running SQLSync on the edge with high tolerance for unreliable network conditions
• Enabling optimistic mutations on SQLite read replicas

Soul

soul | 🕉 A SQLite REST and realtime server, written in node.js; Run soul -d sqlite.db -p 8000 and it’ll start a REST API on http://localhost:8000 and a Websocket server on ws://localhost:8000

---

See also: duckdb, til/sqlite-writable_schema, code/sqlite-csv-loading-using-virtual-table-extension