Page 21 of 22

Re: New Database Model ZXDB

Posted: Mon Feb 12, 2024 9:43 pm
by Einar Saukas
Another ZXDB version is available!

Re: New Database Model ZXDB

Posted: Mon Feb 12, 2024 10:14 pm
by PeterJ
Einar Saukas wrote: Mon Feb 12, 2024 9:43 pm Another ZXDB version is available!
Thanks Einar,

I will update in the next couple of days.

Re: New Database Model ZXDB

Posted: Tue Feb 13, 2024 12:46 pm
by SkoolKid
Einar Saukas wrote: Mon Feb 12, 2024 9:43 pm Another ZXDB version is available!
This version fails to build the database from ZXDB_sqlite.sql. It gives the following error:

Code: Select all

Parse error near line 565472: near "CHARACTER": syntax error
  TABLE IF NOT EXISTS prefixes (   text varchar(10) CHARACTER SET utf8 COLLATE u
                                      error here ---^
Parse error near line 565478: no such table: prefixes
Parse error near line 565508: near "CHARACTER": syntax error
   IF NOT EXISTS prefixexempts (   text varchar(50) CHARACTER SET utf8 COLLATE u
                                      error here ---^
Parse error near line 565514: no such table: prefixexempts
I got it working by removing "CHARACTER SET utf8 COLLATE utf8_unicode_ci" from the two offending CREATE TABLE statements.

The previous version (1.0.183) built OK, so something must have changed in this area.

Re: New Database Model ZXDB

Posted: Sat Feb 17, 2024 8:44 pm
by Einar Saukas
SkoolKid wrote: Tue Feb 13, 2024 12:46 pm This version fails to build the database from ZXDB_sqlite.sql.
Merge request approved. Thank you!

Re: New Database Model ZXDB

Posted: Fri Mar 01, 2024 4:11 pm
by Einar Saukas
A new ZXDB version is now available!

Re: New Database Model ZXDB

Posted: Fri Mar 01, 2024 4:30 pm
by PeterJ
Thanks @Einar Saukas,

I will update the site on Monday.

Re: New Database Model ZXDB

Posted: Mon Mar 11, 2024 6:07 pm
by Einar Saukas
Another ZXDB update is available!

Re: New Database Model ZXDB

Posted: Tue Mar 19, 2024 5:26 pm
by Einar Saukas
A new ZXDB release is available!

Re: New Database Model ZXDB

Posted: Tue Apr 02, 2024 9:53 pm
by Einar Saukas
Another ZXDB update is now available!

Re: New Database Model ZXDB

Posted: Sun Apr 07, 2024 1:44 am
by Einar Saukas
Yet another ZXDB release is available already!

Re: New Database Model ZXDB

Posted: Sun Apr 07, 2024 7:38 am
by PeterJ
Thanks @Einar Saukas. I will update the site on Monday.

Re: New Database Model ZXDB

Posted: Wed Apr 10, 2024 2:07 pm
by Patrik Rak
Late to the party, but why was the library_title removed in the first place? Just to save space? Couldn't have it been simply null when it doesn't differ from the title?

As for the provided SQL scripts, unfortunately none worked for me out of the box, not even Skoolkids, perhaps my sqlite is older than his. I will need spend some time on this (which I don't have) to get it back. Couldn't we just have the table there by default?

Also I find it surprising that there is no check for the language - I would expect Der/Die/Das apply only to German, not other languages, similarly A/An/The to English and not Czech (thus avoiding the need for some exemptions).

Re: New Database Model ZXDB

Posted: Wed Apr 10, 2024 2:11 pm
by PeterJ
Hi @Patrik Rak,

@Einar Saukas will reply in full, but please read here:

viewtopic.php?p=136543#p136543

Peter

Re: New Database Model ZXDB

Posted: Wed Apr 10, 2024 2:14 pm
by Patrik Rak
I did, even the original post, but that really doesn't explain the point, IMO, why was this change worth it.

Re: New Database Model ZXDB

Posted: Wed Apr 10, 2024 2:18 pm
by PeterJ
Hi @Patrik Rak,

Einar explains it in the linked post.
However if this column is so useful, why are we removing it from the database? Because we don't need to store it anymore. This column was originally filled manually in ZXDB, but now we use a routine to generate it automatically (the online form doesn't even have an option to enter it manually).
I will let him explain further. Thanks

Re: New Database Model ZXDB

Posted: Wed Apr 10, 2024 2:18 pm
by Patrik Rak
I mean, if you want to group the games by letter reasonably, you need the library title without the articles. In order to be able to search them efficiently in the database, you will have to have the field ready in some form in one way or another, be it in another table or not. So I don't see the point of removing it entirely, even if it can be created on the fly, just to push the burden on the users who need it.

Re: New Database Model ZXDB

Posted: Wed Apr 10, 2024 2:22 pm
by PeterJ
As mentioned I can't comment any further as it's Einar's baby. I'm sure he will reply when he has time. He did give six month notice, so not something that can be reversed at this stage. I'm sure he can still help you though.

If you use the mention system '@' then pick username, Einar will get a notification that you have asked a question.

Re: New Database Model ZXDB

Posted: Wed Apr 10, 2024 8:24 pm
by Einar Saukas
Patrik Rak wrote: Wed Apr 10, 2024 2:07 pm why was the library_title removed in the first place?
Because it's an automatically generated field.

Imagine the following analogy with programming. Suppose you are creating a game where every sprite also needs the corresponding mirrored version, and it's not viable to generate them during runtime. What's the best option?

a) Store both original and mirrored version of each sprite in your source code. Whenever you modify an original sprite, don't forget to regenerate the corresponding mirrored version, then update both in your source code.

b) Store only the original version of each sprite in your source code. You can freely modify any original sprite without worrying about the mirrored versions. Let your compile script automatically regenerate all mirrored versions whenever you compile your program.

