Which apps read/write an SQLite 3 database in Ubuntu?

Question

Have an app on another device which exports an SQLite v3 database. I wish to read and alter the content of that .db file. Tried Libre Office Base, no joy. Which apps will read that .db file, and edit it? Hoping for a GUI app.

Editing an SQLite3 .db file requires knowing the SQL to make changes to the sqlite3 database anyways even with apps that can read the file - is there a reason you don't use the command line sqlite3 program to do that? — Thomas Ward, Dec 26 '14 at 07:58
LibreOffice should work with Sqlite though... This will work on LO too: https://wiki.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org — Rinzwind, Dec 27 '14 at 13:36

score 17 · Accepted Answer · answered Feb 02 '17 at 18:43

Try DB Browser for SQLite. From the site:

DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

It is for users and developers wanting to create databases, search, and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands.

Controls and wizards are available for users to:

Create and compact database files

Create, define, modify and delete tables

Create, define and delete indexes

Browse, edit, add and delete records

Search records

Import and export records as text

Import and export tables from/to CSV files

Import and export databases from/to SQL dump files

Issue SQL queries and inspect the results

Examine a log of all SQL commands issued by the application

Install with sudo apt install sqlitebrowser

I'd like to add you call DB Browser for SQLite from the command line by typing sqlitebrowser. I think the command name is for historical reasons. — WinEunuuchs2Unix, May 27 '21 at 01:45

Thomas Ward · Answer 2 · 2018-07-25T18:18:16.737

5

There is an application in the repositories for Ubuntu versions before 18.04 called sqliteman. It is listed in those repositories as "GUI tool for SQLite3 admin and developers alike".

I haven't used it much but it seems like it's a readily available GUI tool in the repositories. If you are using a version of Ubuntu earlier than 18.04, you can install it with apt-get install sqliteman.

edited Jul 25 '18 at 18:18

answered Dec 27 '14 at 16:31

Thomas Ward

74,764

No longer available as of Bionic. – Jul 24 '18 at 16:12
Confirmed at https://packages.ubuntu.com/bionic/database/ – K7AAY Jul 25 '18 at 17:54
1

@K7AAY This answer could still have worked for non-18.04 users - remember 16.04 and 14.04 are still alive, so you need to keep that in mind. I would have left the apt-get lines in there rather than just yank it out, while making a note this only works for versions earlier than 18.04. (Remember also this answer was written almost 4 years ago, so you have to keep in mind the historical aspect of the answer too) – Thomas Ward Jul 25 '18 at 18:17
@K7AAY while at the same time making something that was an answer no longer an answer. I've done some revisions to the original message that preserve the original content but add that this only works for earlier verisons before 18.04. (If you edit an answer and remove the bits that make it a full standalone answer you make a historic answer no longer an answer - versus just editing the answer to indicate that the command only works for versions earlier than 18.04 which preserves the original answer but clarifies it doesn't work for newer Ubuntu versions) – Thomas Ward Jul 25 '18 at 18:25

score 4 · Answer 3 · answered Dec 27 '14 at 13:34

4

A method would be to use mozilla's firefox plugin called sqlite manager:

enter image description here

answered Dec 27 '14 at 13:34

Rinzwind

299,756

2

Support for this is dead as of Firefox quantum; – neuronet Nov 19 '17 at 08:52
1

@neuronet So sad, before Quantum that was my go-to SQLite browser – Csaba Toth May 28 '18 at 04:30

score 2 · Answer 4 · answered Dec 18 '18 at 17:07

2

Take a look at SQLite Studio. Despite it is not available in Ubuntu packages repositories, it works perfectly well on this OS and is free and open-source.

The project is maintained since 2007 (as of 2018). It's multiplatform, feature rich and can be extended by plugins.

Full history is available if you feel like curious.

answered Dec 18 '18 at 17:07

smonff

498

If it doesn't suit your needs, I strongly recommend DataGrip (commercial). – smonff Jul 25 '21 at 13:06

score -1 · Answer 5 · answered Jul 23 '20 at 19:46

Check out Beekeeper Studio. It's MIT licensed, works great with SQLite and can handle MySQL, PSQL, SQL Server as well.

My friend and I built it because we wanted a more modern feeling and easier to use SQL editor that worked for all database types.

I use it every day. Hope others like it too.

Which apps read/write an SQLite 3 database in Ubuntu?

5 Answers5