New Database Model ZXDB

[Einar Saukas]

A new ZXDB update is now available!

[Einar Saukas]

Another ZXDB update is available!

[Einar Saukas]

A new ZXDB update is now available!

[Einar Saukas]

Another ZXDB update was released!

[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.

[Einar Saukas]

A new ZXDB release is now available!

[PeterJ]

A new ZXDB release is now available!

Thanks @Einar Saukas. I will update the site this evening.

[Alone Coder]

Does the new version support different versions and releases of the same programs, and full zip archives of original author's releases?

[Einar Saukas]

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

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

[Einar Saukas]

BTW a new ZXDB release is now available!

[Einar Saukas]

Another ZXDB update is available!

[PeterJ]

Thanks @Einar Saukas,

I will update the site this coming weekend.

[Einar Saukas]

A new ZXDB version is available!

[Einar Saukas]

Another ZXDB update is available now!

[Einar Saukas]

A new ZXDB update is available!

[Einar Saukas]

Another ZXDB release is now available!

[Einar Saukas]

A new ZXDB release is available!

[kolbeck]

I get an error when importing ZXDB_help_search.sql

ERROR 1062 (23000) at line 17: Duplicate entry 'saghib�-38506' for key 'PRIMARY'

[Einar Saukas]

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

[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;

[Einar Saukas]

A new ZXDB update is available!

[Einar Saukas]

Another ZXDB update is now available!

[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...

[Einar Saukas]

Another ZXDB update is now available!

[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!