Database model ZXDB

This is the place for general discussion and updates about the ZXDB Database. This forum is not specific to Spectrum Computing.

Moderator: druellan

hikoki
Manic Miner
Posts: 576
Joined: Thu Nov 16, 2017 10:54 am

Re: Database model ZXDB

Post by hikoki »

The license of Mojon Twins' MK2 engine has changed to copyleft CC BY-NC-SA 3.0. and released on github: https://github.com/mojontwins/mk2
See the announcement on their site: http://www.mojontwins.com/2018/01/12/li ... -spectrum/
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas »

hikoki wrote: Tue Jan 23, 2018 2:14 pm
Einar Saukas wrote: there's now a new group called "Gamebook (Multi-Choice Fiction)" to distinguish it from other adventures.

Here's the current list of games in this group:

https://spectrumcomputing.co.uk/index.p ... up_id=1038

This list is still missing "El Cementerio", that will be added in next ZXDB update. Are there any others?
There you have a few more CYOA. There must be more for sure.

https://awesome-table.com/-KTJLy2xX7_E1 ... N=gamebook

http://www.worldofspectrum.org/infoseek ... loadpics=1

http://www.worldofspectrum.org/infoseek ... loadpics=1

http://www.worldofspectrum.org/infoseek ... loadpics=1
Thank you!!!

This information will be in the next ZXDB update.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas »

hikoki wrote: Wed Jan 24, 2018 1:29 pm The license of Mojon Twins' MK2 engine has changed to copyleft CC BY-NC-SA 3.0. and released on github: https://github.com/mojontwins/mk2
See the announcement on their site: http://www.mojontwins.com/2018/01/12/li ... -spectrum/
Thank you!!! It will be in the next ZXDB update too.
Ralf
Rick Dangerous
Posts: 2279
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: Database model ZXDB

Post by Ralf »

Einar, I would have an question.

Running your script deletes exisitng database and makes a new one or updates an existing database?

I created my local copy in ZXDB as described in this thread:
viewtopic.php?f=32&t=328

if I create some sql views and other changes in my database and later run the latest update script I'll lose my changes, right?
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas »

Ralf wrote: Thu Jan 25, 2018 1:48 pmRunning your script deletes exisitng database and makes a new one or updates an existing database?
The script don't delete anything, but it assumes ZXDB tables don't exist, or they are all empty.

Technically the "incremental" scripts in ZXDB were originally intended to allow people update their database copy without recreating anything. However it was too much work to maintain them this way, and nobody was benefiting from them, so they don't work this way anymore. Although "incremental" scripts still exist, now they only serve the purpose of "auditing" (so anyone can see and help validate every correction and addition made to the original WoS content).

Ralf wrote: Thu Jan 25, 2018 1:48 pmif I create some sql views and other changes in my database and later run the latest update script I'll lose my changes, right?
If you delete data from all ZXDB tables, then run the ZXDB script, these tables will be repopulated with latest ZXDB content without losing your views. However if you made changes to ZXDB tables content, they would be lost. Notice that there's not much I could do to help you in this latter case. Even if I provided a separate script containing only the ZXDB changes, there's always the chance that a certain ZXDB update will override exactly the information you previously changed yourself...

My suggestion is, write instead your own script to create views and whatever other changes you want. Whenever there's a new ZXDB update, you can simply drop the entire database, run the latest ZXDB script, then run your own script afterwards. This is exactly how ZX Pokemaster build works now, I suggest you take a look at its source code.
Ralf
Rick Dangerous
Posts: 2279
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: Database model ZXDB

Post by Ralf »

Thanks for the explanation.
Yes. keeping your views in a script seems a sane idea. And I wasn't going to alter the tables themselves.
User avatar
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: Database model ZXDB

Post by kolbeck »

Einar Saukas wrote: Fri Jan 26, 2018 2:39 am
My suggestion is, write instead your own script to create views and whatever other changes you want. Whenever there's a new ZXDB update, you can simply drop the entire database, run the latest ZXDB script, then run your own script afterwards. This is exactly how ZX Pokemaster build works now, I suggest you take a look at its source code.
ZXInfo works the same way, it assumes a clean ZXDB before doing its own work. I did try for long time to see if mysqldbcompare could do some kind of incremental update, but with no luck.

/Thomas
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
hikoki
Manic Miner
Posts: 576
Joined: Thu Nov 16, 2017 10:54 am

Re: Database model ZXDB

Post by hikoki »

I've noticed Spectrumcomputing is including more and more .tap files :)
I would recommend that someone checks out SC's files against the ones from my site Speccy21 as I've been quite scrupulous when collecting new updates. I can share my archive in a zip as well as my spreadsheet.
For example, Gabriele Amore put in-game music in all of his games recently. My guess is this game version does not have AY music: https://spectrumcomputing.co.uk/index.p ... 6&id=30230
User avatar
R-Tape
Site Admin
Posts: 6353
Joined: Thu Nov 09, 2017 11:46 am

Re: Database model ZXDB

Post by R-Tape »

Cheers hik, I'll drop you a PM tomorrow.

I added a load in the last update, and your site is one of the main sources (I've always said you're an unsung hero). Hope you're cool with this, but I'd like to discuss in more detail tomorrow. I did almost all of Gab's in the last site update, but it was hard to pick the right file in his dropbox every time. I noticed some has two AY tracks.

BTW your Popeye is still Pengoquest :-p
hikoki
Manic Miner
Posts: 576
Joined: Thu Nov 16, 2017 10:54 am

Re: Database model ZXDB

Post by hikoki »

R-Tape wrote: BTW your Popeye is still Pengoquest :-p
Oops. Ta! I had to do some automatic replacements within the spreadsheet. I'll check out it there are more bugged links like that one.
As for Gabam's games, I updated my download links after visiting his facebook page a few weeks ago.

Maybe I can help you somehow after reading your PM. Cheers
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas »

A large ZXDB update is now available here!

Once again, this update containing lots of screenshots and playable files for recent game releases, and some additional new information.

Many thanks to Pavero for providing screenshots, R-Tape for cataloguing most new files, Radek Boruta for reporting a few more bugs in the original WoS data that I didn't notice before, hikoki for continuing to provide information I'm constantly adding to ZXDB, and everybody else that provided other contributions I probably forgot to mention!
User avatar
PeterJ
Site Admin
Posts: 6852
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Database model ZXDB

Post by PeterJ »

Thanks [mention]Einar Saukas[/mention] and all those who helped with this update.

SC has been updated with the new version.

https://spectrumcomputing.co.uk/index.php?cat=301
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas »

Another ZXDB update is available here, adding even more playable files and screenshots!

Thanks again to all contributors, and especially R-Tape for doing most of the actual work to update ZXDB lately :)
User avatar
PeterJ
Site Admin
Posts: 6852
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Database model ZXDB

Post by PeterJ »

Thanks [mention]Einar Saukas[/mention] and [mention]R-Tape[/mention] I will get that installed in the morning.
User avatar
PeterJ
Site Admin
Posts: 6852
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Database model ZXDB

Post by PeterJ »

The excitement of a new release got the better of me, and I have now installed it on our server! Enjoy.
User avatar
R-Tape
Site Admin
Posts: 6353
Joined: Thu Nov 09, 2017 11:46 am

Re: Database model ZXDB

Post by R-Tape »

Excellent! Ta fellas.

A lot of things were added, more than I can be arsed to list, but here are a few notes:

All the new releases
Alessandro's update of Apulija13, replete with translations
The so far never released Monument Microgames variants of El Stompo (each has a different loader, level 3 and finale)
Lots of gaps filled post 2013, still plenty more though
Some choice CSS CGC entries -Chromatrons Attack (uses moire technique that makes most emulators fail) and Advanced Junglist Simulator (just try it)
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas »

