SQLite : "Files of this type cannot be opened in DataGrip"
Hello,
I would like to open my SQLite databases in DataGrip.
They are created by standard Android applications and work fine with other applications such as SQLite Browser.
However, when I try to open them in DataGrip, I have the following error: "Files of this type cannot be opened in DataGrip".
Do they need to have a special extension or something like?
Thanks.
(I'm using the Mac version of DataGrip)
Please sign in to leave a comment.
Hello,
SQLite Data Source is supported. Please check https://www.jetbrains.com/datagrip/help/managing-data-sources.html#creating_db_by_drag_and_drop on how you cad add it to DataGrip.
That does nothing....
I have a database named "Test.db3"...it works fine with other SQLIte management tools ....
I am evaluating DataGrip so hopefully this is not a showstopper.
Thanks
The database was created using the SQLite ORM in VS2015 and Windows 10 and the SQLite DLL version is 3.9.2
How exactly are you opening the file? Please check https://youtrack.jetbrains.com/issue/DBE-2157 . Does it help to create a datasource, using URL https://www.jetbrains.com/help/datagrip/1.0/working-with-the-database-tool-window.html?origin=old_help#create_data_source
Andrey, I figured it out this morning ....
It's not clear that you FIRST have to make a project and then add the connection to the project.
I was simply trying to open the SQLite database to run some queries against it and it does not do that.
Stephen