Tuple of strings to sqlite column

Question

How would you insert a tuple of strings to a sql column? At the moment I concatenate the strings in the tuple with a token and then when I read out the value again I split on this token.

John Gaines Jr. · Accepted Answer · 2012-04-20 15:32:38Z

1

Or you could use the pickle (or cPickle) module, it's probably easier than rolling your own code:

import pickle

my_tuple = ('one', 'two', 'three')
pickle.dumps(my_tuple)  # <-- insert that into DB

to read it out, just pull the string out of the DB and call:

my_reconstituted_tuple = pickle.loads(data_from_db)

answered Apr 20, 2012 at 15:32

John Gaines Jr.

11.6k1 gold badge28 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Tuple of strings to sqlite column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related