Thursday, May 2, 2024
 Popular · Latest · Hot · Upcoming
2
rated 0 times [  2] [ 0]  / answers: 1 / hits: 3019  / 3 Years ago, fri, november 5, 2021, 7:53:37

When I try to open a .sqlite3 file, I get the following error:



There is no application installed for SQLite3 database files


When trying to select a default application, the SQLite database browser is not listed, despite it being installed.



Also, because the .sqlite3 file does not have a default application, it does not show up in the File Browser within gedit, making things pretty confusing.



How do I set up the default application?



I am running Ubuntu 11.10.


More From » 11.10

 Answers
0

As mention by Bruno Pereira in a comment on your question you need to create an application launcher for SQlite Database Browser.



To do this open a text editor such as Gedit and create a text document with the following contents:



[Desktop Entry]
Encoding=UTF-8
Name=SQLite Database Browser
Comment=Create, Edit and Modify SQLite database files
Exec=sqlitebrowser %u
Terminal=false
Type=Application
StartupNotify=true
MimeType=text/plain;
NoDisplay=true


Once you have done this name the file sqlitebrowser.desktop and save the file to ~/.local/share/applications



Once you have done this navigate to a .sqlite3 and right click on it, select Open with Other Application



enter image description here



Then select Show other applications and scroll down to select SQlite database Browser from the list and it'll now be the default application to open .sqlite files.


[#42370] Sunday, November 7, 2021, 3 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
olouredping

Total Points: 259
Total Questions: 100
Total Answers: 121

Location: New Caledonia
Member since Wed, Sep 15, 2021
3 Years ago
olouredping questions
;