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

jetsetdanny
Berk
Posts: 18
Joined: Thu May 02, 2019 9:22 pm

Re: New Database Model ZXDB

Post by jetsetdanny » Sun Jul 14, 2019 5:18 am

Thanks a lot, Einar! ZXDB's integration with JSW Central is greatly appreciated! :)
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Fri Jul 19, 2019 1:48 pm

jetsetdanny wrote:
Sun Jul 14, 2019 5:18 am
Thanks a lot, Einar! ZXDB's integration with JSW Central is greatly appreciated! :)
You are welcome!
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Fri Jul 19, 2019 1:52 pm

Yet another ZXDB version is now available!

This update includes new titles (thanks to @R-Tape!), new Danish magazines "SOFT" and "SOFT Today" (thanks to @kolbeck!), and fixed magazine references to New Computer Express (thanks to myself! :) )
2 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Thu Jul 25, 2019 11:56 am

And another ZXDB version is available!

This update includes more titles (thanks @R-Tape!), more hires inlays (thanks @pavero!), and more magazine updates (I will describe these later)


IMPORTANT: From now on, the auxiliary tables to help database searches (prefixed with "search_by_") are distributed separately. If you have a website that uses these tables, don't forget to always execute ZXDB_help_search.sql after running the main ZXDB script.
3 x

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

Re: New Database Model ZXDB

Post by R-Tape » Thu Jul 25, 2019 5:43 pm

Einar Saukas wrote:
Thu Jul 25, 2019 11:56 am
And another ZXDB version is available!
Excellent! We should start counting these, there are 35 updates so far in this thread (I'll look at the other thread later).

EDIT - The other thread has 19 updates, so plus the 35 so far takes the total (from this forum) to erm...54!

There were plenty announced at WoS to include if anyone wanted to count them too.
1 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Thu Jul 25, 2019 6:43 pm

I know ZXDB had 42 content updates in the last 15 months, because I have been assigning a version number to each release since it moved to Github.
1 x

User avatar
druellan
Manic Miner
Posts: 395
Joined: Tue Apr 03, 2018 6:19 pm
Location: Argentina
Contact:

Re: New Database Model ZXDB

Post by druellan » Fri Jul 26, 2019 12:45 pm

Einar Saukas wrote:
Thu Jul 25, 2019 6:43 pm
I know ZXDB had 42 content updates in the last 15 months, because I have been assigning a version number to each release since it moved to Github.
BTW, any reason you are not using the "release" feature on Github, Einar? Since Github has an API to access those, can open the door to automatic or one-click updates on sites using the ZXDB.
0 x
Un buen día me puse a probar juegos de ZX Spectrum a ciegas en Youtube, terminó siendo:
📺 Retroarqueología en Youtube

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

Re: New Database Model ZXDB

Post by Einar Saukas » Fri Jul 26, 2019 3:05 pm

druellan wrote:
Fri Jul 26, 2019 12:45 pm
Einar Saukas wrote:
Thu Jul 25, 2019 6:43 pm
I know ZXDB had 42 content updates in the last 15 months, because I have been assigning a version number to each release since it moved to Github.
BTW, any reason you are not using the "release" feature on Github, Einar? Since Github has an API to access those, can open the door to automatic or one-click updates on sites using the ZXDB.
The reason is, this "release" feature on Github is intended for software releases. The idea is that Github repository stores source code files, and the release section stores distribution packages. I'm using it in ZX-Ed, for instance.

However it's not much adequate for ZXDB, where a distinction between source code and release doesn't make sense. Every update to ZXDB is already a new release on itself. Using the "release" feature for every update, containing exactly the same files, would be simply duplicating information without any practical benefit.

However, if anybody is planning to use Github API for automatic ZXDB updates, please contact me so we can work out the best solution for you.
1 x

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

Re: New Database Model ZXDB

Post by Einar Saukas » Fri Jul 26, 2019 5:32 pm

There are now 31 magazines in ZXDB indexed as PDF from Archive.org:

48K
ACE (Advanced Computer Entertainment)
Big K
Computer Input
Crash
El Ordenador Personal
Input
Jogos 80
Magazine ZX
Micro Mart
MicroHobby
MicroHobby-BR
Mundo Spectrum
New Computer Express
Personal Computer News
Planeta Sinclair Almanaque
Retro Maniac
RetroMagazine
Sinclair User
SOFT
SOFT Today
SoftSpectrum
Spectrum Today-EN
The Spectrum Show
Timex Sinclair User
Todospectrum
Your Sinclair
ZX
ZX Spectrum Gamer
ZXShed
ZXShed Reloaded

It means you can now view these magazine issues online from Archive.org, or download it as PDF.

Now it should also open the right page, when you click on a magazine reference to some specific page number (as discussed here). If anything doesn't work as expected, please let me know!
1 x

User avatar
Juan F. Ramirez
Dynamite Dan
Posts: 1811
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: New Database Model ZXDB

Post by Juan F. Ramirez » Fri Jul 26, 2019 5:42 pm

Hi @Einar Saukas , it seems there's a problem in the Microhobby folder.

Whenever I click on [PDF] works ok (the PDF file is shown) but if I click on [VIEW] a new archive.org screen appears with the next error message:

'The item you have requested has a problem with one or more of the metadata files that describe it, which prevents us from displaying this page'

There's no similar problem with Sinclair User or Crash, everything is OK.

Besides, in the list of Microhobby issues, before #1 issue some random issues appear (with no corresponding picture):

1985/10
1987/3
1987/7
1991/4
1991/5
1991/12

I'm using Windows 10 & Chrome.

Hope it helps.
0 x

Post Reply