Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[exfret]

I'm working on a database for dominion fancards and would love some helpers with the technical aspects. Message me on discord exfret#7014, mention me in the #variants channel of the dominion discord (or, preferably, the subthread I created labeled "fancard database" in that channel), or reply to this topic for more information. 

[BryGuy]

While i'm not on Discord i could help. I'm curious on the data format - why a database and not a spreadsheet?

I already have a spreadsheet with some 322 cards, that are not mine, and another 160 of my own. My columns are: Name, Object (C = card, M = mat, H = Horizontal), Designer (i used user names from this site), Made Date, Quantity (which is important for printing purposes and filtering the data), URL, Card Type, Special. Special houses some particular data like: if overpay is present, if its part of a split pile (to link those cards), or if its "Not in the Supply".

[exfret]

While i'm not on Discord i could help. I'm curious on the data format - why a database and not a spreadsheet?

I already have a spreadsheet with some 322 cards, that are not mine, and another 160 of my own. My columns are: Name, Object (C = card, M = mat, H = Horizontal), Designer (i used user names from this site), Made Date, Quantity (which is important for printing purposes and filtering the data), URL, Card Type, Special. Special houses some particular data like: if overpay is present, if its part of a split pile (to link those cards), or if its "Not in the Supply".

Could you share the spreadsheet perchance? For now, more data is better.

As for why I haven't been doing a spreadsheet, it seems pretty immediately clear to me at least. I mean, for types alone you run into the problem of a many-to-many relationship. Sure, you can have a comma-separated list in the "types" column, but then you have to run a special regex search every time you want something that's a treasure and an attack. And then if you're trying to categorize cards like me, hey, that's another many-to-many relationship, and imagine how big the spreadsheet would be if you have a column for each category! There are many more problems too, but needless to say a spreadsheet is a terrible way to go about this unless you are doing something very simple.

[BryGuy]

Sure i can share, i'm just not sure how. Sending the MS excel file would offer features a table here destroys. I manage data and user access is a big concern. The simpler the format the easier it is for people to get what they want and the easier it is for the programmers too.
I use a spreadsheet since it is very easy to filter the data in MS Excel and find what i want. Thankfully MS Excel has much filter capability. Below is a data dump. Looks like so much got lost. If you know a better way, i can share this, i'm open to try that.

Name      Designer   Made Date   Qty   Where   Type   Special
Blueprint   C   Co0kieL0rd   20160614   10   http://forum.dominionstrategy.com/index.php?topic=15685.msg610452#msg610452   Action   
Tailor   C   kru5h   20161019   10   http://forum.dominionstrategy.com/index.php?topic=16396.0;all   Action   
Way of the Orca   H   BryGuy   20221028   1   my brain   Way   

[exfret]

Not sure that copy-and-paste went well haha. Just upload it to a file sharing website like dropbox or google docs and gimme the link

[BryGuy]

https://docs.google.com/spreadsheets/d/1RM61GHZ2bVUhxPHVxRlHInxyugVJO8VI/edit?usp=sharing&ouid=105167752394217563724&rtpof=true&sd=true

[BryGuy]

Who are the intended users?

Which cards would you include or exclude? Many cards are only text with no art, which are difficult to find in visual searches - include or exclude? Many cards are only an image, which are difficult to find in text searches - include or exclude? There is a whole thread on bad card ideas - include or exclude?

How would this dataset be populated? By users themselves or the administrators?

Maybe a Google Sheets might be a solution. The Card Types could each be in a column populated with True/False.