Weekly SQLite news, articles and extensions.
Write functions in plain SQL.
Use them instead of subqueries.
For faster exploratory data analysis.
Faster JSON handling in a relational database.
Simplify queries without storing additional data.
How to edit a big query without leaving the CLI
Search for the query instead of typing it by hand.
Regexes, math, file IO and over 100 other functions.
Strict tables, any type and a new pragma.
I have built an online SQL playground with vanilla JS and a bit of GitHub API. Here's how.
Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek.
With recursive CTE and randomized data.
But with GitHub Actions it is.
Math functions, column removal and RETURNING clause.
