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

Re: New Database Model ZXDB

Post by Einar Saukas » Sat Jan 19, 2019 1:04 pm

Thanks for this list of (possible) issues! It's going to take me some time to check each one, I will report later my findings here.
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Sat Jan 19, 2019 1:19 pm

In the meantime, I have just released a new ZXDB update!

Technically columns disk_price, microdrive_price, and cartridge_price were moved to table "releases". It makes more sense to store these values per release, instead of just once per title. Unfortunately there's no way to determine what's the specific release for previously existing information imported from Martijn's WoS that didn't make this distinction, so the only options here are either storing the same information in all releases or in original release only, then manually adjusting it later case-by-case whenever possible. At least this way, every price we store from now on will be more accurate.

Column spanish_price wasn't moved. This is typically the release price of the Spanish release of each game, so I'm now working to identify the proper release for each case and assign this value properly. Approximately a thousand games had a spanish price, I have just reassigned about half of them. I will try to sort the rest in the next update.

I will let R-Tape describe what else he included in this update. :)
1 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Sun Jan 20, 2019 3:14 am

There's yet another ZXDB update now, containing credits for cover artists.
1 x

User avatar
jpablo
Berk
Posts: 7
Joined: Sun Jan 13, 2019 12:05 am
Location: Zaragoza, Spain
Contact:

Re: New Database Model ZXDB

Post by jpablo » Tue Jan 22, 2019 8:24 am

Einar Saukas wrote:
Sat Jan 19, 2019 1:19 pm
Column spanish_price wasn't moved. This is typically the release price of the Spanish release of each game, so I'm now working to identify the proper release for each case and assign this value properly. Approximately a thousand games had a spanish price, I have just reassigned about half of them. I will try to sort the rest in the next update.
I just read this. Please don't waste time on this - this information came in from the SPA2 database, and the prices are mapped on a per-release basis there.

I can send you a copy of the current (provisional) state of the SPA2 datase, so that you can work from this. Please pass me an e-mail address so that I can send a database dump to you.

Cheers :)
0 x

User avatar
StooB
Berk
Posts: 38
Joined: Mon Oct 22, 2018 10:03 am

Re: New Database Model ZXDB

Post by StooB » Tue Jan 22, 2019 10:15 am

Einar Saukas wrote:
Sat Jan 19, 2019 1:04 pm
Thanks for this list of (possible) issues! It's going to take me some time to check each one, I will report later my findings here.
and while you're looking at the releases table, I've found another problem! Everything has a release, whether it happened or not.

eg: Duet was only released on the Hit Pak compilation, but apparently it was released in 1987 at £7.95
(where this price comes from is a mystery as it's not on the original WoS entry or the price of the compilation either)

Unfortunately, it's not just titles that were only released on compilations...

The Eye of the Moon was released by Beyond.

Mire Mare was released by Ultimate!

even Bandersnatch! :o
0 x

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

Re: New Database Model ZXDB

Post by PeterJ » Tue Jan 22, 2019 1:16 pm

Hi @StooB

The prices I'm taking are from the first release, so I believe the price showing for Duet us the price of the compilation it appeared on.

Peter
0 x

User avatar
StooB
Berk
Posts: 38
Joined: Mon Oct 22, 2018 10:03 am

Re: New Database Model ZXDB

Post by StooB » Tue Jan 22, 2019 1:37 pm

PeterJ wrote:
Tue Jan 22, 2019 1:16 pm
Hi @StooB

The prices I'm taking are from the first release, so I believe the price showing for Duet us the price of the compilation it appeared on.

Peter
The compilation price is £9.95 though, not £7.95!

6 Pak compilation:
https://spectrumcomputing.co.uk/index.p ... 6&id=11197
0 x

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

Re: New Database Model ZXDB

Post by PeterJ » Tue Jan 22, 2019 1:48 pm

Good point! I need my eyes tested...
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Wed Jan 23, 2019 4:25 am

StooB wrote:
Tue Jan 22, 2019 10:15 am
Einar Saukas wrote:
Sat Jan 19, 2019 1:04 pm
Thanks for this list of (possible) issues! It's going to take me some time to check each one, I will report later my findings here.
and while you're looking at the releases table, I've found another problem! Everything has a release, whether it happened or not.
The problem is not the information itself. We shouldn't omit the information that Beyond Software was the publisher behind "Eye of the Moon" for instance, although this game was never published therefore it didn't have a publisher!

The problem is how to present this information, to avoid misunderstandings. SpectrumComputing has just updated this section, please see if it works for you now.

StooB wrote:
Tue Jan 22, 2019 10:15 am
eg: Duet was only released on the Hit Pak compilation, but apparently it was released in 1987 at £7.95
(where this price comes from is a mystery as it's not on the original WoS entry or the price of the compilation either)
This price came from SPOT/SPEX.

And SPOT/SPEX took this price from Your Sinclair #13. Look at the bottom of this page:

https://spectrumcomputing.co.uk/mag.php ... 34&page=10

It seems the game was announced as a standalone release for £7.95 but never released this way. Therefore this price should be removed. Right?

StooB wrote:
Tue Jan 22, 2019 10:15 am
Unfortunately, it's not just titles that were only released on compilations...

The Eye of the Moon was released by Beyond.

Mire Mare was released by Ultimate!

even Bandersnatch! :o
Do they look correct now?
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Wed Jan 23, 2019 4:31 am

jpablo wrote:
Tue Jan 22, 2019 8:24 am
Einar Saukas wrote:
Sat Jan 19, 2019 1:19 pm
Column spanish_price wasn't moved. This is typically the release price of the Spanish release of each game, so I'm now working to identify the proper release for each case and assign this value properly. Approximately a thousand games had a spanish price, I have just reassigned about half of them. I will try to sort the rest in the next update.
I just read this. Please don't waste time on this - this information came in from the SPA2 database, and the prices are mapped on a per-release basis there.

I can send you a copy of the current (provisional) state of the SPA2 datase, so that you can work from this. Please pass me an e-mail address so that I can send a database dump to you.

Cheers :)
Thank you!!!

I just sent you a PM :)
0 x

Post Reply