Skip to content

Support creating in-memory db on SQL file import #1765

Open

Description

@jsejcksn

Describe the new feature

(When no db is open)

File > Import... > Database from SQL file...

should present the option to create an in-memory database in addition to creating a file on storage.

Additional info

Please answer these questions before submitting your feature request.

Is your feature request related to an issue? Please include the issue number.

No

Does this feature exist in another product or project? Please provide a link.

N/A

Do you have a screenshot? Please add screenshots to help explain your idea.

N/A

Activity

  1. justinclift commented on Feb 24, 2019

    @justinclift
    Member

    Thanks @jsejcksn, seems like a reasonable idea. 😄

  2. FlippieCoetser commented on Nov 10, 2019

    @FlippieCoetser

    Creating a new In-memory database is possible, but connecting to an existing In-Memory Database not. It will be great have support for In-Memory DB.

  3. justinclift commented on Nov 10, 2019

    @justinclift
    Member

    When you say "existing in-memory database" are you meaning one created by another program?

    If so, that's not possible. It's a limitation of SQLite itself, in that it can only connect to an in-memory database created by itself.

  4. FlippieCoetser commented on Nov 10, 2019

    @FlippieCoetser

    @jsejcksn I noticed a shared cache option in the documentation: https://www.sqlite.org/inmemorydb.html.

    Here is my use-case:
    I use an In-memory Sqlite for XUnit tests in Visual Studio. I can easily debug my tests but I have no way to look at the DB Table, Columns and data created during running the unit test. any suggestion?

  5. jsejcksn commented on Nov 10, 2019

    @jsejcksn
    Author

    @FlippieCoetser Just use an on-disk database instead of an in-memory one and delete it when you’re done.

  6. justinclift commented on Nov 11, 2019

    @justinclift
    Member

    @FlippieCoetser That shared cache option is still for databases connections internal to a single program. It's what the documentation means a bit further down where it says:

    Of course, all database connections sharing the in-memory database need to be in the same process.

  7. justinclift commented on May 18, 2020

    @justinclift
    Member

    Following up on this (way overdue!)... there's now an option in the File menu to create a new in-memory database. It's present in the 3.12.x series releases (which is only 3.12.0-alpha1 so far), and has been in our nightly builds for a while now too. 😄

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions