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!
Remote
Ben Barnett
@__bb@mastodon.social
mastodon 4.8.0-nightly.2026-10-06Ex-farmer, still a developer.
I like building things and learning. Preferably at the same time.
0 Followers
0 Following
16 Posts
Joined January 25, 2023
Web:
I'm very please to say that Base 3.0 is now available!
If you work with SQLite database files, I think you should check it out.
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 just said “you’re absolutely right” to someone at work and now I’m wondering if I’m an LLM in a skin-suit.
Me, completely unable to see why something isn't saving: 😵💫
The code:
onCancel: { save() },
onSave: { cancel() }
Time to call it a night…
I’ve written small blog post on the date formats supported by SQLite:
I am not good at the game Baba Is You, and it hurts my brain more than I’d like, but the *satisfaction* of solving a level is top-notch.
Something that has been making me very happy lately is BirdNET-Pi (https://github.com/Nachtzuster/BirdNET-Pi ). It’s delightful to see the different birds that pass by and to help me recognise the different calls. It’s up to 54 species in about two months, even pruning ones I know are false positives!
I love the game over animation!
@PadraigOCinneide@mastodon.social
I’ve been using an app to help remind me to drink water during the day for three years.
After an update, it asked me if I wanted to use its cryptocurrency to reward my drinking habits. It’s social media feed talks about “AI gulp detection” to record my drinking sounds and estimate intake.
I am feeling quite gloomy about it.
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/
Replying to
@groue Thanks :)
I agree it’s the least surprising format, and probably most easily recognised.
Replying to
@dmd Thank you, I might add that as an edit to the post. I've generally avoided DATETIME as a type because it doesn't often benefit me. The column name usually indicates there's a date in there and the DATETIME (NUMERIC) -> INT -> REAL -> TEXT cascade doesn't come in to play, since I'm always inserting data of the same format. Picking a more specific type to start with just feels right, though it's definitely a personal preference thing. Thanks for mentioning it though :)
Replying to
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.
I thought I'd have an experiment with the codex app and asked it to do something with codegen. Things got a bit out of hand. This is the first time I've had macOS force me to terminate apps due to memory pressure!