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

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

Database model ZXDB

Post by Einar Saukas » Thu Nov 23, 2017 2:56 am

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.

All ZXDB updates will be announced in this thread. Stay tuned!
8 x
Top
User avatar
Einar Saukas
Manic Miner
Posts: 949
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas » Thu Nov 23, 2017 3:29 am

A new version of ZXDB is available here!

This update contains a few recent releases and previously missing titles.

It also contains several links to CASA that were missing. Many thanks to Thomas for organizing this information!

Technically, this update also contains an improvement on table "labels". There's now a new column "labels.labeltype_id", intended to replace both columns "labels.is_company" and "labels.companytype_id". For now, I'm keeping all these columns in ZXDB, thus websites can have enough time to adapt accordingly. In a later release, both these columns will be eliminated. As usual, please contact me if you need any support on this!
3 x
Top
Lorfarius
Berk
Posts: 10
Joined: Mon Nov 13, 2017 10:16 am

Re: Database model ZXDB

Post by Lorfarius » Thu Nov 23, 2017 7:45 am

Just a thanks to everyone involved with this. Really is an amazing bit of work.
0 x
UK's number one Amiga podcast:

https://www.AMIGArama.com
Top
User avatar
Einar Saukas
Manic Miner
Posts: 949
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas » Thu Nov 23, 2017 9:16 am

Thank you! :)
0 x
Top
hikoki
Manic Miner
Posts: 400
Joined: Thu Nov 16, 2017 10:54 am

Re: Database model ZXDB

Post by hikoki » Thu Nov 23, 2017 2:48 pm

Missing screenshots (some are to replace wrong ones on zxdb) :
https://www.dropbox.com/s/bhdm550my50u4 ... 3.zip?dl=1

Unlisted games on zxdb : https://awesome-table.com/-KTJLy2xX7_E1 ... N=unlisted
2 x
Top
User avatar
Einar Saukas
Manic Miner
Posts: 949
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas » Thu Nov 23, 2017 2:57 pm

Thank you!!!

I will add everything in the next archive update!
1 x
Top
User avatar
Alessandro
Manic Miner
Posts: 508
Joined: Wed Nov 15, 2017 11:10 am
Location: Messina, Italy
Contact:
Contact Alessandro

Re: Database model ZXDB

Post by Alessandro » Thu Nov 23, 2017 4:07 pm

A better in-game screen for Sophia.

Also please update the description by adding the Russian and Swedish language versions.
0 x
Top
User avatar
Einar Saukas
Manic Miner
Posts: 949
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas » Thu Nov 23, 2017 4:13 pm

Thank you!!!

I will make these changes in the next update!
0 x
Top
hikoki
Manic Miner
Posts: 400
Joined: Thu Nov 16, 2017 10:54 am

Re: Database model ZXDB

Post by hikoki » Fri Dec 01, 2017 1:32 pm

Strange Kitchen is a game from 2016 NOT from 2015
See viewtopic.php?f=3&t=155&p=1670#p1670
0 x
Top
User avatar
Einar Saukas
Manic Miner
Posts: 949
Joined: Wed Nov 15, 2017 2:48 pm

Re: Database model ZXDB

Post by Einar Saukas » Fri Dec 01, 2017 3:48 pm

Thank you!!!

This will be fixed in the next archive update!
0 x
Top
Locked

Return to “ZXDB Discussion”