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
Einar Saukas
Manic Miner
Posts: 911
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Fri Jul 26, 2019 6:01 pm

Juan F. Ramirez wrote:
Fri Jul 26, 2019 5:42 pm
Hi @Einar Saukas , it seems there's a problem in the Microhobby folder.

Whenever I click on [PDF] works ok (the PDF file is shown) but if I click on [VIEW] a new archive.org screen appears with the next error message:

'The item you have requested has a problem with one or more of the metadata files that describe it, which prevents us from displaying this page'
That's a problem at Archive.org. I will try to find a different source. Thanks for reporting it!

Juan F. Ramirez wrote:
Fri Jul 26, 2019 5:42 pm
Besides, in the list of Microhobby issues, before #1 issue some random issues appear (with no corresponding picture):

1985/10
1987/3
1987/7
1991/4
1991/5
1991/12
These are "lost issues".

For instance, according to Martijn's WoS there was a reference to game "Combinatoria" in MicroHobby year 1985 month 10 page 9. The problem is, MicroHobby was a weekly magazine, therefore several issues of this magazine were published in October 1985. Which one of them contained this reference?

I have fixed literally thousands of these reference problems in ZXDB, but I didn't notice MicroHobby still had a few problems left. I will fix them all, thanks for reporting it!
0 x

User avatar
Einar Saukas
Manic Miner
Posts: 911
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Tue Aug 06, 2019 10:59 am

A new ZXDB version is available!

This update includes new titles (thanks @R-Tape!), new hi-res inlays (thanks @pavero!), new magazines, updated integration with RZX Archive (thanks Daren!) and ZXSR (thanks Chris!).
3 x

User avatar
Einar Saukas
Manic Miner
Posts: 911
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Fri Aug 09, 2019 5:35 pm

I'm planning to remove column "is_electronic" from table "magazines" in the next ZXDB update.

This column is supposed to distinguish between paper and electronic magazines. However it's more informative to simply obtain this information directly from the magazine format: PDF for paper magazines, TAP or TZX for tape magazines, MGT or DISK for disk magazines, etc. In particular, I know SpectrumComputing is already doing it.

Moreover, I had identified a few cases where column "is_electronic" conflicted with the magazine format. In all such cases, "is_electronic" was wrong. I could have fixed these values, but there's no reason to keep a column that's redundant anyway.

I'm announcing this change in advance, to give site owners the chance to let me know if this change would affect them.
0 x

User avatar
Einar Saukas
Manic Miner
Posts: 911
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Fri Aug 09, 2019 9:17 pm

I'm also planning to remove columns "link" and "link2" from table "magrefs" in the next ZXDB update.

This information will be moved to a new table, because it's technically a one-to-many relationship.
0 x

User avatar
Einar Saukas
Manic Miner
Posts: 911
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Sat Aug 10, 2019 6:02 am

A new ZXDB version is already available!

This update contains lots of updated information about magazines. I will talk about them in further detail after SC is updated with this new version, because it will be easier to describe these changes when users are able to see them in practice. :)
1 x

User avatar
Einar Saukas
Manic Miner
Posts: 911
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Tue Aug 13, 2019 8:54 pm

Another ZXDB update is available!

This update includes lots of minor changes, such as the notion of "derived" titles. It refers to a new title that is basically an improved version of another title from the same author (for instance see this thread). I will start a new thread later to discuss about it in more detail...
2 x

User avatar
Einar Saukas
Manic Miner
Posts: 911
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Wed Aug 14, 2019 2:55 pm

Einar Saukas wrote:
Tue Aug 13, 2019 8:54 pm
This update includes lots of minor changes, such as the notion of "derived" titles. It refers to a new title that is basically an improved version of another title from the same author (for instance see this thread). I will start a new thread later to discuss about it in more detail...
I have just started this new thread about it.
0 x

User avatar
Einar Saukas
Manic Miner
Posts: 911
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Wed Aug 21, 2019 8:10 pm

A note for site owners running ZXDB:

In the ZXDB update, I'm planning to remove column "hardware_feature" from table "entries". The reason is, this column currently contains website links, so it's more appropriate to store this information in table "webrefs" instead.
0 x

User avatar
Einar Saukas
Manic Miner
Posts: 911
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Thu Aug 22, 2019 1:58 am

A new ZXDB update is available!

This version contains more bugfixes and cover artists credits (thanks @druellan!), more hi-res inlays and typed instructions (thanks @pavero!), and many other improvements.
2 x

User avatar
Einar Saukas
Manic Miner
Posts: 911
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Thu Aug 22, 2019 6:14 pm

I have been so focused on improving ZXDB, that I forgot to take some time off to document and explain the ZXDB roadmap. My apologies!

Our current and future plans for ZXDB are now documented here:

https://docs.google.com/document/d/1o_f ... sp=sharing

I wrote is as a separate online document because I intend to update it over time. In particular, I probably forgot to mention a few important items that I will need to add later. :)

Feedback is welcome!
2 x

Post Reply