New Database Model ZXDB
Moderator: druellan
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB update is available!
It includes lots more bugfixes, updated magazine issues information, and even more hi-res inlays from [mention]pavero[/mention].
It includes lots more bugfixes, updated magazine issues information, and even more hi-res inlays from [mention]pavero[/mention].
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
One of ZXDB's main goals is to work as a "hub", integrating several Spectrum-related sites. It's a great advantage for these sites, because it increases their popularity. Many SC users end up watching RZX videos on YouTube linked from SC pages, for instance. Users interested in a certain artist or musician frequently visit their ZX-Art link to see what else they have created, and so on. It's also a great advantage for ZXDB itself, because this integration saves the effort to put the entire universe into our database. For instance, we don't need to keep track of all playing tips about games, a direct link to The Tipshop works much better. And most of all, it's a great advantage for all users, because they can simply visit the SC page about a certain title, entity or magazine, to easily find links to almost every related site from there.
However it's not easy to keep integration very up-to-date in case of sites that change frequently. Whenever new content is added to one of these sites, this information can only be added to ZXDB in a future update. Depending on the change, if we are too busy working on other aspects of the archive, it may take a couple months until we have time to make the corresponding changes in ZXDB.
To solve this problem, we are now adopting a new strategy especifically for Daren's RZX Archive and Pavel's Speccy Screenshot Maps. Instead of distributing outdated content from these 2 sites in the standard ZXDB distribution, we are now providing a separate script to import content from each site into ZXDB. The scripts are called "ZXDB_import_rzx.sql" and "ZXDB_import_mapy.sql", they are available here. This way, site owners (and other systems based on ZXDB) can easily update content from these sites into ZXDB themselves, any time they want, without having to wait for a new ZXDB update.
In practice, nothing will change to end-users. We are just increasing flexibility in the process of updating ZXDB, that's all. Also it won't affect the way we work closely with both Daren and Pavel in this integration. In particular, we are continuing our efforts to ensure any missing titles mentioned by either site will get added to ZXDB. As a matter of fact, we have just finished automating the process to identify missing titles, it can be seen at the bottom of this page.
However it's not easy to keep integration very up-to-date in case of sites that change frequently. Whenever new content is added to one of these sites, this information can only be added to ZXDB in a future update. Depending on the change, if we are too busy working on other aspects of the archive, it may take a couple months until we have time to make the corresponding changes in ZXDB.
To solve this problem, we are now adopting a new strategy especifically for Daren's RZX Archive and Pavel's Speccy Screenshot Maps. Instead of distributing outdated content from these 2 sites in the standard ZXDB distribution, we are now providing a separate script to import content from each site into ZXDB. The scripts are called "ZXDB_import_rzx.sql" and "ZXDB_import_mapy.sql", they are available here. This way, site owners (and other systems based on ZXDB) can easily update content from these sites into ZXDB themselves, any time they want, without having to wait for a new ZXDB update.
In practice, nothing will change to end-users. We are just increasing flexibility in the process of updating ZXDB, that's all. Also it won't affect the way we work closely with both Daren and Pavel in this integration. In particular, we are continuing our efforts to ensure any missing titles mentioned by either site will get added to ZXDB. As a matter of fact, we have just finished automating the process to identify missing titles, it can be seen at the bottom of this page.
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
On second thought, I decided to provide both options.Einar Saukas wrote: ↑Tue Sep 24, 2019 10:56 pm To solve this problem, we are now adopting a new strategy especifically for Daren's RZX Archive and Pavel's Speccy Screenshot Maps. Instead of distributing outdated content from these 2 sites in the standard ZXDB distribution, we are now providing a separate script to import content from each site into ZXDB. The scripts are called "ZXDB_import_rzx.sql" and "ZXDB_import_mapy.sql", they are available here. This way, site owners (and other systems based on ZXDB) can easily update content from these sites into ZXDB themselves, any time they want, without having to wait for a new ZXDB update.
From now on, every ZXDB release will already contain the latest distribution of RZX Archive and Speccy Screenshot Maps. But the import scripts will also remain available, so if their contents change, they can be updated again without waiting for another ZXDB release.
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB update is now available!
I'm glad to announce that ZXDB is now integrated with World of SAM. Many thanks to Andrew Collier for approving this integration, and [mention]Stefan[/mention] for adding all information about Sam Coupé titles into ZXDB!
On a more technical side, columns "labels.spot_name" and "labels.spot_comment" were merged into a single column "labels.comments". In practice, this column will indicate when SPOT/SPEX contains a different spelling for certain person or company names (that will need to be validated later).
I'm glad to announce that ZXDB is now integrated with World of SAM. Many thanks to Andrew Collier for approving this integration, and [mention]Stefan[/mention] for adding all information about Sam Coupé titles into ZXDB!
On a more technical side, columns "labels.spot_name" and "labels.spot_comment" were merged into a single column "labels.comments". In practice, this column will indicate when SPOT/SPEX contains a different spelling for certain person or company names (that will need to be validated later).
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB update is now available!
This update adds FRED magazine (for the SAM Coupé) to the archive.
This update adds FRED magazine (for the SAM Coupé) to the archive.
Re: New Database Model ZXDB
I've noticed there are SAM games (listed on World of Sam) missing from the archive. Are these something that someone is working on gradually adding or do you consider the import to be complete?Einar Saukas wrote: ↑Mon Sep 30, 2019 2:18 pm I'm glad to announce that ZXDB is now integrated with World of SAM. Many thanks to Andrew Collier for approving this integration, and @Stefan for adding all information about Sam Coupé titles into ZXDB!
Re: New Database Model ZXDB
I may have missed a few that I had no connection with. Feel free to add them.8BitAG wrote: ↑Thu Oct 03, 2019 6:41 amI've noticed there are SAM games (listed on World of Sam) missing from the archive. Are these something that someone is working on gradually adding or do you consider the import to be complete?Einar Saukas wrote: ↑Mon Sep 30, 2019 2:18 pm I'm glad to announce that ZXDB is now integrated with World of SAM. Many thanks to Andrew Collier for approving this integration, and @Stefan for adding all information about Sam Coupé titles into ZXDB!
I was also thinking about the disk magazines (mainly FRED) - theoretically individual entries per disk could be added similar to what has been done for Outlet.
On another note - how can we get loading / running screens into the database?
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Yet another ZXDB update is available!
This version contains new titles (thanks [mention]R-Tape[/mention]!).
This version contains new titles (thanks [mention]R-Tape[/mention]!).
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
If either of you is willing to add any of the remaining titles, please let me know. Thank you!!!
There are basically 2 ways to contribute with information about titles. The simplest method is filling this spreadsheet. The other method is running ZX-Ed locally, that will give you a lot more flexibility.
Awesome!
Please read instructions here. However I don't know if there's a standard format for SAM Coupé screens, I'm contacting [mention]moroz1999[/mention] now to ask him about it.
Re: New Database Model ZXDB
Thanks for contacting! I'll make a separate topic about Sam Coupe formats.
Re: New Database Model ZXDB
Well, there are quite a lot of missing SAM titles that fall under my specialism of text adventures, most of which are listed on World of Sam, so I'll look into adding them to the database.Einar Saukas wrote: ↑Fri Oct 04, 2019 3:42 pm If either of you is willing to add any of the remaining titles, please let me know. Thank you!!!
There's also our Sam Adventure Club magazine disks, as well as all the various compilations that we collaborated on with several homebrew publishers... These are things like compilations of Zenobi's Spectrum titles that have various tweaks (such as offering additional choices of fonts & user-defined colour schemes) and Sam-specific features such as disk saves... I'm not quite sure how these will slot into the database...
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB update is available!
This version mostly contains bugfixes provided by [mention]druellan[/mention].
This version mostly contains bugfixes provided by [mention]druellan[/mention].
Re: New Database Model ZXDB
Thanks [mention]Einar Saukas[/mention]
If everything goes to plan, I will update the site this evening.
If everything goes to plan, I will update the site this evening.
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB update is available!
It includes new titles (thanks [mention]R-Tape[/mention]!), new hires inlays (thanks [mention]pavero[/mention]!), and new fixes (thanks [mention]druellan[/mention]!).
It includes new titles (thanks [mention]R-Tape[/mention]!), new hires inlays (thanks [mention]pavero[/mention]!), and new fixes (thanks [mention]druellan[/mention]!).
Re: New Database Model ZXDB
Fast work Einar. Hope it wasn't too painful
And clickety-click, that marks the 66th ZXDB update at SC (plus an as-yet uncounted number from BSCE*)
*before Spectrum Computing Era
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB update is available!
Once again it contains new titles (thanks [mention]R-Tape[/mention]!), new hires inlays (thanks [mention]pavero[/mention]!), and new fixes (thanks [mention]druellan[/mention]!).
Once again it contains new titles (thanks [mention]R-Tape[/mention]!), new hires inlays (thanks [mention]pavero[/mention]!), and new fixes (thanks [mention]druellan[/mention]!).
Re: New Database Model ZXDB
Stairway to heaven, update #67!*
*plus however many were done BSCE if anyone wants to count.
EDIT - just realised that bingo calls stop at 90. Might have to think again on this.
*plus however many were done BSCE if anyone wants to count.
EDIT - just realised that bingo calls stop at 90. Might have to think again on this.
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB update is available!
As usual, it contains new titles (thanks [mention]R-Tape[/mention]!), new hires inlays and/or instructions (thanks [mention]pavero[/mention]!), and new fixes (thanks [mention]druellan[/mention]!).
As usual, it contains new titles (thanks [mention]R-Tape[/mention]!), new hires inlays and/or instructions (thanks [mention]pavero[/mention]!), and new fixes (thanks [mention]druellan[/mention]!).
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB update is now available!
Merry Xmas!!!
Merry Xmas!!!
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB update is available!
This time, it contains new titles (thanks [mention]R-Tape[/mention] and [mention]pavero[/mention]!), new hires inlays and instructions (thanks again [mention]pavero[/mention]!) and new fixes (thanks [mention]druellan[/mention]!)
This time, it contains new titles (thanks [mention]R-Tape[/mention] and [mention]pavero[/mention]!), new hires inlays and instructions (thanks again [mention]pavero[/mention]!) and new fixes (thanks [mention]druellan[/mention]!)
Re: New Database Model ZXDB
Just a quick note for new content fans: I won't be able to do my part of an update until near the end of Feb. I'm keeping track of everything that needs doing though, including [mention]Alessandro[/mention]'s and [mention]Ersh[/mention]'s updates. Cheers.
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
In the meantime... A new ZXDB update is available!
- Einar Saukas
- Bugaboo
- Posts: 3070
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB update is now available!
It contains new titles (thanks both [mention]R-Tape[/mention] and [mention]pavero[/mention]!), new hires inlays and instructions (thanks again [mention]pavero[/mention]!) and more fixes (thanks [mention]druellan[/mention]!) as usual. Also the first few issues of Load'n'Run are now cataloged (thanks [mention]Alessandro[/mention]!)
It contains new titles (thanks both [mention]R-Tape[/mention] and [mention]pavero[/mention]!), new hires inlays and instructions (thanks again [mention]pavero[/mention]!) and more fixes (thanks [mention]druellan[/mention]!) as usual. Also the first few issues of Load'n'Run are now cataloged (thanks [mention]Alessandro[/mention]!)
Re: New Database Model ZXDB
I missed my chance in December to say update #69, Head over heels!
But we're on #72 now*, so the point is moot
*plus previous, as yet uncounted updates from BSCE.
Re: New Database Model ZXDB
Ah! Got it:
Mr Do!... Update number 72!
Mr Do!... Update number 72!