I would like to have a software tool to create/modify/view table relationships in a SQLite database in a visual way, something like the picture below. For a MySQL database, I can use the MySQL workbench to view 1-to-many relationships. Is there an equivalent tool for SQLite?
Dbeaver is also a great tool to work with databases including SQLite and can visualize the relations between tables
1Great software recommendation. I have changed the best answer to yours. May 13, 2019 at 14:28
1Glad I could help– ThomasMay 13, 2019 at 15:17
The viewing part can be achieved using SchemaCrawler; amongst its features, it generates database diagrams. It supports various database formats, including SQLite. Disclaimer: I haven't used it (yet).
Here is an example image, found on the roman10 website.
There are plenty of apps which will let you modify an existing database, which this answer does not claim. Since you accepted this answer, I won't go into detail, but GIYF (my personal recommendation is sqlitestudio.pl/index.rvt?act=gallery) Sep 14, 2018 at 10:51
Datagrip by jetbrains supports SQLite. I've used it for other (MySQL, Oracle) types of databases, and it's been good. However, I haven't used it for SQLite.