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 !
@James Dooley : why does the track table have a primary key in dbschema, and no pk in dave’s and my app ?
I also tested in some other db tools I have and they don’t set the ID field as a primary key.
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 ?