| Web | https://menial.co.uk |
Now this is a good bug write-up:
https://www.sqlite.org/wal.html#walresetbug
"the occurrence rate of this problem in the wild appears to be less than or equal to the expect occurrence rate of SSD malfunctions and/or cosmic-ray hits"
I've posted an update to Base (v3.3) which adds Quick Look previews for SQLite databases. You can now see a summary of database contents from the Finder, without having to open the app!
A realtime acoustic bird classification system for the Raspberry Pi 5, 4B 3B+ 0W2 and more. Built on the TFLite version of BirdNET. - Nachtzuster/BirdNET-Pi
I’ve released v3.2 of Base this week. This update tidies the table editor UI, making it clearer and easier to understand. There’s a new context menu item for inserting special values (dates, UUIDs, NULL) into tables. It also has an experimental feature for showing/hiding columns in the data browser, which is handy for wide tables.
More details here: https://menial.co.uk/blog/2025/12/01/base-3.2.0-released/
John Nix Pocketbook 2023 (53rd edition)
• Grab the nearest book.
• Turn to page 42.
• Find the 2nd sentence.
• Post the sentence in a toot with the #page42 hashtag & write the rules as a comment.
• Don’t look for your favourite, coolest or wittiest book. Go for the closest.
“However, over the last twenty years, the reputation of English and Welsh sparkling wines has improved considerably and with the rising availability of these wines, more outlets, both on-trade and off-trade, now stock them.”
John Nix Pocketbook 2023
#page42
I’ve written small blog post on the date formats supported by SQLite:
SQLite columns are flexibly-typed, you can put broadly anything in any column regardless of the declared type of that column. There also isn’t a specific type for dates or times. This means that when it comes to storing dates or times, we’ve got choices to make. I’ll go through the main options in this post.