For anyone that needs it, I’ve created a clone of the Chinook database for SQLite, to handle some testing I was doing. The main changes are the addition of a version field for use in testing concurrency and a few changes to the naming conventions.
Xojo self-made app to edit graphically databases (sqlite, postgres and mysql for now, but more if needed)
nice thing is to quite immediately make listboxes from the database structure, or pages to edit the data.
still there are important missing things that prevent it to be sold as a developper tool, but as I don’t use them it’s ok for me !
Because the diagram came from something else ?
Or from something that just assumed that ID is ALWAYS a primary key (I’ve known some tools that did this in the past)
Or any other reason like maybe the diagram isn’t 100% correct ?