3M rows, 70M relationships? Sounds like it could fit in a hash table in memory i... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		lsb on June 15, 2010 \| parent \| context \| favorite \| on: Using SQLite for great science, part 1 (or 3, I gu... 3M rows, 70M relationships? Sounds like it could fit in a hash table in memory in your programming language of choice.

gaius on June 15, 2010 | [–]

You can use :memory as a filename for SQLite and that's just what it'll do. Of course if it's in your OSs filesystem cache then it is in memory even if it's on disk.

Or you can roll your own and write your own query language too...

regularfry on June 15, 2010 | [–]

Sure. Then you've got to persist it.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact