3 ms·
You can use the memvfs module to load in-memory databases if you're using the C API. I'm not sure how many higher-level APIs support it though. [1] https://sta
by palotasb 7y ago
You can use the memvfs module to load in-memory databases if you're using the C API. I'm not sure how many higher-level APIs support it though.
[1] https://stackoverflow.com/a/53453338/3063 https://stackoverflow.com/a/53453338/3063
[2] https://www.sqlite.org/loadext.html#example_extensions https://www.sqlite.org/loadext.html#example_extensions
[3] https://www.sqlite.org/src/file/ext/misc/memvfs.c https://www.sqlite.org/src/file/ext/misc/memvfs.c
- rakoo 7y agoA very interesting approach is sqltorrent (https://github.com/bittorrent/sqltorrent https://github.com/bittorrent/sqltorrent): the sqlite file is shared in a torrent, and all queries will touch a specific part of the file, which is downloaded on-demand. Also check https://github.com/lmatteis/torrent-net https://github.com/lmatteis/torrent-net
- kevas 7y agoIncredibly odd, but so awesome