Open Sparrow0hawk opened 4 months ago
This looks weird, because :memory:
is not a file. Is this actually valid or suggested syntax?
There are examples on SQLite docs of using :memory:
as a URI filename with the syntax file::memory:
so I believe it is an accepted syntax.
Outline
When using the SQLite URI filename format for an in memory database
sqlite:///file::memory:?uri=true
Flask-SQLAlchemy still creates a database file on disk.MRE
You can replicate this behaviour locally with the following code:
If you start the app with
flask run --debug
you'll find you have aninstance/:memory:
file on disk.Expected behaviour
Running the above snippet does not produce a file on disk.
Environment: