←back to thread

Show HN: Base, an SQLite database editor for macOS

(menial.co.uk)
676 points __bb | 1 comments | 25 Aug 25 14:17 UTC | HN request time: 0s | source

I recently released v3 of Base, my SQLite editor for macOS.

The goal of this app is to provide a comfortable native GUI for SQLite, without it turning into a massive IDE-style app.

The coolest features are

- That it can handle full altering of tables, which is quite finicky to do manually with SQLite.

- It has a more detailed display of column constraints than most editors. Each constraint is shown as an icon if active, with full details available on clicking the icon.

This update also adds support for attaching databases, which is a bit fiddly with macOS sandboxing.

I'd love to hear any feedback or answer any questions.

Show context
earthnail ◴[25 Aug 25 15:32 UTC] No.45014961[source]▶
It would be amazing if it could display UUIDs. SQlite doesn't support them natively, but many people store them as binary blobs.

Jetbrains products realize that these binary values are UUIDs and let me edit them easily.

replies(4): >>45015712 #>>45015789 #>>45016676 #>>45018174 #
__bb ◴[25 Aug 25 16:35 UTC] No.45015712[source]▶
Thanks, I'll make a note of that. It's not a behaviour I've seen before.
replies(2): >>45016053 #>>45022765 #
1. earthnail ◴[26 Aug 25 05:55 UTC] No.45022765[source]▶
I work a lot with syncing code for mobile apps, and use sqlite for local dbs on the app, which I guess is fairly standard. UUIDs make sync protocols much easier to write.