←back to thread

Show HN: Base, an SQLite database editor for macOS

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

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.

1. benhurmarcel ◴[25 Aug 25 16:03 UTC] No.45015316[source]▶
Can somebody recommend a similar tool that works with DuckDB files?
replies(6): >>45015421 #>>45015940 #>>45017205 #>>45018438 #>>45019681 #>>45024571 #
2. weaksauce ◴[25 Aug 25 16:12 UTC] No.45015421[source]▶
not as slick as this tool but https://dbeaver.io/ handles duckdb databases as well as a myriad of others.
3. nicoritschel ◴[25 Aug 25 16:55 UTC] No.45015940[source]▶
I am launching one very soon; it's similarly built in Swift & macOS only. Here's the web version I built almost a year ago you can play with in the meantime.

https://sidequery.dev

4. FelipeCortez ◴[25 Aug 25 18:29 UTC] No.45017205[source]▶
Ultorg doesn't handle schema modification but is my favorite tool for data inspection
5. speedgoose ◴[25 Aug 25 20:14 UTC] No.45018438[source]▶
TablePlus perhaps.
6. ahasani ◴[25 Aug 25 22:06 UTC] No.45019681[source]▶
not similar, but more like jupyter

https://duckdb.org/docs/stable/core_extensions/ui

7. wodenokoto ◴[26 Aug 25 10:19 UTC] No.45024571[source]▶
`duckdb —-ui` is quite powerful, although edits still have to happen through written queries.