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. – user1824987 May 13 '19 at 14:28
-
1
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) – Mawg says reinstate Monica Sep 14 '18 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.