Support :memory: or temporary databases #1492
Comments
|
Yeah. People have mentioned this a few times, and I personally tend to agree with you. As long as it's easy to implement that is, and I reckon it probably would be. 😄 |
Add a new menu option for opening an in-memory database. When working on an in-memory database some menu options are disabled because they only make sense when the database is also written to disk. I have left the Write Changes button enabled though because for some actions the current transaction needs to be committed - even though it's only committed to memory then. See issues #335 and #1492.
|
I've just added a new menu option for this. Can you give tomorrow's nightly build a try (if you're on Windows or MacOS), @voltagex? 😄 I tried to tweak the code to handle the side effects this might have but maybe I have missed something 😉 |
|
After a very brief check this seems to work as expected. |
|
Thanks for checking, @voltagex! 😄 I'll close this issue then - if you should notice any problems with this in the future you can always open a new issue or reopen this one. |
|
@MKleusberg what about linux? |
|
@jossnaz For Linux, depending on your distribution you have a few options. 😄
Building it yourself is generally not too hard, but there is an occasional gotcha so YMMV. Does that help? 😄 |
|
@justinclift the nightly build will contain as well the in :memory: access? i'm not sure how this project is built or if there are different versions for linux and windows. |
|
All of our nightly builds (regardless of OS), are done from our Sometimes the development branch is a bit flaky (eg just after we've added new features), but most of the time it's pretty good. It should be reasonable about now. 😄 |
|
@justinclift thaaanks justin <3 |
|
No worries. 😄 |
|
@justinclift maybe that information about nightly builds for Linux should be added to https://nightlies.sqlitebrowser.org/latest/%2A%20README.txt too. |
|
Good thinking @mgrojo. 😄 Just cut-n-pasted the above text into a new "Linux" piece on the bottom of that. Should be good enough to start with. |
Describe the new feature
Supporting a temporary database or the :memory: connection would be helpful when I just need to check something and don't actually need to persist changes.
Additional info
Please answer these questions before submitting your feature request.
Is your feature request related to an issue? Please include the issue number.
Does this feature exist in another product or project? Please provide a link.
https://www.sqlite.org/inmemorydb.html
DataGrip - but it's got its own issues with this
Do you have a screenshot? Please add screenshots to help explain your idea.
The text was updated successfully, but these errors were encountered: