What's new in SQLite 3.37

Strict tables, any type and a new pragma.

SQLite playground in the browser

I have built an online SQL playground with vanilla JS and a bit of GitHub API. Here's how.

SQLite is not a toy database

Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek.

How to create a 1M record table with a single query

With recursive CTE and randomized data.

SQLite is not so easy to compile

But with GitHub Actions it is.

What's new in SQLite 3.35

Math functions, column removal and RETURNING clause.