search

penberg / limbo

Limbo is a work-in-progress, in-process OLTP database management system, compatible with SQLite.
MIT License
945 stars 52 forks source link

In-memory mode #53

Open penberg opened 2 months ago

penberg commented 2 months ago

Add support for in-memory mode like SQLite has because it's great for just playing around with a database.

jatin510 commented 2 months ago

hey @penberg . I would love to work on this task.

penberg commented 1 month ago

Hey @jatin510, feel free, although I think it's more rewarding to do this when we support writes (#45) because then you can actually do something in-memory.

jatin510 commented 1 month ago

Sure, I will start working on this issue. Once we will start support writes.

sitano commented 1 month ago

~I am not sure, maybe it could implement live read-only access to the existing sqlite3 instances via Shared Cache mode. https://www.sqlite.org/sharedcache.html~. Seems like it is only in-process cross-thread infra.

penberg commented 1 month ago

There is now experimental write path as of 01ec5f5e6472e0b7f752e1a3e47e560a19f34c42 so now an in-memory I/O is something that makes more sense. Probably needs CREATE TABLE support (#146) first to be useful.