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.
Is that another way of saying you don't want to make MS Access?
I still use Access quite a bit and I think it's pretty great. It's too bad that nothing like that exists for modern databases.
Many years ago, there was a project that tried to do just that using Tcl/Tk, which seems like a fine choice - Tcl is very simple and easy to understand even for on-programmers while its deficiencies aren't really important in this niche, and Tk is one of the easiest UI frameworks around to use. Unfortunately it petered out and I can't even remember the name anymore...