text file vs. cPickle vs sqlite a design question

Bruno Desthuilliers bdesth.quelquechose at free.quelquepart.fr
Thu Apr 12 00:36:04 CEST 2007

Dag a écrit :
> I have an application which works with lists of tuples of the form
> (id_nr,'text','more text',1 or 0).  I'll have maybe 20-50 or so of these 
> lists containing anywhere from 3 to over 30000 tuples.  The actions I
> need to do is either append a new tuple to the end of the list, display 
> all the tuples or display all the tuples where the last element is a 1
> Basically what I'm wondering is the best way to store these data stuctures 
> to disc.  As the subject mentioned I've basically got three approaches.
> Store each list as a text file, pickle each list to file or shove the
> whole thing into a bunch of database tables.  I can see pros and cons
> with each approach.  Does anybody have any advice as to whether any of
> these approaches is obviously better than any other?  

Seems that so far, you get as many different opinion as answers - not 
sure this will help much :-/

More information about the Python-list mailing list