python using pickled objects with sqlite

Question

I have a large object that is fairly dynamic that I want to serialize and store in my sqlite database. Using the pickle module, I made it into a string but found I had to do a string replace on it to change the single quotes out in order to store it to the db. When I take it out, I just undo that. I am new to using pickle and sqlite and this at least works, but is this really the right way to go about it or is there a correct way to handle this that I am not seeing?

menu = pickle.dumps(menuOb)
menu = menu.replace("'", "''")
#sql statement stuff

Martijn Pieters · Accepted Answer · 2013-04-19 15:59:29Z

2

Don't replace any characters, just insert with a SQL parameter:

cursor.execute('INSERT INTO sometable VALUES (?, ?)', (id, pickle.dumps(menuOb))

SQL parameters take care of correct quoting for you.

answered Apr 19, 2013 at 15:59

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

1 Comment

Dave_750 Over a year ago

Thanks for the answer, I am definitely a SQL noob. What I was doing just seemed silly and this makes a lot more sense.

Collectives™ on Stack Overflow

python using pickled objects with 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