In-Memory DB question

Databases
1

Can a MemoryBlock of a very small SQLite database file become an In-Memory SQLite database or does it need to go to disk first?
TIA

2

theres no means to convert a memoryblock into an in memory sqlite database

best I think you could do is

  1. write then mb to disk
  2. have an in memory db attach to that file opened as a db
  3. copy the data from the attached db into the original in memory one
  4. detach from the one on disk
3

Thanks, didn’t think so but always worth asking :slight_smile:

4

Its an interesting thought
Theres no such API in SQLite itself that I know of that would make it possible to do such a thing