Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #84026

Re: Hashed lookups for tabular data

From "Joseph L. Casale" <jcasale@activenetwerx.com>
Subject Re: Hashed lookups for tabular data
Date 2015-01-19 18:59 +0000
References <84c6e1d5671842038e81994478fb5476@exch.activenetwerx.com> <CAPTjJmr1YXTXGi+YE0yjUxgdoy2iOWDq_th4u6ghiQ+QOouNvg@mail.gmail.com> <8761c2k6m8.fsf@mercury.locationd.net>
Newsgroups comp.lang.python
Message-ID <mailman.17861.1421693993.18130.python-list@python.org> (permalink)

Show all headers | View raw


> If you want an sql-like interface, you can simply create an in-memory
> sqlite3 database.
> 
>  import sqlite3
>  db = sqlite3.Connection(':memory:')
> 
> You can create indexes as you need, and query using SQL.  Later, if you
> find the data getting too big to fit in memory, you can switch to using
> an on-disk database instead without significant changes to the code.

Hey kushal,
For the effort it would take, I'll add an implementation using this this
when I start profiling for the sake of curiosity.

Thanks,
jlc

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread


Thread

Re: Hashed lookups for tabular data "Joseph L. Casale" <jcasale@activenetwerx.com> - 2015-01-19 18:59 +0000

csiph-web