Build your own document database with SQLite. | Continue reading
Strict column type checking, like in PostgreSQL or MySQL. | Continue reading
Interactive introduction to grep with real-world use cases. | Continue reading
Interactive introduction to Git with real-world use cases. | Continue reading
Policies that discourage self-promotion are harmful. | Continue reading
Get a quick taste of your next $thing by studying interactive examples in the browser. | Continue reading
Presenting playground output in a visual manner. | Continue reading
JSONB has landed. | Continue reading
Embed and run interactive code snippets entirely in your browser, no server required. | Continue reading
Isolated loop variables, range over integers, math/rand v2 and enhanced routing. | Continue reading
Like Jupyter notebooks, but for any language. | Continue reading
Try a query anywhere from PostgreSQL to DuckDB. | Continue reading
A lightweight in-process SQL OLAP engine, powered by ClickHouse. | Continue reading
Using code playgrounds in documentation, teaching and blogging. | Continue reading
Order by in aggregates, better string concatenation, and thorough date formatting. | Continue reading
Learn the basics of FerretDB - a drop-in replacement for MongoDB that uses PostgreSQL or SQLite as a backend. | Continue reading
Inserting and updating data with a single query. | Continue reading
Warning: Major spoilers ahead. | Continue reading
Text version with interactive examples. | Continue reading
Let's write the docs like it's 2023. | Continue reading
Without spending a year on it. | Continue reading
An independent, better alternative to Twitter. | Continue reading
Using the `sqlpkg` package manager. | Continue reading
Using the `sqlpkg` package manager. | Continue reading
For people to follow and discuss. | Continue reading
Find, install and manage SQLite extensions. | Continue reading
To compensate for SQLite's missing features. | Continue reading
70 additional functions are now available in Sqlime. | Continue reading
Computing the smallest/largest value and clearing containers. | Continue reading
Seriously, I don't. I'd prefer SQL. | Continue reading
A drop-in replacement for the sqlite3 module, bundled with essential extensions. | Continue reading
Allows executing queries without touching the table. | Continue reading
If you are an average blogger and not Julia Evans. | Continue reading
A rich set of string functions, from `slice`, `contains` and `count` to `split_part`, `translate` and `repeat`. | Continue reading
Calculate the difference between each record and the previous or next one. | Continue reading
Encoding binary data into a textual representation and vice versa. | Continue reading
According to the standard, we should use be using FETCH. | Continue reading
Assigning each record to a specific segment based on the value of one or more columns. | Continue reading
For those who knew SQL, but kinda forgot it. | Continue reading
Assigning a rank to each row based on the value of one or more columns. | Continue reading
Moving averages, cumulative totals and other sliding aggregates. | Continue reading
Comparing individual values with totals and averages. | Continue reading
Ask AI to explain or troubleshoot your SQL query in a playground. | Continue reading