ZXDB follows the latter option. Whenever an information is automatically generated, then it's not part of the ZXDB "source code" distribution. Instead it's dynamically generated by scripts.

Patrik Rak wrote: Wed Apr 10, 2024 2:07 pm As for the provided SQL scripts, unfortunately none worked for me out of the box, not even Skoolkids, perhaps my sqlite is older than his.
Did you try the second version in this post? It uses very simple SQL so it should work for you. Simply remove "collate utf8_unicode_ci" if that's a problem.

Patrik Rak wrote: Wed Apr 10, 2024 2:07 pm Also I find it surprising that there is no check for the language - I would expect Der/Die/Das apply only to German, not other languages, similarly A/An/The to English and not Czech (thus avoiding the need for some exemptions).
It won't help, because titles in foreign languages may still have an English title, and vice-versa. For instance Spanish games like The Blues Brothers or The Last Warrior.

Re: New Database Model ZXDB

Posted: Fri Apr 12, 2024 1:28 pm
by Neil Parsons
Maybe it was mentioned long time ago, but I don't know how to reach to that thread or post.

There are some fields in some entries I've been watching from time to time and I'd like to know, for my own curiousity, if they can be filled by any registered user via ZXDB preservation tools, or that's just a feature only available for administrators. As these ones: Controls, Features, Graphical Views, Native Programming Languages (BASIC, Machine Code, etc.), Copyright Status and Cross-Platform Tools.

Re: New Database Model ZXDB

Posted: Fri Apr 12, 2024 1:44 pm
by StooB
Neil Parsons wrote: Fri Apr 12, 2024 1:28 pm Controls, Features, Graphical Views, Native Programming Languages (BASIC, Machine Code, etc.), Copyright Status and Cross-Platform Tools.
Go to small changes for existing entries and scroll down to the pink Groups section.

Re: New Database Model ZXDB

Posted: Fri Apr 12, 2024 2:19 pm
by Neil Parsons
StooB wrote: Fri Apr 12, 2024 1:44 pm Go to small changes for existing entries and scroll down to the pink Groups section.
Thank you. :)

Re: New Database Model ZXDB

Posted: Fri Apr 12, 2024 2:28 pm
by Einar Saukas
Also when adding a new (MIA) entry, click on "Show advanced features" and add each feature under "Group title".

Re: New Database Model ZXDB

Posted: Fri Apr 12, 2024 5:56 pm
by Einar Saukas
A new ZXDB release is now available!

Re: New Database Model ZXDB

Posted: Fri Apr 19, 2024 3:25 pm
by Einar Saukas
Another ZXDB release is now available!

We added hundreds more links to ports of Spectrum titles in other platforms. Many thanks to Kim Lemon from Lemon64 for this information! We have been collaborating for quite some time helping each other and exchanging data, which benefits both sites.

This release also incorporates the latest updates from ZXSR (ZX Spectrum Reviews). Many thanks to @Vampyre for continuously improving it!

Re: New Database Model ZXDB

Posted: Fri Apr 19, 2024 4:26 pm
by Patrik Rak
Einar Saukas wrote: Wed Apr 10, 2024 8:24 pm Because it's an automatically generated field.
...
ZXDB follows the latter option. Whenever an information is automatically generated, then it's not part of the ZXDB "source code" distribution. Instead it's dynamically generated by scripts.
You could just as well run the scripts and distribute the results... People wouldn't then have to worry that they might create different results than the master... But I accept that it's your call, of course.
Did you try the second version in this post? It uses very simple SQL so it should work for you. Simply remove "collate utf8_unicode_ci" if that's a problem.
Yeah, I did, but IIRC it choked on more than just the collate. But considering it's something which works for the current version and needs to be updated whenever one of your tables for creating the library title is modified, it's not a long term solution for me anyway.

I guess I'll just write a script which will create the library title using your tables and hope I made it compatible to your scripts and that your scripts won't change in foreseeable future...

Still I can't shake the feeling this is a pointless hassle for something which was working just fine...
It won't help, because titles in foreign languages may still have an English title, and vice-versa. For instance Spanish games like The Blues Brothers or The Last Warrior.
Oh, right. True...