Page 18 of 22
Re: New Database Model ZXDB
Posted: Wed Jun 22, 2022 1:32 am
by Einar Saukas
A new ZXDB update is now available!
Re: New Database Model ZXDB
Posted: Mon Jul 04, 2022 9:31 pm
by Einar Saukas
Another ZXDB update is available!
Re: New Database Model ZXDB
Posted: Tue Jul 12, 2022 12:40 am
by Einar Saukas
A new ZXDB update is now available!
Re: New Database Model ZXDB
Posted: Sun Jul 17, 2022 5:35 am
by Einar Saukas
Another ZXDB update was released!
Re: New Database Model ZXDB
Posted: Sun Jul 17, 2022 11:56 pm
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.
Re: New Database Model ZXDB
Posted: Tue Jul 26, 2022 10:58 pm
by Einar Saukas
A new ZXDB release is now available!
Re: New Database Model ZXDB
Posted: Wed Jul 27, 2022 8:53 am
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.
Re: New Database Model ZXDB
Posted: Mon Aug 01, 2022 6:27 pm
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?
Re: New Database Model ZXDB
Posted: Tue Aug 02, 2022 12:01 am
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
Re: New Database Model ZXDB
Posted: Tue Aug 02, 2022 12:02 am
by Einar Saukas
BTW a new ZXDB release is now available!
Re: New Database Model ZXDB
Posted: Tue Aug 09, 2022 5:26 pm
by Einar Saukas
Another ZXDB update is available!
Re: New Database Model ZXDB
Posted: Tue Aug 09, 2022 6:08 pm
by PeterJ
Thanks @Einar Saukas,
I will update the site this coming weekend.
Re: New Database Model ZXDB
Posted: Mon Aug 15, 2022 5:43 pm
by Einar Saukas
A new ZXDB version is available!
Re: New Database Model ZXDB
Posted: Sat Aug 27, 2022 5:09 pm
by Einar Saukas
Another ZXDB update is available now!
Re: New Database Model ZXDB
Posted: Fri Sep 16, 2022 11:48 pm
by Einar Saukas
A new ZXDB update is available!
Re: New Database Model ZXDB
Posted: Sat Oct 08, 2022 12:36 am
by Einar Saukas
Another ZXDB release is now available!
Re: New Database Model ZXDB
Posted: Fri Oct 14, 2022 10:50 am
by Einar Saukas
A new ZXDB release is available!
Re: New Database Model ZXDB
Posted: Sun Oct 16, 2022 12:15 am
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'
Re: New Database Model ZXDB
Posted: Sun Oct 16, 2022 1:22 am
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
Re: New Database Model ZXDB
Posted: Sun Oct 16, 2022 11:39 am
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;
Re: New Database Model ZXDB
Posted: Mon Oct 24, 2022 5:34 pm
by Einar Saukas
A new ZXDB update is available!
Re: New Database Model ZXDB
Posted: Sat Oct 29, 2022 11:27 pm
by Einar Saukas
Another ZXDB update is now available!
Re: New Database Model ZXDB
Posted: Mon Dec 19, 2022 3:52 pm
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...
Re: New Database Model ZXDB
Posted: Fri Dec 23, 2022 6:44 pm
by Einar Saukas
Another ZXDB update is now available!
Re: New Database Model ZXDB
Posted: Sun Jan 08, 2023 1:51 am
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!