←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
nodesocket ◴[25 Aug 25 14:45 UTC] No.45014439[source]▶
This looks great, installing now. I've been using DBeaver, but it's not optimized for SQLite. Common issue with DBeaver is having to refresh the global connection to see changes.

EDIT: Very minor nitpick but noticed I changed my icon to dark, but not taking effect. Still using light icon.

replies(1): >>45014456 #
bdcravens ◴[25 Aug 25 14:47 UTC] No.45014456[source]▶
What you just described sounds like the kind of marketing I feel is missing from the site: if you're already using a multi-db tool, what's compelling about this product?
replies(1): >>45014845 #
1. __bb ◴[25 Aug 25 15:21 UTC] No.45014845[source]▶
That's a good point and something I'd not considered.

I'd say the main benefit is that it's tailored only to SQLite's features.

You don't have to tweak a UI tailored for remote connections to work with local files. You don't need to have extra sections dedicated to user management or stored procedures which are inactive. I guess I'm saying that in this case less is more!