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: 900
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Tue Jan 29, 2019 9:47 pm

druellan wrote:
Tue Jan 29, 2019 9:10 pm
Einar Saukas wrote:
Tue Jan 29, 2019 12:34 pm
ZXDB adopts the convention (inherited from Martijn's WoS) that only actual releases are stored, for released games. Only if a game was never released, then it stores the publisher that was behind it, although it's not really a "publisher" since it wasn't really "published".
Mixing information about real and imaginary releases for the same game would be confusing IMHO.
I'm trying to understand this so I can improve the contributions to the ZXDB, tell me if I'm wrong but I understand that:

Not a publisher:
A game developed in the '80/'90 just for fun, they didn't have any intention to publish the game, but they created an imaginary software house.
Same as above, but they have several titles developed.

A publisher:
A game developed in the '80/'90, they HAD intention to publish the game, but that never happened.
A modern developer that sells physical copies of their games.
A modern developer that distribute digital copies of their games on their own page.
A modern developer that distribute digital copies of their games but does not have any proper Internet webpage or identity.
Martijn's criteria (that we still follow at ZXDB) was much simpler:

A publisher: whoever is named responsible for releasing the game. It could be a real company, or a fantasy name chosen by someone, or the main developer(s). This information is based on whatever evidence can be obtained from inlay, cover, poster, website, or simply mentioned by the author(s). Whatever was declared by the owner of the game is a much more reliable source of information than any guesswork about the developer's intentions...
2 x

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

Re: New Database Model ZXDB

Post by druellan » Wed Jan 30, 2019 11:48 am

Well, that fit exactly the example I posted above, so, yeah, I think I get it :D
0 x
Un buen día me puse a probar juegos de ZX Spectrum a ciegas en Youtube, terminó siendo:
📺 Retroarqueología en Youtube

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

Re: New Database Model ZXDB

Post by Einar Saukas » Wed Jan 30, 2019 10:09 pm

Yet another ZXDB release is available!

This time it's just a minor update, modifying the licensing structure to support multiple inspirations or tie-ins per title.
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Sun Feb 03, 2019 8:15 pm

Yet another ZXDB update was released!

Technically all game licenses are now stored in a new table called "relatedlicenses". The old columns "entries.license_id" and "entries.was_inspired" were kept for backward compatibility, but they will be removed in the next update. Therefore if you are running a website based on ZXDB, please modify it accordingly (just let me know if you require any assistance).
0 x

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

Re: New Database Model ZXDB

Post by PeterJ » Sun Feb 03, 2019 10:28 pm

Thanks @Einar Saukas

We will get SC updated on Monday evening.
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Tue Feb 12, 2019 3:41 am

Another ZXDB update is available!

This update includes lots of RZX video links (thanks Daren!), lots of hi-res inlays (thanks Pavel!), lots of Spanish name corrections (thanks Juan!), lots of new interview links and several bug fixes.

Technically, old columns "entries.license_id" and "entries.was_inspired" were removed, as mentioned in the last update. Use the new table "relatedlicenses" instead. Also temporary tables "sscgc_authors" and "spex_magazines" were removed, since their content was finally integrated into other tables, as part of ZXDB continuous cleaning process.
0 x

User avatar
Juan F. Ramirez
Dynamite Dan
Posts: 1849
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: New Database Model ZXDB

Post by Juan F. Ramirez » Tue Feb 12, 2019 6:41 am

Einar Saukas wrote:
Tue Feb 12, 2019 3:41 am
Another ZXDB update is available!

[...] lots of hi-res inlays (thanks Pavel!), [...]
First of all, again, thanks for the good work!

Second, I hope @PeterJ includes a list of these new inlays provided by @pavero in the updates section, if possible. Thanks a lot!
0 x

pavero
Microbot
Posts: 194
Joined: Sat Dec 09, 2017 11:49 pm
Location: Czech Republic
Contact:

Re: New Database Model ZXDB

Post by pavero » Tue Feb 12, 2019 6:55 am

Juan F. Ramirez wrote:
Tue Feb 12, 2019 6:41 am

First of all, again, thanks for the good work!

Second, I hope @PeterJ includes a list of these new inlays provided by @pavero in the updates section, if possible. Thanks a lot!
I will do it myself when ZXDB will be updated at SC. ;-)
1 x

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

Re: New Database Model ZXDB

Post by PeterJ » Tue Feb 12, 2019 8:30 am

I will update the site on Friday. Apologies for the delay on this occasion.
1 x

Ralf
Dynamite Dan
Posts: 1222
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: New Database Model ZXDB

Post by Ralf » Tue Feb 12, 2019 12:13 pm

lots of hi-res inlays (thanks Pavel!)
By the way, are there any up to date rules/guidelines what is the preferred size for hi-res inlays? Or inlays in general?
0 x

Post Reply