Topics / Databases
Fixing synapse 1.128.0 with SQLite
Synapse 1.128.0 came with a unpleasant surprise, here is how I worked around it
Redenormalisation: Building a search index, the other way
Why unobtanium doesn't go by the textbook when it comes to normalisation in the search index.
SQL Cheatsheet
Some useful reminders for the occasional SQL user.
The SQLite strict Guide
How to make data validation in SQLite possible, an overview