Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #84026 > unrolled thread
| Started by | "Joseph L. Casale" <jcasale@activenetwerx.com> |
|---|---|
| First post | 2015-01-19 18:59 +0000 |
| Last post | 2015-01-19 18:59 +0000 |
| Articles | 1 — 1 participant |
Back to article view | Back to comp.lang.python
This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by
below is the oldest one visible, not the original post.
Re: Hashed lookups for tabular data "Joseph L. Casale" <jcasale@activenetwerx.com> - 2015-01-19 18:59 +0000
| From | "Joseph L. Casale" <jcasale@activenetwerx.com> |
|---|---|
| Date | 2015-01-19 18:59 +0000 |
| Subject | Re: Hashed lookups for tabular data |
| Message-ID | <mailman.17861.1421693993.18130.python-list@python.org> |
> 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 top | Article view | comp.lang.python
csiph-web