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
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB update is now available!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB update is available!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB update is now available!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB update was released!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

BTW the "availability" status in ZXDB is updated automatically now.

It means: when you upload a playable file for a certain title in ZXDB, you don't need to worry anymore about updating availability to "Available". Just wait for the next archive update, and it should happen automatically.
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB release is now available!
User avatar
PeterJ
Site Admin
Posts: 6876
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: New Database Model ZXDB

Post by PeterJ »

Einar Saukas wrote: Tue Jul 26, 2022 10:58 pm A new ZXDB release is now available!
Thanks @Einar Saukas. I will update the site this evening.
Alone Coder
Manic Miner
Posts: 401
Joined: Fri Jan 03, 2020 10:00 am

Re: New Database Model ZXDB

Post by Alone Coder »

Does the new version support different versions and releases of the same programs, and full zip archives of original author's releases?
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Alone Coder wrote: Mon Aug 01, 2022 6:27 pm Does the new version support different versions and releases of the same programs
It depends on what you mean. Perhaps like this?

https://spectrumcomputing.co.uk/entry/7 ... Beta_Basic
https://spectrumcomputing.co.uk/entry/6 ... ure_Writer

Alone Coder wrote: Mon Aug 01, 2022 6:27 pm and full zip archives of original author's releases?
Again, it depends on what you mean.

It's technically possible to store a full zip archive with everything. However we try to avoid it except in special cases like this:

https://spectrumcomputing.co.uk/entry/2 ... ition_2011

The reason is, it's easier for users to have files organized separately, so they can take a quick look with online emulation with a single click, read instructions with another single click, etc.

However if it's important to store a full ZIP for a certain entry, then we can have both: the full ZIP, and again the playable file stored separately. Or we can store both the playable file, and a link to the author's repository where he can organize everything himself/herself, like this:

https://spectrumcomputing.co.uk/entry/3 ... um/Che-Man
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

BTW a new ZXDB release is now available!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB update is available!
User avatar
PeterJ
Site Admin
Posts: 6876
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: New Database Model ZXDB

Post by PeterJ »

Thanks @Einar Saukas,

I will update the site this coming weekend.
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB version is available!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB update is available now!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB update is available!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB release is now available!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB release is available!
User avatar
kolbeck
Manic Miner
Posts: 310
Joined: Mon Nov 13, 2017 9:04 pm

Re: New Database Model ZXDB

Post by kolbeck »

I get an error when importing ZXDB_help_search.sql
ERROR 1062 (23000) at line 17: Duplicate entry 'saghib�-38506' for key 'PRIMARY'
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

kolbeck wrote: Sun Oct 16, 2022 12:15 am I get an error when importing ZXDB_help_search.sql
Please check if you are using the latest version of "ZXDB_help_search.sql". I uploaded a fix a few minutes after updating ZXDB. Also check if you are loading "ZXDB_help_search.sql" as UTF8.

If it still doesn't work for you, a quick fix is to run this SQL before running "ZXDB_help_search.sql":

Code: Select all

update contents set alias=null where entry_id=38506
User avatar
kolbeck
Manic Miner
Posts: 310
Joined: Mon Nov 13, 2017 9:04 pm

Re: New Database Model ZXDB

Post by kolbeck »

It is indeed the row from 'contents' for this id that makes it fail.

Change the alias from 'Saghibú' -> to 'Saghibù' also makes the script work again.

UPDATE `contents` SET `alias` = 'Saghibù' WHERE `contents`.`container_id` = 37941 AND `contents`.`media_seq` = 0 AND `contents`.`media_side` = 'A' AND `contents`.`prog_seq` = 5;
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB update is available!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB update is now available!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB is available! FINALLY!!!

My apologies for the delay. Now that the FIFA World Cup is over, we are back to normal...
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB update is now available!
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB version is now available!

This time there were a few (minor) changes in the database structure. If you have a web site or application using ZXDB, please read this:
  • ZXDB now stores information about magazine publisher(s) for each individual magazine issue, instead of magazine publisher(s) for the entire magazine. Technically there are now 2 new columns called "issues.label_id" and "issues.label2_id". The old columns "magazines.label_id" and "magazines.label2_id" still exist (therefore updating to this new version of ZXDB won't break anything!), but please don't use them anymore because these old columns will be removed in a future ZXDB update.
  • If you also use script "ZXDB_help_search.sql" (that's part of ZXDB distribution), now there's a new table called "search_by_magazines". This table collects all publishers for each magazine. Therefore this table can be used to replace the old columns mentioned above.
  • Also in script "ZXDB_help_search.sql", table "aux_issues" will be replaced by "search_by_issues". Both tables exist now, but the old table will be removed in a future ZXDB update so please change your code to use the new table instead.
  • Also in script "ZXDB_help_search.sql", table "aux_origintypes" will be replaced by "origintypes". Both tables exist now, but the old table will be removed in a future ZXDB update so please change your code to use the new table instead.
My apologies for the inconvenience, but these changes help to improve ZXDB accuracy. If you need help with SQL or anything else related to these changes, please let me know!
Post Reply