Storing booleans as timestamps sounds crazy, but in reality it is actually not a bad idea. In this video I talk about the pros/cons of this approach so you can evaluate if it is right for you.

Since the creation of SQL, we had many databases trying to reduce the relationship between our datas, but we never had any database trying to do the opposite and increase the relationships. Thats now the case with EdgeDB, and i must say, it seems pretty seducing.

We talked about performances issues with uuid and cuid last month. This time we will dig deeper into the mess of uuid, and because sometimes integer ids are not recommended, here is an introduction to nanoid instead. Id like to have a benchmark on it too, but seems for now that its way more efficient.

Should we use integer, cuid or uuid for our database ids type ? An interesting comparison between the 3 of them based on their performances, and by extension, their costs.

Astro introduces a new database hosting solution, based on SQLite & Turso. Installation and usage are extremely simple under Astro with a free tier limited to 1GB of data, 1 billion read operations, and 1 million write operations.