Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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.

share|improve this question
    
Have a look here and follow the guide to create your own application launcher. It will then be included on the list so you can select it. –  Bruno Pereira Nov 2 '11 at 6:46
    
@BrunoPereira would you consider adding this as an answer rather than a comment? –  coversnail May 4 '12 at 7:27

2 Answers 2

up vote 2 down vote accepted

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.

share|improve this answer

I just got this to work on 13.04 but I had to use NoDisplay=false.

[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=false

This will add to "right click > open with" and "properties > open with"

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.