Page 17 of 22

Re: New Database Model ZXDB

Posted: Fri Dec 17, 2021 8:34 pm
by Einar Saukas
A new ZXDB update is available!

Re: New Database Model ZXDB

Posted: Tue Jan 25, 2022 12:05 am
by Einar Saukas
A new ZXDB release is now available... finally!

My apologies for the delay, I just came back from vacation today.

If you notice anything missing from this release, don't worry. I was in a hurry to release all the accumulated content, so there's a good chance I skipped a few submissions this time. However nothing got lost! I will review everything and, if there's anything I missed, it will be included in the next update ASAP.

Re: New Database Model ZXDB

Posted: Tue Jan 25, 2022 9:09 am
by R-Tape
This is update #130 (plus the as yet uncounted amount before SC) :–)

Re: New Database Model ZXDB

Posted: Mon Feb 28, 2022 11:37 am
by Einar Saukas
A very large ZXDB update is now available!

This was the largest update in about a year, with over 5000 lines of database script. There was so much accumulated content that it took me several days to prepare this release... Let's hope I have learned my lesson to release updates more frequently from now on :)

Re: New Database Model ZXDB

Posted: Mon Feb 28, 2022 11:48 am
by PeterJ
Thanks [mention]Einar Saukas[/mention],

I'm going to do this over the weekend.

Peter

Re: New Database Model ZXDB

Posted: Mon Feb 28, 2022 5:13 pm
by R-Tape
PeterJ wrote: Mon Feb 28, 2022 11:48 am Thanks @Einar Saukas,

I'm going to do this over the weekend.

Peter
And I've checked the SQL, and I see that [mention]flatduckrecords[/mention] has been removed as author of Nodes of yesod. You have one more week to revel in the reflected glory of Odin Rob :–)

Re: New Database Model ZXDB

Posted: Mon Feb 28, 2022 5:54 pm
by flatduckrecords
R-Tape wrote: Mon Feb 28, 2022 5:13 pm And I've checked the SQL, and I see that @flatduckrecords has been removed as author of Nodes of yesod. You have one more week to revel in the reflected glory of Odin Rob :–)
Haha! It was fun while it lasted. In the meantime I've been enjoying (actual Nodes of Yesod author) Steve Wetherill's recent blogs. News of the Nodes port for Next, and stories (and many technical* details) from back in the day as well. :ugeek:

*genning up in case anyone asks me any questions about my involvement, haha ;)

Re: New Database Model ZXDB

Posted: Mon Feb 28, 2022 6:43 pm
by Einar Saukas
An ID got mixed up. We identified the cause of this problem and improved our process to prevent something similar from happening again. Sorry about that!

Re: New Database Model ZXDB

Posted: Thu Mar 31, 2022 6:33 am
by arjun
Hi @Einar Saukas ,

While integrating the ZXInfo API with Zero, I noticed that while I can get the PNG/JPG/GIF version of images for Inlays and Running screens (in-game screen), the Loading Screen seems to be available only in the non-standard SCR format. Is the loading screen not available in PNG or GIF version in zxdb, or is this a limitation of the API? If not, can we not have them available as a standard image format as well so that the loading screens can be downloaded and displayed without requiring a SCR to PNG/GIF conversion on the client end.

Re: New Database Model ZXDB

Posted: Thu Mar 31, 2022 8:29 am
by 4thRock
I'll let Einar answer, but let me add that some running screens are also SCRs. In some cases, other spectrum formats are used in order to preserve multicolor information.
This is done from a preservation point of view, as we are interested in storing all of the original data to the bit level.

Re: New Database Model ZXDB

Posted: Thu Mar 31, 2022 11:51 am
by arjun
4thRock wrote: Thu Mar 31, 2022 8:29 am I'll let Einar answer, but let me add that some running screens are also SCRs. In some cases, other spectrum formats are used in order to preserve multicolor information.
This is done from a preservation point of view, as we are interested in storing all of the original data to the bit level.
That's fine. Use SCR to store all images for accuracy, but could we also store PNG/GIF versions or is that not practical?

Re: New Database Model ZXDB

