Encoding binary data into a textual representation and vice versa.
Ask AI to explain or troubleshoot your SQL query in a playground.
Turn static SQL code in your articles into executable examples.
Working with files and traversing directories from SQL.
Three ways to create a pivot table in plain SQL.
Use a robust pattern matching and text replacement tool from SQL.
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.