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
PeterJ
Site Admin
Posts: 2301
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: New Database Model ZXDB

Post by PeterJ »

Einar Saukas wrote:
Fri May 15, 2020 7:43 pm
A new ZXDB update is available!

As usual, many thanks to @R-Tape, @pavero, @druellan and @kolbeck!
Thanks everyone. Update applied.
0 x

User avatar
Einar Saukas
Dynamite Dan
Posts: 1193
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

PeterJ wrote:
Fri May 15, 2020 8:08 pm
Thanks everyone. Update applied.
That was fast! Thank you!


PS: @R-Tape stay safe!
3 x

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

Re: New Database Model ZXDB

Post by PeterJ »

Einar Saukas wrote:
Fri May 15, 2020 8:13 pm
That was fast! Thank you!
Its down to having a 10 second trip home from work (study to kitchen), rather than 2 hours each way!
0 x

User avatar
Einar Saukas
Dynamite Dan
Posts: 1193
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB update is now available!

This time we didn't have much time to add recently released titles, but there are new screens (some of them for the SAM Coupé and Next) and tons of additional information (mainly author credits).

Special thanks to @PeterJ, @druellan, @pavero, and @kolbeck!
2 x

User avatar
Einar Saukas
Dynamite Dan
Posts: 1193
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A technical note for anyone running websites and apps based on ZXDB:

Column "magrefs.feature_id" is now obsolete and it will be removed in the next ZXDB update. There's already a separate table called "magreffeats" to store this information.

I doubt anyone is using this column, but I always provide notice in advance for all upcoming ZXDB changes, so everyone has enough time to update their systems accordingly!
0 x

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

Re: New Database Model ZXDB

Post by PeterJ »

Thanks @Einar Saukas. Database being updated now. The main site will not work whilst I do this.
0 x

User avatar
Stefan
Microbot
Posts: 145
Joined: Mon Nov 13, 2017 9:51 pm
Location: Belgium
Contact:

Re: New Database Model ZXDB

Post by Stefan »

Einar Saukas wrote:
Wed May 27, 2020 6:57 pm
Another ZXDB update is now available!

This time we didn't have much time to add recently released titles, but there are new screens (some of them for the SAM Coupé and Next) and tons of additional information (mainly author credits).

Special thanks to @PeterJ, @druellan, @pavero, and @kolbeck!
Sophistry, SAM MOD player and EFTPOTRM loading screens have all incorrectly been classified as 'opening screen' - what's going on?
0 x

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

Re: New Database Model ZXDB

Post by PeterJ »

Hi @Stefan,

The team were having a discussion about the traditional loading screen and screens that appear as soon as the game has finished loading. This came to the forefront when I started taking screens for Next games.

Do Sam Coupe titles have the same concept as Spectrum games in terms of loading screens?

Note that in terms of ZXDB a game can have either loading screens or intro screens and not both. This is because our game detail layout allows for two screens to be displayed.

I assumed they were intro screens. If not it's my error and I apologise and we can fix in the next update.
0 x

User avatar
Einar Saukas
Dynamite Dan
Posts: 1193
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Stefan wrote:
Wed May 27, 2020 10:00 pm
Sophistry, SAM MOD player and EFTPOTRM loading screens have all incorrectly been classified as 'opening screen' - what's going on?
"Loading screen" is the image that's display on screen while a program is loading. It's typical of Spectrum games loaded from tape.

"Opening screen" is the image that appears on screen immediately after a program is loaded. It's common for program loaded from disk, or ZX81 titles that cannot display a loading screen while loading from tape.

We have decided to add "opening screens" to our database based on a recent discussion here. If we have classified these screens incorrectly, or you have a different suggestion, please let us know!
0 x

User avatar
Stefan
Microbot
Posts: 145
Joined: Mon Nov 13, 2017 9:51 pm
Location: Belgium
Contact:

Re: New Database Model ZXDB

Post by Stefan »

PeterJ wrote:
Wed May 27, 2020 10:21 pm
Do Sam Coupe titles have the same concept as Spectrum games in terms of loading screens?
Yes, even when using a disk drive, the larger amount of data that needs to be loaded can still take enough time to want to stare at something nice.
PeterJ wrote:
Wed May 27, 2020 10:21 pm
I assumed they were intro screens. If not it's my error and I apologise and we can fix in the next update.
No problems, they are loading screens - when I submitted them the opening screen concept was still being fleshed out.
0 x

Post Reply