Re: [Fpdb-main] New importer and mixed support

[Carl G. <car...@gm...>]

Hands:
> # players vpiping or seeing flop (or both)
> max seats
> bool flop/no flop
> bool preflop raised
> bool preflop 3bet
> bool preflop 4 bet
> same for other streets? other streets are less useful
> # players seeing showdown (all streets?)
> final pot size
> rake/mgr
> board cards

maxSeats is already there.

What would board cards look like for stud and draw games?

> Things I would like to see in HandsPlayers:
>
> bools for about everything in HudCache
> hand name (e.g., AKo) -- think about this for other games
> hand strength -- like a Sklansky group or top x%
> actual cards

I've been thinking about that currently we have:
| card1Value | card1Suit | card2Value | card2Suit |....

Which is seems less than optimal for analysis. Most of the code i've
seen for cards uses 1-52 to explicitly state the card, or a 52 bit
binary number. I'd like to merge them into card1, card2 etc. I think
we should use the accumulated wisdom of other projects on this.

> position (as spots from button or BI)
> bool for big blind
> bool for small blind
> net won/lost

Change winnings to accept a negative value then?

> We need to think about draw games. Something like # cards taken on each
> draw might be good.

Works for me.

What about stud - bringIn perhaps?

> We should think about the stats that the closed-source trackers are
> keeping and think about those stats, too.
>
> We can add all the columns to the db tables in a big bang along with the
> required stats. We could then populate the more optional stats as we go.

Immediately after the next release?

Carl G