A major ZXDB update is available here!

As usual, it contains lots of playable files, screenshots, and the latest games. Many thanks to all contributors (Pavero, R-Tape, and many others). And very special thanks to Thomas for all the hard work on mapping over 2,000 games to their corresponding links at Mobygames!!! :)
User avatar
PeterJ
Site Admin
Posts: 6852
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Database model ZXDB

Post by PeterJ »

Good morning

Spectrum Computing has been updated with the new version of ZXDB. Thanks for all involved in this update.

https://spectrumcomputing.co.uk/index.php?cat=301
User avatar
R-Tape
Site Admin
Posts: 6353
Joined: Thu Nov 09, 2017 11:46 am

Re: Database model ZXDB

Post by R-Tape »

A bit more detail on the ZXDB/SC update ([mention]PeterJ[/mention] I'll give you more info next time so you can announce in your post)

The latest additions to ZXDB.
More screens than you can shake a stick at (assuming you wanted to shake a stick at them).
Various fixes and files.
Most of Kweepa's 2013 CGC entries. Most are not actually crap and are great examples of BASIC programming.
Retroworks permission (sorry we asked twice and forgot about it - for shame!). So now IANNA, Brunilda and the rest of their wayyyy above average games are available.
Ralf's old/new games.

Apologies: Missed this update but in the next.
Stormfinch TRD and SCL added, but the way to credit didn't meet the update, next one will have comments under the files crediting Denis Grachev & goodboy
Permission from APSIS c/o IvanZX
Retrobytes permission c/o IvanZX
About a hundred file changes for Alessandro :-p
Wrong date on Fantasy Zone.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas »

A huge ZXDB update is available here!!!

Besides many playable files, screenshots, and information about latest games (thanks R-Tape, Pavero and others!), we also have more Mobygames links (thanks Thomas!), all cover artists credits (thanks Juan and others!), updated integration with latest RZX Archive (thanks Daren!), and lots other fixes and improvements I cannot remember right now :)
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas »

... and more details about this last update were provided here.
User avatar
Alessandro
Dynamite Dan
Posts: 1908
Joined: Wed Nov 15, 2017 11:10 am
Location: Messina, Italy
Contact:

Re: Database model ZXDB

Post by Alessandro »

R-Tape wrote: Tue Feb 13, 2018 11:04 am Apologies: Missed this update but in the next.
[...]
About a hundred file changes for Alessandro :-p
Missed again :evil:
User avatar
R-Tape
Site Admin
Posts: 6353
Joined: Thu Nov 09, 2017 11:46 am

Re: Database model ZXDB

Post by R-Tape »

Alessandro wrote: Sat Feb 24, 2018 1:12 pm Missed again :evil:
Not entirely, these have happened:
Put LIMS v1 into a .zip as historical dev material
Put Apulija13 v1 into a .zip as historical dev material
Sort out 'The Trunk'
These may have happened (I've lost track of all the new versions):
Update SCL,TRD, PDF for Sophia.
ADB: remove the TRD and PDF, add the new TRD,MGT,SCL, PDF
These definitely have not happened:
ADB: remove the Tape images
Remove LIMS TRD files.
Sorry Ale, we'll get it sorted but it may be a few days now :(
User avatar
R-Tape
Site Admin
Posts: 6353
Joined: Thu Nov 09, 2017 11:46 am

Re: Database model ZXDB

Post by R-Tape »

ADB: remove the Tape images
Remove LIMS TRD files.
This is now sorted (ta Peter), so just the disk updates to check.
User avatar
Alessandro
Dynamite Dan
Posts: 1908
Joined: Wed Nov 15, 2017 11:10 am
Location: Messina, Italy
Contact:

Re: Database model ZXDB

Post by Alessandro »

Thanks for replying, I understand synchronizing the database is still a huge task. Will wait some more time then :)
Locked