select * from tools limit 1;
A rich set of functions for working with date, time and durations.
To keep the query from taking forever.
Leave no trace of deleted data.
Build your own document database with SQLite.
Strict column type checking, like in PostgreSQL or MySQL.
To compensate for SQLite's missing features.
A rich set of Unicode-aware functions for working with text.
Calculating message digests and encoding/decoding binary data to a textual representation.
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.
For faster exploratory data analysis.
Faster JSON handling in a relational database.
Regexes, math, file IO and over 100 other functions.
I built an online SQL playground with vanilla JS and a bit of GitHub API.
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.
