←back to thread

676 points __bb | 1 comments | | HN request time: 0.258s | 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.

1. keyle ◴[] No.45019438[source]
I use Base everyday but it's leaps and bounds behind Postico for Postgres in terms of UX.

Copy pastes, duplicate rows, sorting and filtering. Sadly postico does not do SQLite.

But for SQLite as native app, there is no better than Base.

Look forward to the upgrade thank you.

Edit: thanks for row edit, that's great. What about duplicating rows or copying between tables of the same structure?