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

Post Reply
User avatar
R-Tape
Site Admin
Posts: 2327
Joined: Thu Nov 09, 2017 11:46 am

Re: New Database Model ZXDB

Post by R-Tape » Thu Dec 20, 2018 6:15 pm

Image

YEAAAHH!!! Petercanweinstallitcanweinstallitwhencanweinstallitisitinstalledyet?
1 x

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

Re: New Database Model ZXDB

Post by PeterJ » Thu Dec 20, 2018 7:18 pm

Doing it now @R-Tape

You can explain to Mrs J why I went straight into the study when I arrived home!
0 x

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

Re: New Database Model ZXDB

Post by PeterJ » Thu Dec 20, 2018 7:22 pm

0 x

User avatar
R-Tape
Site Admin
Posts: 2327
Joined: Thu Nov 09, 2017 11:46 am

Re: New Database Model ZXDB

Post by R-Tape » Wed Jan 09, 2019 4:39 pm

Sorry for the delays update fans. We're still getting used to ZX-Ed and fixing a few bugs. We'll start with some small but regular test updates as soon as we can.
2 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Sat Jan 12, 2019 6:09 pm

A new ZXDB update is available!

This is a small partial update, created with the aid of ZX-Ed for the first time. :)
2 x

User avatar
R-Tape
Site Admin
Posts: 2327
Joined: Thu Nov 09, 2017 11:46 am

Re: New Database Model ZXDB

Post by R-Tape » Sat Jan 12, 2019 9:52 pm

Einar Saukas wrote:
Sat Jan 12, 2019 6:09 pm
This is a small partial update, created with the aid of ZX-Ed for the first time. :)
YEAAAHHHH!! Thanks Einar.

Image

Small steps, but we're getting there!
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Wed Jan 16, 2019 5:57 am

A minor ZXDB update has been released.

In this update, 4 database columns related to product prices ("spanish_price", "microdrive_price", "disk_price", "cartridge_price") are being moved from table "entries" to table "releases". For now, these columns still exist in both tables, so any site referencing these columns at table "entries" can have time to make the proper adjusts. But in next update, they will only exist in table "releases".

There were no major content changes this time. Therefore if SC prefers to skip this release and wait for the next one, that's fine!
0 x

User avatar
StooB
Microbot
Posts: 138
Joined: Mon Oct 22, 2018 10:03 am

Re: New Database Model ZXDB

Post by StooB » Wed Jan 16, 2019 10:10 am

Einar Saukas wrote:
Wed Jan 16, 2019 5:57 am
In this update, 4 database columns related to product prices ("spanish_price", "microdrive_price", "disk_price", "cartridge_price") are being moved from table "entries" to table "releases".
That's not going to work for titles like Combat School where there are two Spanish releases but only one Spanish price in the entries table.

Also, wouldn't it make more sense to have a single price per release with an additional field for "release_format" (cassette, disk, microdrive, cartridge)?
There's already a "release_price" and a "budget_price" for each release - which should be mutually exclusive - but leads to things like Gryzor where the "Original" release also has a budget price of £2.99, while the actual budget release has it's own price of £3.99.
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Fri Jan 18, 2019 3:05 am

StooB wrote:
Wed Jan 16, 2019 10:10 am
Einar Saukas wrote:
Wed Jan 16, 2019 5:57 am
In this update, 4 database columns related to product prices ("spanish_price", "microdrive_price", "disk_price", "cartridge_price") are being moved from table "entries" to table "releases".
That's not going to work for titles like Combat School where there are two Spanish releases but only one Spanish price in the entries table.
You are right. I should have given more thought to this. Thanks for pointing this out!

We shouldn't really have a "spanish_price" column anywhere. Instead, I must identify the correct Spanish release on each case that had this specific price, then assign it as the release price.

OK, I'm working on it now...

