Compatability - mulling over new feature

feedback, questions and discussion relating to the Complete BBC Games Archive (beta site now open!)
User avatar
pau1ie
Posts: 321
Joined: Thu May 10, 2012 9:48 pm
Location: Bedford

Compatability - mulling over new feature

Postby pau1ie » Tue Nov 14, 2017 4:05 pm

Lee is reading adverts from old magazines and noticed that some games are advertised as Model A compatible. He would like to reflect this in the website, along with games that are incompatible with a model B.

Taking this a step further I think that we could do the following:

Add 3 columns to the game table for compatability with the Model A, Model B, and Master.

I will set all games to:

N (For incompatible) for Model A
Y (For Compatible) for model B
Null (i.e. blank for untested) for Master

Lee will then change the Model B compatibility to N for the few games that only run on a Master, populate Model A compatibility as he finds them, and probably leave the Master field alone (I think he tests on a Model B).

There is a hardware comments field for games which need or benefit from sideways RAM, or need 1770 DFS, etc (It is a free form field) e.g. Astroblaster, so we don't need to drill down anyfurther.

Does anyone have any thoughts on this? Some half formed thoughts are that some games "kind of" work on a Master but with graphics corruption etc, some don't work at all and some work fine, so maybe this should be reflected. Does anyone have a list of Master compatibility? I don't think Lee does.
I'm working on http://bbcmicro.co.uk

joachim
Posts: 114
Joined: Wed Jun 21, 2006 1:20 am

Re: Compatability - mulling over new feature

Postby joachim » Tue Nov 14, 2017 9:27 pm

What will you do if e.g. the original release was Master-incompatible but Mick's disc is Master-compatible? Or some other such combination.

User avatar
leenew
Posts: 3402
Joined: Wed Jul 04, 2012 3:27 pm
Location: Doncaster, Yorkshire

Re: Compatability - mulling over new feature

Postby leenew » Tue Nov 14, 2017 10:32 pm

What would you suggest here joachim?
If this feature gets implemented, my first task will be to add all the Model 'A' games that I find in the old magazines, then highlight the few games we have that don't work on a Model 'B', or REQUIRE a Master.
I would be hoping for help with the 'Master compatible' field...

(My other job at the moment is compiling lists of every game that appeared in the magazines such as Micro User, Electron User, Acorn User, Beebug etc. And cross referencing this with the games we have on the site.
I have recently sent Mick every missing game from Micro User and Acorn Computing... so we have plenty to be getting on with... :D )

Lee

User avatar
sweh
Posts: 1847
Joined: Sat Mar 10, 2012 12:05 pm
Location: New York, New York
Contact:

Re: Compatability - mulling over new feature

Postby sweh » Sat Nov 18, 2017 5:47 pm

Old school would be to use a bitmask:
Works on A
Works on B
Works on Master
Works on Electron

This isn't the database developers view of the world; each bit would be a boolean column instead. A NULL could be '?' for unknown.

This would allow for expansion (Works on Arthur, Works on RiscOS, Works on BeebEm?) as necessary.

If there are two versions of a game (eg the original, and Mick's fixed versions) on the site then each version would have its own flags, but that would depend on how you're storing the game data.
Rgds
Stephen

User avatar
pau1ie
Posts: 321
Joined: Thu May 10, 2012 9:48 pm
Location: Bedford

Re: Compatability - mulling over new feature

Postby pau1ie » Mon Nov 20, 2017 9:06 pm

I suspect I have slightly disappointed Sweh by being a database developer.

Anyway I have made a change. I used Unicode characters to display compatibility. Let me know if you find a device where they don't work, I may have to rethink that part.

Cheers

PaulH
I'm working on http://bbcmicro.co.uk

User avatar
leenew
Posts: 3402
Joined: Wed Jul 04, 2012 3:27 pm
Location: Doncaster, Yorkshire

Re: Compatability - mulling over new feature

Postby leenew » Mon Nov 20, 2017 9:49 pm

Cheers Paul,
I will have a go at populating all the games that were advertised as being compatible with the Model A tomorrow.
I will use this list that I came up with: viewtopic.php?f=1&t=13982&p=186214&hilit=16k#p186130

Lee.

User avatar
sweh
Posts: 1847
Joined: Sat Mar 10, 2012 12:05 pm
Location: New York, New York
Contact:

Re: Compatability - mulling over new feature

Postby sweh » Tue Nov 21, 2017 3:39 am

pau1ie wrote:I suspect I have slightly disappointed Sweh by being a database developer.

Not at all; database dev's typically build multiple columns because it allows them to create efficient select statements. It's a consequence of the technology they use. Old school devs use bitmaps for space efficiency (an 8bit integer can store 8 booleans).

If you're a C programmer then "if (field && MASK_DATA1) {...}" is a common paradigm. If you're a SQL programmer than "SELECT ... WHERE data1 is TRUE" is common.

Different technologies, different solutions.

But in both cases, multiple flags is how I would have solved the problem :-)
Rgds
Stephen


Return to “bbcmicro.co.uk”

Who is online

Users browsing this forum: No registered users and 1 guest