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.
Post Reply
User avatar
Einar Saukas
Manic Miner
Posts: 429
Joined: Wed Nov 15, 2017 2:48 pm

New Database Model ZXDB

Post by Einar Saukas » Mon Apr 16, 2018 2:39 am

[NOTE: I started a new ZXDB thread because some links have changed!]


ZXDB is an "open" database model that catalogues Spectrum (and other Sinclair-related) material including software, hardware, books, magazines, etc.

It contains the entire information content from both Martijn's original WoS archive and Grimwood's SPOT/SPEX, plus thousands of new titles, plus dozens of thousands of corrections, fixes, additional details and improvements. It's also closely integrated with ZXSR, RZX Archive, ZX81 Stuff, CASA, MobyGames, Speccy Screenshot Maps, and ZX-Art. Both Spectrum Computing and ZXInfo currently use ZXDB directly, also ZX-Art imports ZXDB content periodically.

From now on, all ZXDB updates will be announced in this thread. Stay tuned!
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Mon Apr 16, 2018 3:25 am

ZXDB has an official site now! The latest version will be always available from here:

https://github.com/zxdb/ZXDB

To download the latest version, click on the green button called "Clone or download", then choose "Download ZIP". Notice that ZXDB documentation can be read directly from the homepage.

From now on, everything will be available from the official site, except for the "incremental" files (useful basically for auditing only) that will be kept separated here (to avoid making the official site look too confusing).

BTW this new update contains new titles (thanks R-Tape!), about 200 new screenshots (thanks Thomas!), about 200 new links to The Spectrum Show (thanks Paul!), and a few other details that R-Tape will properly describe later. Enjoy! :)
2 x

moroz1999
Berk
Posts: 45
Joined: Fri Mar 30, 2018 8:22 pm

Re: New Database Model ZXDB

Post by moroz1999 » Mon Apr 16, 2018 12:58 pm

Great to hear, thanks!
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Mon Apr 16, 2018 5:59 pm

Thank you!

A few technical notes, for sites directly using ZXDB content:

* The following ENTRY_IDs were removed from ZXDB, because they were identified as duplicates of already existing entries: 28628, 28663, 28676, 28733, 28734, 28749, 28789.

* The following new group types were created:

--> "Multiplayer Mode" (groups Cooperative, Teamplay, and Versus). It contains the same information previously stored in field ENTRIES.MULTIPLAYTYPE_ID and table MULTIPLAYTYPES.

-> "Turn Mode" (groups Alternating, Simultaneous, Turn based). It contains the same information previously stored in field ENTRIES.TURNTYPE_ID and table TURNTYPES.

--> "Control Option" (groups Cursor, Kempston, etc). It contains the same information previously stored in tables CONTROLS and CONTROLTYPES.

Therefore, exactly the same information previously stored in specific tables, is now stored using a more generic structure, as members of groups. In current ZXDB release, this information is duplicated but, in the next update, the old fields and tables I mentioned above will be removed. Thus please update your system accordingly! I believe this change will benefit everybody:

--> In SC (and perhaps ZXInfo), storing everything as groups mean that users will be able to click on "Cooperative", for instance, and see all games that support playing in cooperative mode, without requiring extra development in the website.

--> In ZX-Art, this new structure should simplify importing, since a group in ZXDB corresponds directly to a tag in ZX-Art.

--> For everybody else, this change simplifies the database model, thus making it easier for others to understand and use it.
0 x

moroz1999
Berk
Posts: 45
Joined: Fri Mar 30, 2018 8:22 pm

Re: New Database Model ZXDB

Post by moroz1999 » Tue Apr 17, 2018 9:51 am

Einar Saukas wrote:
Mon Apr 16, 2018 5:59 pm
--> In ZX-Art, this new structure should simplify importing, since a group in ZXDB corresponds directly to a tag in ZX-Art.
Thanks! In fact, it makes importing a bit more complicated really :) I'm going to ignore some of tags during import and store them in some specified properties instead. This would allow me to build some filters easier later.
But anyway, thanks for letting know, I will adjust the import procedure appropriately. Is there any separated list of all groups (tags) related to supported hardware?
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Sat Apr 21, 2018 8:42 pm

A new ZXDB update is available here:

https://github.com/zxdb/ZXDB

As usual, every incremental SQL update is available here, for those interested in auditing my work :)
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Thu May 03, 2018 1:07 pm

A new ZXDB update is available!

As usual, it can be downloaded from here:

https://github.com/zxdb/ZXDB

As usual, the "incremental" files (for auditing purposes) are kept separated here.
1 x

Post Reply