Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #84026
| 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) |
> 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
Re: Hashed lookups for tabular data "Joseph L. Casale" <jcasale@activenetwerx.com> - 2015-01-19 18:59 +0000
csiph-web