StooB wrote:
Wed Jan 16, 2019 10:10 am
Also, wouldn't it make more sense to have a single price per release with an additional field for "release_format" (cassette, disk, microdrive, cartridge)?
No, because a single release may have multiple formats. For instance "Knight Orc" was originally released as both cassette and disk.

StooB wrote:
Wed Jan 16, 2019 10:10 am

There's already a "release_price" and a "budget_price" for each release - which should be mutually exclusive - but leads to things like Gryzor where the "Original" release also has a budget price of £2.99, while the actual budget release has it's own price of £3.99.
Perhaps this name is misleading. The "budget price" refers to a release that was originally launched at a certain "release price", then some time later had the price reduced on stores for the same release.

For instance, Gryzor was originally released in 1987 by Ocean for £7.95. A while later, the price of this release was eventually reduced to £2.99. Then 4 years later, Gryzor was re-released under the budget label Hit Squad, for the re-release price of £3.99.
0 x

User avatar
StooB
Microbot
Posts: 138
Joined: Mon Oct 22, 2018 10:03 am

Re: New Database Model ZXDB

Post by StooB » Fri Jan 18, 2019 12:33 pm

Einar Saukas wrote:
Fri Jan 18, 2019 3:05 am

StooB wrote:
Wed Jan 16, 2019 10:10 am
There's already a "release_price" and a "budget_price" for each release - which should be mutually exclusive - but leads to things like Gryzor where the "Original" release also has a budget price of £2.99, while the actual budget release has it's own price of £3.99.
Perhaps this name is misleading. The "budget price" refers to a release that was originally launched at a certain "release price", then some time later had the price reduced on stores for the same release.
For instance, Gryzor was originally released in 1987 by Ocean for £7.95. A while later, the price of this release was eventually reduced to £2.99. Then 4 years later, Gryzor was re-released under the budget label Hit Squad, for the re-release price of £3.99.
Yes, perhaps "clearance price" or "reduced price" might be clearer. However, this doesn't seem to have been transferred consistently from the original WoS data.

eg: Combat School at WoS had a release price of £7.99 and a budget price of £2.99, while the same entry here has a original release price of £7.99, with the £2.99 having moved to the Hit Squad re-release.

Similarly, ACE 2 at WoS has a budget price of £2.99 which has moved on to the Gamebusters re-release in ZXDB.

Also, some prices seems to have been lost in the WoS/ZXDB conversion:
One of Corn Cropper's prices has gone.
The Damned Forest's budget price is missing.
Both prices for Airline have vanished completely!

Einar Saukas wrote:
Fri Jan 18, 2019 3:05 am
StooB wrote:
Wed Jan 16, 2019 10:10 am
Also, wouldn't it make more sense to have a single price per release with an additional field for "release_format" (cassette, disk, microdrive, cartridge)?
No, because a single release may have multiple formats. For instance "Knight Orc" was originally released as both cassette and disk.
Knight Orc is a very straightforward case though. You'll need to think about these problems:
  • None of the Spanish +3 re-releases have disk prices, but you could work out whether there was a disk release by looking in the downloads table and put "Unknown" against the disk price for the Spanish release. This doesn't work for 'denied' titles like Barbarian by Melbourne House - WoS shows that there is a Spanish +3 disk release, with no price, that isn't shown here.
  • Alien Research Centre by Zenobi (this one applies to lots of Zenobi releases) - this was originally released on cassette and +3 disk but there's no disk price. Not only that, there's also a re-release on a +D disk, so do you need a +3 disk price column and a +D disk price column?
  • Back to ACE 2, and again there is an original +3 disk release without a price, but there are also a differently priced 48K and 128K cassette releases, so you'd also need a 48K Cassette price column and a 128K Cassette price column.
  • Worst of all is The Artist II where there is an original 48K cassette release at £14.95, an original 128K cassette release at £17.95, there are original +3 and +D disk releases but only one disk price given which may or may not apply to both!
0 x

Post Reply