can someone tell me what are some common use cases of such a tool? may be i'm not the intended customer base, but am curious to know what others are using it for.
replies(3):
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.
- Storing results for scientific research
- Local analysis of data exported from server-based databases
- Experimenting with database designs before exporting SQL to codebases
- Maintaining relational data where a website or app are not needed (eg. tutors keeping client records)
- Recovering data from databases used by other products (eg. phone backups, discontinued apps)