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
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:47 pm
No problems, they are loading screens - when I submitted them the opening screen concept was still being fleshed out.
Thanks for the information! I will change them back to "loading screen" for the next ZXDB update.

If you notice anything else wrong, please let me know!
1 x

User avatar
kolbeck
Microbot
Posts: 127
Joined: Mon Nov 13, 2017 9:04 pm

Re: New Database Model ZXDB

Post by kolbeck »

Einar Saukas wrote:
Wed May 27, 2020 7:19 pm
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.
Thanks for the heads-up, I'll figure out with next ZXDB release :-)

ZXInfo + API updated to latest release

/Thomas
0 x
https://zxinfo.dk - another ZXDB frontend
https://api.zxinfo.dk/ - ZXDB API for developers

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 »

kolbeck wrote:
Wed May 27, 2020 11:01 pm
Thanks for the heads-up, I'll figure out with next ZXDB release :-)
If you are using "magrefs.feature_id", then you can already modify your site. The information that was previously stored in this column is already available in table "magreffeats" now. You would just need to use "magrefs r LEFT JOIN magreffeats f ON r.id = f.magref_id".
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:47 pm
No problems, they are loading screens - when I submitted them the opening screen concept was still being fleshed out.
We also have "opening screens" for Bowin and the Count Dracula, Batz 'n Balls, Boing!, and Booty.

Are they really opening screens, or loading screens?
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 »

Stefan wrote:
Wed May 27, 2020 10:47 pm
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.
Thanks. It's going to be important to load disk games at real speed to sometimes tell if a screen is loading or intro.
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:
Thu May 28, 2020 1:23 am
Stefan wrote:
Wed May 27, 2020 10:47 pm
No problems, they are loading screens - when I submitted them the opening screen concept was still being fleshed out.
We also have "opening screens" for Bowin and the Count Dracula, Batz 'n Balls, Boing!, and Booty.

Are they really opening screens, or loading screens?
  • Bowin and the Count Dracula: opening screen (I think - screens have incorrect file extension)
  • Batz 'n Balls: loading screen
  • Boing: opening screen (screens have incorrect file extension)
  • Booty: don't know, never seen it (screens have incorrect file extension)
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:
Thu May 28, 2020 7:57 am
  • Bowin and the Count Dracula: opening screen (I think - screens have incorrect file extension)
  • Batz 'n Balls: loading screen
  • Boing: opening screen (screens have incorrect file extension)
  • Booty: don't know, never seen it (screens have incorrect file extension)
Thanks!

I had already fixed the incorrect file extensions, but we will have to wait for the next ZXDB update to get these fixes. Sorry!
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:
Thu May 28, 2020 8:05 am
I had already fixed the incorrect file extensions, but we will have to wait for the next ZXDB update to get these fixes. Sorry!
No problem. Are the extensions going to be the old ss4 or the new ssx?
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 »

When the changes to SimCoupe were announced last week, @moroz1999 kindly said he would work on an .ssx filter. In future I will use SimCoupe for screens, but I will need to do testing first, then change the code behind the scenes, so you won't see anymore new screens for a while.

Those .ss4 screens that you and I produced will need to be retaken in .ssx format when the filter is available and has been tested.
1 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:
Thu May 28, 2020 8:34 am
Those .ss4 screens that you and I produced will need to be retaken in .ssx format when the filter is available and has been tested.
Sorry, I didn't realize @Stefan produced some of these new screens so I failed to mention him in the last ZXDB update.

Thank you very much @Stefan!
3 x

Post Reply