Database model ZXDB
Moderator: druellan
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Database model ZXDB
ZXDB is an "open" database model that catalogues Spectrum (and other Sinclair-related) material including software, hardware, books, magazines, etc.
It contains the entire information content from both Martijn's original WoS archive and Grimwood's SPOT/SPEX, plus thousands of new titles, plus dozens of thousands of corrections, fixes, additional details and improvements. It's also closely integrated with ZXSR, RZX Archive, ZX81 Stuff, CASA, MobyGames, Speccy Screenshot Maps, and ZX-Art. Both Spectrum Computing and ZXInfo currently use ZXDB directly, also ZX-Art imports ZXDB content periodically.
All ZXDB updates will be announced in this thread. Stay tuned!
It contains the entire information content from both Martijn's original WoS archive and Grimwood's SPOT/SPEX, plus thousands of new titles, plus dozens of thousands of corrections, fixes, additional details and improvements. It's also closely integrated with ZXSR, RZX Archive, ZX81 Stuff, CASA, MobyGames, Speccy Screenshot Maps, and ZX-Art. Both Spectrum Computing and ZXInfo currently use ZXDB directly, also ZX-Art imports ZXDB content periodically.
All ZXDB updates will be announced in this thread. Stay tuned!
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
A new version of ZXDB is available here!
This update contains a few recent releases and previously missing titles.
It also contains several links to CASA that were missing. Many thanks to Thomas for organizing this information!
Technically, this update also contains an improvement on table "labels". There's now a new column "labels.labeltype_id", intended to replace both columns "labels.is_company" and "labels.companytype_id". For now, I'm keeping all these columns in ZXDB, thus websites can have enough time to adapt accordingly. In a later release, both these columns will be eliminated. As usual, please contact me if you need any support on this!
This update contains a few recent releases and previously missing titles.
It also contains several links to CASA that were missing. Many thanks to Thomas for organizing this information!
Technically, this update also contains an improvement on table "labels". There's now a new column "labels.labeltype_id", intended to replace both columns "labels.is_company" and "labels.companytype_id". For now, I'm keeping all these columns in ZXDB, thus websites can have enough time to adapt accordingly. In a later release, both these columns will be eliminated. As usual, please contact me if you need any support on this!
Re: Database model ZXDB
Just a thanks to everyone involved with this. Really is an amazing bit of work.
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
Missing screenshots (some are to replace wrong ones on zxdb) :
https://www.dropbox.com/s/bhdm550my50u4 ... 3.zip?dl=1
Unlisted games on zxdb : https://awesome-table.com/-KTJLy2xX7_E1 ... N=unlisted
https://www.dropbox.com/s/bhdm550my50u4 ... 3.zip?dl=1
Unlisted games on zxdb : https://awesome-table.com/-KTJLy2xX7_E1 ... N=unlisted
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
Thank you!!!
I will add everything in the next archive update!
I will add everything in the next archive update!
- Alessandro
- Dynamite Dan
- Posts: 1910
- Joined: Wed Nov 15, 2017 11:10 am
- Location: Messina, Italy
- Contact:
Re: Database model ZXDB
A better in-game screen for Sophia.
Also please update the description by adding the Russian and Swedish language versions.
Also please update the description by adding the Russian and Swedish language versions.
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
Thank you!!!
I will make these changes in the next update!
I will make these changes in the next update!
Re: Database model ZXDB
Strange Kitchen is a game from 2016 NOT from 2015
See viewtopic.php?f=3&t=155&p=1670#p1670
See viewtopic.php?f=3&t=155&p=1670#p1670
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
Thank you!!!
This will be fixed in the next archive update!
This will be fixed in the next archive update!
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
There's finally a new version of ZXDB here!
This update contains lots of additional links to CASA (thanks to Thomas!), new titles (thanks to hikoki!) and new downloadable files (thanks to R-Tape!)
Sorry for the extra delay, I have been too busy... Next update will include a lot more files that I didn't have time to include yet![Smile :)](./images/smilies/icon_e_smile.gif)
This update contains lots of additional links to CASA (thanks to Thomas!), new titles (thanks to hikoki!) and new downloadable files (thanks to R-Tape!)
Sorry for the extra delay, I have been too busy... Next update will include a lot more files that I didn't have time to include yet
![Smile :)](./images/smilies/icon_e_smile.gif)
Re: Database model ZXDB
Thanks Einar for the update.
I will update the site this evening.
I will update the site this evening.
Re: Database model ZXDB
Woot!
Thanks fellas.
Thanks fellas.
Re: Database model ZXDB
Great !
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
Another ZXDB update is available here!
This update includes many ZX81 screenshots and links to Mobygames (thanks to Thomas!), new downloadable files (thanks to R-Tape, Peter and hikoki), several new titles, and database content improvements such as credits to cover artists (thanks to everybody else that contributed in this forum)!
This update includes many ZX81 screenshots and links to Mobygames (thanks to Thomas!), new downloadable files (thanks to R-Tape, Peter and hikoki), several new titles, and database content improvements such as credits to cover artists (thanks to everybody else that contributed in this forum)!
Re: Database model ZXDB
Thanks Einar,
I will get the site updated over the weekend
I will get the site updated over the weekend
Re: Database model ZXDB
Is it possible at the moment to see games added in last update ?
Re: Database model ZXDB
Yep, homepage 'updates'. Often it's new ZXDB entries with screenshots, TAPs and instructions that fill in later.
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
One more ZXDB update is available here!
This update includes a few more new titles, download files, and... a couple new distribution permissions for classic games. Hurray!
This update includes a few more new titles, download files, and... a couple new distribution permissions for classic games. Hurray!
Re: Database model ZXDB
La Churrera has changed its license, see: http://www.mojontwins.com/juegos_mojono ... a-english/
So Comments on ZXDB are incorrect : https://spectrumcomputing.co.uk/index.p ... 6&id=30008
I believe this sort of wrong comments are on every game made with La Churrera which now is officially called MK1.
Note that while MK1 is copyleft, MK2 remains free for nonprofit
what is this title on ZXDB? https://spectrumcomputing.co.uk/index.p ... 6&id=32113
this may be superseded by https://spectrumcomputing.co.uk/index.p ... 6&id=30160
I'll post more .scr from recent games later.
So Comments on ZXDB are incorrect : https://spectrumcomputing.co.uk/index.p ... 6&id=30008
I believe this sort of wrong comments are on every game made with La Churrera which now is officially called MK1.
Note that while MK1 is copyleft, MK2 remains free for nonprofit
what is this title on ZXDB? https://spectrumcomputing.co.uk/index.p ... 6&id=32113
this may be superseded by https://spectrumcomputing.co.uk/index.p ... 6&id=30160
I'll post more .scr from recent games later.
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
Thank you!!! I will update this information in the next ZXDB update.hikoki wrote: ↑Mon Dec 18, 2017 12:17 pmLa Churrera has changed its license, see: http://www.mojontwins.com/juegos_mojono ... a-english/
So Comments on ZXDB are incorrect : https://spectrumcomputing.co.uk/index.p ... 6&id=30008
I believe this sort of wrong comments are on every game made with La Churrera which now is officially called MK1.
Note that while MK1 is copyleft, MK2 remains free for nonprofit
You are probably right! Please give me more time to investigate it further. Thanks again!hikoki wrote: ↑Mon Dec 18, 2017 12:17 pmwhat is this title on ZXDB? https://spectrumcomputing.co.uk/index.p ... 6&id=32113
this may be superseded by https://spectrumcomputing.co.uk/index.p ... 6&id=30160
Re: Database model ZXDB
I took more screenshots :
https://www.dropbox.com/s/hro8jucbscbfa ... 8.zip?dl=1
Unlisted games on zxdb : https://awesome-table.com/-KTJLy2xX7_E1 ... N=unlisted
Pay attention to what I consider "compilation"
sorry now you'll get what I mean by community effort. I don't know your plans though.
Of course
Run!!!
https://www.dropbox.com/s/hro8jucbscbfa ... 8.zip?dl=1
Unlisted games on zxdb : https://awesome-table.com/-KTJLy2xX7_E1 ... N=unlisted
Pay attention to what I consider "compilation"
![Smile :)](./images/smilies/icon_e_smile.gif)
Of course
Spoiler
I'll give you more time to consult you Boobology books, Einar the Wise
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
A new ZXDB update is available here!
This update includes lots of additional titles, screens and download files.
Merry Xmas!![Smile :)](./images/smilies/icon_e_smile.gif)
This update includes lots of additional titles, screens and download files.
Merry Xmas!
![Smile :)](./images/smilies/icon_e_smile.gif)
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
Thank you!!! I will include them in the next ZXDB update.hikoki wrote: ↑Mon Dec 18, 2017 8:59 pm I took more screenshots :
https://www.dropbox.com/s/hro8jucbscbfa ... 8.zip?dl=1
Unlisted games on zxdb : https://awesome-table.com/-KTJLy2xX7_E1 ... N=unlisted
Pay attention to what I consider "compilation"sorry now you'll get what I mean by community effort. I don't know your plans though.
- Einar Saukas
- Bugaboo
- Posts: 3120
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Database model ZXDB
Ops! I was in a hurry when I posted the ZXDB update last night, so I forgot to thank everybody that assisted with content. Sorry! Although it's easy to guess the usual contributors: R-Tape, Peter, hikoki, Thomas, and everyone else that posted useful information in this forum. Thank you!