Database in memory

Travis Oliphant oliphant.travis at ieee.org
Mon Apr 9 13:08:28 EDT 2007


Jim wrote:
> I have an application that will maintain an in-memory database in the
> form of a list of lists.  Does anyone know of a way to search for and
> retreive "records" from such a structure?
> 

Actually, the new NumPy can work as a very-good fast and efficient 
simple in-memory database (or memory-mapped data-base for that matter).

The elements of a NumPy array can be arbitrary records.  You would 
search using logical combinations of comparision.   I think the ability 
for NumPy (which now handles arbitrary records) to be used as a 
data-base is under-appreciated.

Mind you, it is SQL-less.  NumPy only provides the "tables" it does not 
provide the fancy logic on-top of the tables.  So, perhaps it would be 
better to say that NumPy could serve as the foundation for a simple 
data-base application.

-Travis




More information about the Python-list mailing list