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
kolbeck
Microbot
Posts: 140
Joined: Mon Nov 13, 2017 9:04 pm

Re: New Database Model ZXDB

Post by kolbeck »

Einar Saukas wrote:
Wed Jul 01, 2020 5:42 pm
kolbeck wrote:
Wed Jul 01, 2020 4:41 pm
Would it makes sense to add a md5 field to the files table? So it would be possible to cross check when new/old files arrives.
Good point. Now that I'm already collecting file sizes because of this, collecting md5 also shouldn't be a problem.

I will implement it ASAP!
Great - i Will start using it
0 x
https://zxinfo.dk - another ZXDB frontend
https://api.zxinfo.dk/ - ZXDB API for developers

User avatar
Einar Saukas
Dynamite Dan
Posts: 1306
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

A new ZXDB version is now available!

Many thanks to @kolbeck, @druellan and @pavero for their contributions as usual... also a very special "thank you" to Steven Brown from TZXVault, that's now helping the ZXDB team to add countless rare tapes and solved M.I.A.s to ZXDB. I'm sure a lot of people will recognize his name, he has been preserving Spectrum software a lot longer than any of us, so it's a privilege to work together with him. We have just added 300 rare tapes to ZXDB that he provided, there's certainly a lot more to come :)

On a more technical note, ZXDB now contains MD5 data for ZXDB files, so it's easier to keep track of updated files. Another change is, tables "labelfiles", "magfiles", and "toolfiles" don't exist anymore. As I mentioned before, all their content went into a single table "files". Don't forget to check if you have already made this change to your website before updating ZXDB this time.

My apologies for all other new contributions that were not included in this release yet, but we have been very busy. They will be included next time!
4 x

User avatar
PeterJ
Site Admin
Posts: 2467
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: New Database Model ZXDB

Post by PeterJ »

Thanks @Einar Saukas,

I will get the site updated tonight. Great news about the link with TZXVault
0 x

User avatar
Juan F. Ramirez
Rick Dangerous
Posts: 2797
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: New Database Model ZXDB

Post by Juan F. Ramirez »

The 'signing' of the TZX Vault is a very, very great news for Spectrum Computing.

Congrats!
1 x

Ralf
Dynamite Dan
Posts: 1548
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: New Database Model ZXDB

Post by Ralf »

Great to see joining the forces with Steve and TzxVault !

He and other guys did an incredible job of preserving missing software and uploading it to WOS when it was still ran by Martijn.
We all know what happened later but now it seems that the dark days are over and we are going to enjoy their great work again.
0 x

User avatar
Einar Saukas
Dynamite Dan
Posts: 1306
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

And another ZXDB update is already available!

This time we have lots of new Spectrum titles (thanks @R-Tape!), about 60 Sinclair QL titles (thanks @4thRock!), about 400 links to BBC Micro versions of Spectrum games (thanks @Stu!), over 100 links to Spectrum games at The Cutting Room Floor (thanks again @Stu!), about 100 music references (thanks @Rorthron and everyone else that contributed with information!)

Our archive is growing faster than ever :)
7 x

User avatar
Einar Saukas
Dynamite Dan
Posts: 1306
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB update is available!

It contains lots of ZX81 titles (thanks @kolbeck!), new hires inlays (thanks @pavero!), newly indexed Load'n'Run covertapes (thanks @wallyweek!), about 1400 new links to Spectrum versions on other platforms (thanks @Stu!), and many other minor improvements.
7 x

User avatar
PeterJ
Site Admin
Posts: 2467
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: New Database Model ZXDB

Post by PeterJ »

Thanks everyone! I will update the site this evening at sometime between 18:00 and 21:00 BST. The main site will produce errors during the update.
1 x

User avatar
R-Tape
Site Admin
Posts: 3321
Joined: Thu Nov 09, 2017 11:46 am

Re: New Database Model ZXDB

Post by R-Tape »

Just to add that it doesn't contain the new entries I've been working on. Anyone expecting anything - nearly done, wait till the next update!
0 x

User avatar
PeterJ
Site Admin
Posts: 2467
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: New Database Model ZXDB

Post by PeterJ »

Just wow!!!

34,699 rows in the entries table now!

Image

Image
7 x

Post Reply