New 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

User avatar
Juan F. Ramirez
Rick Dangerous
Posts: 2923
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: New Database Model ZXDB

Post by Juan F. Ramirez »

Einar Saukas wrote:
Sat Jun 01, 2019 5:43 am
A new ZXDB update is available!

This new version contains game review scores from all major magazines (many thanks to Chris from ZXSR for this information!)
Great, a cool feature quite expected (at least for me!)
0 x

User avatar
PeterJ
Site Admin
Posts: 2664
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: New Database Model ZXDB

Post by PeterJ »

We recently spoke about the 'little bug' threads and some way of knowing they have been processed.

@druellan (who kindly tracks and maintains the changes) now has rights to edit posts in the 'ZXDB Discussion' sub-forum (Note - he can edit this section of the forum only).

When a change is accepted and has been processed for entry into ZXDB he will add the following to the end of the post:
✓ Checked
4 x

User avatar
Einar Saukas
Dynamite Dan
Posts: 1421
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Yet another ZXDB update is available!

This release mostly contains latest bugfixes compiled by @druellan based on people's contributions in this forum. :)
4 x

User avatar
R-Tape
Site Admin
Posts: 3417
Joined: Thu Nov 09, 2017 11:46 am

Re: New Database Model ZXDB

Post by R-Tape »

Einar Saukas wrote:
Wed Jun 05, 2019 3:23 am
Yet another ZXDB update is available!

This release mostly contains latest bugfixes compiled by @druellan based on people's contributions in this forum. :)
Fantastic! Bloody well done Dru! You're the Tasmanian Devil of bugfixes (erm—in a good way that is).
1 x

User avatar
druellan
Manic Miner
Posts: 694
Joined: Tue Apr 03, 2018 7:19 pm
Location: Argentina
Contact:

Re: New Database Model ZXDB

Post by druellan »

R-Tape wrote:
Wed Jun 05, 2019 9:45 am
Fantastic! Bloody well done Dru! You're the Tasmanian Devil of bugfixes (erm—in a good way that is).
And the site didn't explode! yay!
1 x

User avatar
Einar Saukas
Dynamite Dan
Posts: 1421
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

In the next upcoming ZXDB update, column "formattype_id" won't be used anymore. This column will still exist in all file-related tables (so it doesn't break SQL queries in sites that were not updated yet), but it will be always NULL.
0 x

User avatar
Einar Saukas
Dynamite Dan
Posts: 1421
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB update is available!

Special thanks to @R-Tape (new titles) and @pavero (hires inlays).
2 x

User avatar
Einar Saukas
Dynamite Dan
Posts: 1421
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

I forgot to mention that I have fixed references to magazine "Personal Computer News" in this last update!

These references were originally imported from Martijn's WoS database. The problem is, "Personal Computer News" was a weekly magazine, but Martijn's WoS only supported monthly magazines, so it couldn't distinguish between different issues released during the same month.

For instance, if you look at references to "Personal Computer News" for "Pssst" at WoS, you will notice that these full page links are missing:

http://www.worldofspectrum.org/infoseek ... id=0009401

Now if you look at the magazine sections for the same game at SC, you will notice that all "Personal Computer News" links work properly:

https://spectrumcomputing.co.uk/index.p ... 96&id=9401

For each page, you have the option to open just the specific page image, or download the entire magazine issue PDF, or view the PDF directly inside the browser. Or you can click on the magazine issue to see a list of other game references in that specific issue. Or even click on the magazine name to get a list of all magazine issues...

If this explanation above sounds confusing, just try it yourself. It's quite intuitive in practice.

Support for magazines is certainly not a new feature at SC. It has existed for ages, but I bet lots of users never noticed it :)
1 x

User avatar
PeterJ
Site Admin
Posts: 2664
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: New Database Model ZXDB

Post by PeterJ »

Einar Saukas wrote:
Tue Jun 18, 2019 10:55 pm
I forgot to mention that I have fixed references to magazine "Personal Computer News" in this last update!
Fantastic @Einar Saukas

PCN was always one of my favourites. It had a very different style to the other weeklies.
0 x

User avatar
djnzx48
Manic Miner
Posts: 722
Joined: Wed Dec 06, 2017 2:13 am
Location: New Zealand

Re: New Database Model ZXDB

Post by djnzx48 »

Not sure if this is a bug or not, but in the past I've noticed the magazine references often link to one past the intended page. For example, the Pssst link takes me to page 79 when the actual reference is on page 78. It seems like the page numbers in archive.org links start at zero, with no page number specified for the first page, so subtracting one from the page number in the SC links might fix the problem.
0 x

Post Reply