> overhead for me to store the data persistently, because then I would > have to manage updates to individual rows and columns right now, I > simply construct the latest version of my data table from my source > data, whenever the script is run this is also the reason why I am using > python in the first place: to extract the data of interest from other > (non-SQL) sources and then create that data table as the basis for my > queries. does python have a simple build in SQL engine that would allow > for the creation of a throw-away, in-memory table that I could then > query with SQL?
You could look at the database topic in my tutor which both gives an intro to SQL and how to use it from Python with the sqlite database. It really is pretty easy once you adjust to the SQL mindset. Alan G Author of the learn to program web tutor http://www.freenetpages.co.uk/hp/alan.gauld _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor