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: 1442
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

R-Tape wrote:
Thu Sep 03, 2020 8:12 pm
Ah that's what those apparently superfluous columns were for. I thought you'd gone round the bend!
These explanations are not mutually exclusive!
0 x

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

Re: New Database Model ZXDB

Post by R-Tape »

@Frankie @wallyweek @WhatHoSnorkers. I just wanted to say that the last few updates have not included your recent MIA/uMIA. I'm still working on my part of the update, so I'll get it to Einar for the next one.
3 x

User avatar
WhatHoSnorkers
Berk
Posts: 29
Joined: Tue Dec 10, 2019 3:22 pm

Re: New Database Model ZXDB

Post by WhatHoSnorkers »

No worries!
0 x
I have a little YouTube channel of nonsense
https://www.youtube.com/c/JamesOGradyWhatHoSnorkers

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

Re: New Database Model ZXDB

Post by kolbeck »

Einar Saukas wrote:
Fri Aug 21, 2020 1:46 am

Code: Select all

select e.id, e.title, e.comments, e.hardware_blurb, e.known_errors from entries e where e.id = ?
corresponds now to a query like this:

Code: Select all

select e.id, e.title, 
GROUP_CONCAT(c.text ORDER BY c.text SEPARATOR '\n\n') as comments,
h.text as hardware_blurb, 
r.text as known_errors
from entries e 
left join notes c on e.id = c.entry_id and c.notetype_id = 'C'
left join notes h on e.id = h.entry_id and h.notetype_id = 'H'
left join notes r on e.id = r.entry_id and r.notetype_id = 'R'
where e.id = ?
Shouldn't it be R, S, E instead of C, H, R? (Combined with notes.section for S for hardware blurp)

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

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

Re: New Database Model ZXDB

Post by Einar Saukas »

kolbeck wrote:
Wed Sep 09, 2020 8:59 am
Shouldn't it be R, S, E instead of C, H, R? (Combined with notes.section for S for hardware blurp)
Yes, you are right. Sorry!
0 x

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

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB update is available!

It contains new titles (thanks @R-Tape and @pavero!), new magazine issues (thanks @Andre Leao!), more indexed Load'n'Run covertapes (thanks @wallyweek!), and more bugfixes (thanks @druellan!)
5 x

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

Re: New Database Model ZXDB

Post by PeterJ »

Thank you @Einar Saukas,

I will update the site on Thursday evening.
1 x

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

Re: New Database Model ZXDB

Post by Einar Saukas »

ZXDB was updated again!

This version mostly contains new titles (thanks @R-Tape!) and hires inlays (thanks @pavero!)
4 x

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

Re: New Database Model ZXDB

Post by Einar Saukas »

Yet another ZXDB update is available!

It contains more new titles (thanks @R-Tape!) and lots of bugfixes (thanks @druellan!)
2 x

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

Re: New Database Model ZXDB

Post by PeterJ »

Thanks @Einar Saukas,

I will update the site on Wednesday.

Peter
0 x

Post Reply