←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
watersb ◴[25 Aug 25 23:03 UTC] No.45020223[source]▶
I've always found database structure diagrams to be useful, and I like tools that synchronize editing the structure via the diagram or the SQL code.

I believe the macOS app OmniGraffle can do this, like Microsoft Visio on Windows.

I currently have a copy of Database Designer installed on an Android tablet, it's quite effective for my simple projects.

https://play.google.com/store/apps/details?id=com.klim.dbdes...

Database Designer developer says the app is "free forever", which is nice. App stores note in-app purchases; these are voluntary donations like "Buy Me a Coffee".

The app also has some brief demo videos that are linked as online help.

replies(1): >>45020469 #
1. mistersquid ◴[25 Aug 25 23:27 UTC] No.45020469[source]▶
> I believe the macOS app OmniGraffle can do this, like Microsoft Visio on Windows.

I don't think Omnigraffle offers direct synchronization for editing database structures between its diagrams and SQL code.