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
Tuple vs dataclass, until numpy interferes | Continue reading
Faster JSON handling in a relational database. | Continue reading
Regexes, math, file IO and over 100 other functions. | Continue reading
And why some methods take constant time while others take linear. | Continue reading
Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek. | Continue reading
Let’s say you want to check how a query behaves on a large table - but there is no such table at hand. This is not a problem if your DBMS supports SQL recursion: lots of data can be generated with a single query. The WITH RECURSIVE clause comes to the rescue. | Continue reading