Array storage in SQLite

Question

I need to store a set of scores in integer (array of scores) for a player. How can I store an array in a single column? I'm using the SQLite database.

stimms · Accepted Answer · 2009-11-26 05:07:42Z

4

Please don't store multiple values in a single column, it makes for much harder queries. You're best to put in another table with a foreign key back to your first table.

   Table 1
    playerID
    playerName

   Table 2
    scoreID
    playerID
    score

Add multiple rows into table 2 and have the playerID in the second table reference playerID in the first table.

answered Nov 26, 2009 at 5:07

stimms

44.3k31 gold badges103 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ataulm Over a year ago

Thanks Stimms, this is what I was looking for also, but to store long values (multiple dates)

Collectives™ on Stack Overflow

Array storage in SQLite

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related