[Tutor] handling of tabular data

[Danny Yoo]

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:

    http://www.sqlite.org/

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

    http://initd.org/tracker/pysqlite

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

    http://initd.org/pub/software/pysqlite/doc/usage-guide.html


Best of wishes!