R in-memory database consumes ZERO memory. Is it really on disk?
I have been experimenting with creating an in-memory SQLite database in R. I have written a program that suggests that generating an in-memory database, and populating it with a table containing a million real numbers, has ZERO effect on the amount of memory consumed by R. In turn, this leads me to suspect that the so-called “in-memory” database is bogus and is really stored on disk. I attach the program that leads me to this conclusion.