search

little-brother / sqlite-gui

Lightweight SQLite editor for Windows
GNU General Public License v2.0
1.07k stars 51 forks source link

No Way to open temp-file '' (ie, empty filename) or :memory: database #139

Closed kmedcalf closed 1 year ago

kmedcalf commented 1 year ago

There is no way to open (or attach) a tempfile (filename is empty string) or :memory: (filename is the magical name :memory:) database. Can an option be added to allow a "database name specified as a string without a gui selection box" be added?

That is, an "open database" that simply accepts and passes any string (including an empty one) and an "attach" that does the same thing?

little-brother commented 1 year ago

You can open an in-memory database by "New/Open" holding Ctrl (you can find it in Main Menu > ? > Tips). I think the same way to attach an in-memory database will be OK.

Also the app already has attached in-memory database TEMP2. You can choose it in the dropdown menu изображение

kmedcalf commented 1 year ago

It is shift and it only works for open. What if I want to open a file using the non-default vfs? There is no way to enter a name that is not a file in the dialog box.

little-brother commented 1 year ago

I have never worked with vfs. I have read VFS-doc and it looks like it will be easy to add support for other vfs. The main issue is I don't know how to test it properly. There are several demo vfs but only appendvfs.c works for me.

little-brother commented 1 year ago

Added a special dialog. Hold Shift when choosing Open or Attach.