Posted: Thu Mar 31, 2022 1:27 pm
by Einar Saukas
arjun wrote: Thu Mar 31, 2022 6:33 am While integrating the ZXInfo API with Zero, I noticed that while I can get the PNG/JPG/GIF version of images for Inlays and Running screens (in-game screen), the Loading Screen seems to be available only in the non-standard SCR format. Is the loading screen not available in PNG or GIF version in zxdb, or is this a limitation of the API? If not, can we not have them available as a standard image format as well so that the loading screens can be downloaded and displayed without requiring a SCR to PNG/GIF conversion on the client end.
Images in SCR format are automatically converted to PNG by SpectrumComputing. You can download each of them using this link:

Code: Select all

https://spectrumcomputing.co.uk/SCRtoImage.php?SCR=<FILE_LINK>&border=<SCR_BORDER>
You can get the exact values for FILE_LINK and SCR_BORDER from ZXDB. For instance:

https://spectrumcomputing.co.uk/SCRtoIm ... r&border=0

Re: New Database Model ZXDB

Posted: Fri Apr 01, 2022 5:17 am
by arjun
Einar Saukas wrote: Thu Mar 31, 2022 1:27 pm Images in SCR format are automatically converted to PNG by SpectrumComputing. You can download each of them using this link:

Code: Select all

https://spectrumcomputing.co.uk/SCRtoImage.php?SCR=<FILE_LINK>&border=<SCR_BORDER>
You can get the exact values for FILE_LINK and SCR_BORDER from ZXDB. For instance:

https://spectrumcomputing.co.uk/SCRtoIm ... r&border=0
Thanks Einar! That's exactly what the doctor ordered. :)

Re: New Database Model ZXDB

Posted: Thu Apr 07, 2022 9:22 pm
by Einar Saukas
A new ZXDB update is finally available!!!

My apologies for the delay, real life is keeping me very busy...

Re: New Database Model ZXDB

Posted: Thu Apr 07, 2022 11:02 pm
by R-Tape
Einar Saukas wrote: Thu Apr 07, 2022 9:22 pm My apologies for the delay, real life is keeping me very busy...
Don't worry about it Einar - the world is proper topsy turvy these days. It's nice to be able to celebrate a bit of stability with update #131. :)

Re: New Database Model ZXDB

Posted: Fri Apr 22, 2022 10:15 pm
by Einar Saukas
Another ZXDB update is available now!

Re: New Database Model ZXDB

Posted: Mon May 02, 2022 6:18 pm
by Einar Saukas
A new ZXDB version is now available!

Re: New Database Model ZXDB

Posted: Mon May 02, 2022 6:27 pm
by PeterJ
Thanks @Einar Saukas,

I will update the site on Thursday evening.

Re: New Database Model ZXDB

Posted: Thu May 12, 2022 3:52 pm
by Einar Saukas
Another ZXDB update is available now!

Re: New Database Model ZXDB

Posted: Thu May 12, 2022 4:21 pm
by PeterJ
Thanks @Einar Saukas,

I will update on Friday afternoon.

Re: New Database Model ZXDB

Posted: Fri Jun 03, 2022 12:32 am
by Einar Saukas
A new ZXDB update is now available!

Re: New Database Model ZXDB

Posted: Sat Jun 11, 2022 3:01 am
by Einar Saukas
Another ZXDB update is available!

Re: New Database Model ZXDB

Posted: Tue Jun 14, 2022 10:33 pm
by Neil Parsons
I have a doubt. If I want to add for a particular program, already available at SC or just at the moment of creating its entry, the tag for Inspiration/Licence in which it's based, which text and options can I use for?

For example, Topin game from MicroHobby magazine is inspired in "Crush Roller" arcade by Alpha Denshi in 1981. Is that easy to put this info? I've tried to do a search through this forum to find anything related with this issue but I'm a bit confused.

Re: New Database Model ZXDB

Posted: Wed Jun 15, 2022 1:43 am
by Einar Saukas
When adding a new entry with the online form, click on "show advanced features". You will see a section called "License/Inspiration".

Or you can use "Small changes for existing entries" in the online form, that also contains section "License/Inspiration".

Re: New Database Model ZXDB

Posted: Fri Jun 17, 2022 6:44 pm
by Neil Parsons
Einar Saukas wrote: Wed Jun 15, 2022 1:43 am When adding a new entry with the online form, click on "show advanced features". You will see a section called "License/Inspiration".

Or you can use "Small changes for existing entries" in the online form, that also contains section "License/Inspiration".
Thanks Einar!