How to query the database independently from the game search

Information from and to the site administrators.

Moderator: Alastair

Post Reply
Message
Author
iamaran
Posts: 42
Joined: Tue Apr 06, 2010 9:01 pm

How to query the database independently from the game search

#1 Post by iamaran » Thu Jan 19, 2017 2:34 pm

Example: return BBC Micro games without an attached image.

Thanks.

User avatar
Alex
Posts: 617
Joined: Tue Oct 24, 2006 10:45 pm
Location: Netherlands

Re: How to query the database independently from the game se

#2 Post by Alex » Thu Jan 19, 2017 8:37 pm

I don't know if these options are needed for the general user, but I also would like to have options like:

-Which games for the c64 don't have a year, company, author,genre etc
It would make it a lot easier to update the database where needed.

May be more interesting for general users:
-Which games are currently played by others (or not)
-Which games have a rating of 6 and above
Note that even when you rate a game with a 1 the site tells you liked playing it when you look at another game which you also have rated :)

Alastair
Posts: 702
Joined: Fri Nov 11, 2005 12:21 am

Re: How to query the database independently from the game se

#3 Post by Alastair » Fri Jan 20, 2017 11:42 pm

Alex wrote:Which games for the c64 don't have a year, company, author,genre etc
It would make it a lot easier to update the database where needed.
Alex, I can't help with most of the queries but you can sort search results tables by year simply by clicking on 'Year' at the top of the year column with a second click reversing the order, as shown in this example for the C64/128.

User avatar
Alex
Posts: 617
Joined: Tue Oct 24, 2006 10:45 pm
Location: Netherlands

Re: How to query the database independently from the game se

#4 Post by Alex » Sat Jan 21, 2017 8:58 pm

Ok the year was a bad example :) as you point out correctly this can be done, but I think Aran's point as well as mine is it would be nice to have some more tools of finding information gaps in the database.

User avatar
Gunness
Site Admin
Posts: 1699
Joined: Tue Dec 07, 2004 7:04 pm
Location: Copenhagen, Denmark
Contact:

Re: How to query the database independently from the game se

#5 Post by Gunness » Tue Jan 24, 2017 4:55 pm

The search routine can't handle such queries - but I'll be happy to do an extract from the database and upload it somewhere appropriate. Then you can filter and sort in Excel, Google Docs or what have you. Would that be an option?

User avatar
Alex
Posts: 617
Joined: Tue Oct 24, 2006 10:45 pm
Location: Netherlands

Re: How to query the database independently from the game se

#6 Post by Alex » Thu Jan 26, 2017 5:47 pm

It would be for me, but don't hurry because soon I'll be off in search of some inca ruins :) but after Easter it would be fine.

iamaran
Posts: 42
Joined: Tue Apr 06, 2010 9:01 pm

Re: How to query the database independently from the game se

#7 Post by iamaran » Sun Jan 29, 2017 4:46 pm

Yes, that would be good as a one-off. Whichever format is easiest for you is fine for me.

User avatar
Gunness
Site Admin
Posts: 1699
Joined: Tue Dec 07, 2004 7:04 pm
Location: Copenhagen, Denmark
Contact:

Re: How to query the database independently from the game se

#8 Post by Gunness » Mon Jan 30, 2017 10:18 am

Alex wrote:It would be for me, but don't hurry because soon I'll be off in search of some inca ruins :) but after Easter it would be fine.
Oh but you can't - there are 320 entries in the queue and as you know, you're not allowed to go off on irregular activities until such entries have been removed!

.... but have a nice trip anyway :D

User avatar
Alex
Posts: 617
Joined: Tue Oct 24, 2006 10:45 pm
Location: Netherlands

Re: How to query the database independently from the game se

#9 Post by Alex » Tue Jan 31, 2017 7:49 pm

Gunness wrote: you're not allowed to go off on irregular activities until such entries have been removed!
Luckily trekking through Bolivia isn't an irregular activity for me :lol:
Thank you, but I'm still around for a few more weeks, just very occupied in the ultimate preparations.

Post Reply