Connecting to in memory sqlite database #171
Replies: 2 comments
-
Hi @fearcon-eap , we only support connect to sqlite on disk files for now. Will take a look at this feature. Thanks for the suggestion! |
Beta Was this translation helpful? Give feedback.
-
Hi @fearcon-eap , sorry for the delayed reply. I checked sqlite in-memory database and it seems like "in-memory" database's life time is the same with the connection:
However, in connectorx we establish our own connection and do not hold it after return the data. We also only support select query instead of execution (e.g. create table, insert values). So it seems like there is no use case for us supporting sqlite's "in-memory" database. Please feel free to let us know if you have other thoughts or suggestions on this feature! |
Beta Was this translation helpful? Give feedback.
-
Hey,
is there a way to connect to an "in-memory" sqlite database?
Something in the likes of:
source = sqlite3.connect(':memory:')
Beta Was this translation helpful? Give feedback.
All reactions