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
druellan
Manic Miner
Posts: 416
Joined: Tue Apr 03, 2018 6:19 pm
Location: Argentina
Contact:

Re: New Database Model ZXDB

Post by druellan » Fri May 24, 2019 1:16 pm

R-Tape wrote:
Fri May 24, 2019 8:57 am
As the main person currently doing corrections at the moment, what do you prefer @druellan ? Would it be useful to have a volunteer (perhaps @StooB ?) to keep on top of a finalised corrections spreadsheet, that is basically a list of ZXDB ID and a concise explanation of the correction needed? (Or would you rather be left alone to get on with it?!)
I really don't like the idea to have the information spread on different mediums, that usually end up with discrepancies and an overhead of work. I like the flexibility of the public spreadsheet, but:

A spreadsheet is really not a good bug reporting platform at all, it makes the information difficult to post, edit and read. Not everyone has a Google account, that means to leave everything open and editable, and that's kind of concerning, not because someone is going to sabotage or post nonsense (can happen), but it is easy delete or alter the information by mistake if you are just looking.

The sheet works best as an index for all the bugs reported and solved (or not) on the forum. I'm already doing that myself, just to keep track on everything I'm looking at, perhaps is not a big deal to open a public spreadsheet and add everything there.

Could be nice to use such a sheet as a triage process for the reports, but makes no sense of doing that if I'm the only one focusing on this area.

Besides that, I think we still need to inform something to the person that posted the report, without the hassle of looking on a spreadsheet, this also helps me to quickly catch posts I missed, something that can happen when a discussion fires up. If we can't find a plugin or a hack to "mark" a post, the best way to do it is just edit the post and add some kind of tag, like [IN PROGRESS] or [DONE]. Those tags can also be color PNGs and added to the forum as Smilies.

But for my own requirements, the "like" approach works, so we can start with a public sheet of reports solved or in progress if you like, and go on from there.
0 x
Un buen día me puse a probar juegos de ZX Spectrum a ciegas en Youtube, terminó siendo:
📺 Retroarqueología en Youtube

User avatar
druellan
Manic Miner
Posts: 416
Joined: Tue Apr 03, 2018 6:19 pm
Location: Argentina
Contact:

Re: New Database Model ZXDB

Post by druellan » Fri May 24, 2019 1:22 pm

druellan wrote:
Fri May 24, 2019 1:16 pm
The sheet works best as an index for all the bugs reported and solved (or not) on the forum. I'm already doing that myself, just to keep track on everything I'm looking at, perhaps is not a big deal to open a public spreadsheet and add everything there.
Just to be clear, I'm doing this by REPORT, and not by ENTRY, using the post ID and author as reference. By entry can be problematic, since a report can target a company or a publisher, not only a title.
0 x
Un buen día me puse a probar juegos de ZX Spectrum a ciegas en Youtube, terminó siendo:
📺 Retroarqueología en Youtube

User avatar
Einar Saukas
Manic Miner
Posts: 938
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Fri May 24, 2019 1:41 pm

druellan wrote:
Fri May 24, 2019 1:16 pm
The sheet works best as an index for all the bugs reported and solved (or not) on the forum. I'm already doing that myself, just to keep track on everything I'm looking at, perhaps is not a big deal to open a public spreadsheet and add everything there.
Instead of opening a new public spreadsheet, you could simply share your already existing spreadsheet, as read-only. Thus you wouldn't have any extra work besides what you are already doing.

Although I'm still convinced the ideal solution would be some kind of "fixed" tag in each post.
2 x

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

Re: New Database Model ZXDB

Post by R-Tape » Fri May 24, 2019 2:04 pm

Sorry @druellan @Einar Saukas , I actually meant someone else (not me, you, or Dru) does the work of distilling correction discussions into a concise list (spreadsheet or whatever), so that it's easier for Dru (or myself when I find time) to work through them.

My thinking was that it is already enough work for someone to create the SQL for the corrections without having to constantly keep on top of the forum discussions.

But maybe Dru is already happy with the current situation. Sorry! I don't know enough about what's happening there, corrections are not my priority, and I shouldn't have poked my nose in :D
2 x

hikoki
Manic Miner
Posts: 399
Joined: Thu Nov 16, 2017 10:54 am

Re: New Database Model ZXDB

Post by hikoki » Fri May 24, 2019 2:25 pm

@druellan you may want to give bookmarks.google.com a try as it allows to add tags and comments to every post url that you bookmark. From time to time you could export to html and publish that page. An example: speccy21.updog.co/googlebookmarks.html
0 x

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

Re: New Database Model ZXDB

Post by PeterJ » Fri May 24, 2019 3:02 pm

Lets wait for @druellan to reply until we go into detailed options. I'm a fan of keep it simple.
0 x

User avatar
druellan
Manic Miner
Posts: 416
Joined: Tue Apr 03, 2018 6:19 pm
Location: Argentina
Contact:

Re: New Database Model ZXDB

Post by druellan » Sun May 26, 2019 11:07 am

PeterJ wrote:
Fri May 24, 2019 3:02 pm
Lets wait for @druellan to reply until we go into detaied options. I'm a fan of keep it simple.
I'm OK on keeping a spreadsheet about the reports I'm working on. Just for the record, I'm currently not using a sheet but just a plain simple TXT file, but I have no problem on using a sheet instead.

About a way to proper "mark" the posts I'm working on, the "like" approach is not ideal but works for me, but for other users is kind of confusing, since all "likes" look identical, so, a better way to mark those reports is welcome.

If you don't want to mess with the forum and install a MOD, there are a couple of solutions involving Javascript that might work (just detect a post was liked by me an trigger some actions), but the simplest way is to edit the original POST (I'm going to need permissions to do that on the topic) and add a label like [DONE], [WON'T FIX], etc. We can use the smilies to add a nice graphical one.
0 x
Un buen día me puse a probar juegos de ZX Spectrum a ciegas en Youtube, terminó siendo:
📺 Retroarqueología en Youtube

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

Re: New Database Model ZXDB

Post by PeterJ » Mon May 27, 2019 12:22 pm

druellan wrote:
Sun May 26, 2019 11:07 am
PeterJ wrote:
Fri May 24, 2019 3:02 pm
Lets wait for @druellan to reply until we go into detailed options. I'm a fan of keep it simple.
About a way to proper "mark" the posts I'm working on, the "like" approach is not ideal but works for me, but for other users is kind of confusing, since all "likes" look identical, so, a better way to mark those reports is welcome.

If you don't want to mess with the forum and install a MOD, there are a couple of solutions involving Javascript that might work (just detect a post was liked by me an trigger some actions), but the simplest way is to edit the original POST (I'm going to need permissions to do that on the topic) and add a label like [DONE], [WON'T FIX], etc. We can use the smilies to add a nice graphical one.
OK, @druellan now has appropriate rights to this sub-forum so will be able to edit posts to mark as appropriate.
1 x

User avatar
Einar Saukas
Manic Miner
Posts: 938
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas » Sat Jun 01, 2019 4:43 am

A new ZXDB update is available!

This new version contains game review scores from all major magazines (many thanks to Chris from ZXSR for this information!), an updated list of all available RZX recordings (many thanks to Daren from RZX Archive for this information!), and additional hires inlays (many thanks to Pavel as usual!)
5 x

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

Re: New Database Model ZXDB

Post by PeterJ » Sat Jun 01, 2019 10:16 am

This latest update has been applied. Thanks again to Chris AKA @Vampyre for giving us access to the ZXSR database, @Daren for all his videos, and @pavero for the continuous flow of updated images. We will be working on adding the additional fields from ZXSR to the game pages.
2 x

Post Reply