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
Dynamite Dan
Posts: 1193
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Yet another ZXDB release is available!

Special thanks to @R-Tape, @druellan, @pavero, and @PeterJ!
3 x

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

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB version is already out!

This release contains mostly little fixes. Lots of them :)
3 x

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

Re: New Database Model ZXDB

Post by PeterJ »

Thanks @Einar Saukas. Update applied.
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas »

And another ZXDB release is out!

With special thanks to @druellan, @pavero, @kolbeck, and @PeterJ this time!
4 x

User avatar
Stefan
Microbot
Posts: 146
Joined: Mon Nov 13, 2017 9:51 pm
Location: Belgium
Contact:

Re: New Database Model ZXDB

Post by Stefan »

Assuming that the database model has not changed but only the contents - maybe split this into two. A topic with content updates and a topic with database model updates?
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas »

Stefan wrote:
Mon Jun 29, 2020 9:17 am
Assuming that the database model has not changed but only the contents - maybe split this into two. A topic with content updates and a topic with database model updates?
Every ZXDB update has content updates, even when it also includes database model changes. For this reason, I don't think it would help to announce it in 2 different topics.
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas »

BTW there was a database change this time...

There's now a new table called "files". It combines all content from 3 other tables: "labelfiles", "magfiles", and "toolfiles".

These 3 tables are very similar, so it makes sense to unify them. Somewhat similar to the way table "magrefs" combine magazine references for entries, labels, and topics.

For now, all data stored in "files" continues to be duplicated separately into tables "labelfiles", "magfiles", and "toolfiles". In a future update, I'm planning to drop these 3 tables, and just keep "files". This should be a relatively simple change, I will give enough time for websites to adapt, and provide a warning in advance before removing these 3 tables.

The goal of this change is to simplify the ZXDB model, making it easier to understand. Any objections to this change?
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas »

One more ZXDB release is already available!

Many thanks to @R-Tape, @PeterJ, and @pavero!


PS: Don't worry, I didn't make any changes yet to those tables that I mentioned in my last post...
1 x

User avatar
kolbeck
Microbot
Posts: 127
Joined: Mon Nov 13, 2017 9:04 pm

Re: New Database Model ZXDB

Post by kolbeck »

Einar Saukas wrote:
Tue Jun 30, 2020 11:04 pm
BTW there was a database change this time...

There's now a new table called "files". It combines all content from 3 other tables: "labelfiles", "magfiles", and "toolfiles".
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.

/Thomas
0 x
https://zxinfo.dk - another ZXDB frontend
https://api.zxinfo.dk/ - ZXDB API for developers

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

Re: New Database Model ZXDB

Post by Einar Saukas »

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!
0 x

Post Reply