[Tutor] handling of tabular data

Danny Yoo dyoo at hkn.eecs.berkeley.edu
Mon Oct 10 22:19:21 CEST 2005

On Sun, 9 Oct 2005, [ISO-8859-1] Frank Hoffsümmer wrote:

> thanks for your answers looks like SQL is the ticket for such
> problems... because my data is updated quite often, it feels like an
> 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?

Hi Frank,

Try looking at:


It should be fairly easy to install, and comes with Python bindings:


The tutorial shows how to build an in-memory database (Example 2 of
Chapter 2):


Best of wishes!

More information about the Tutor mailing list