54

I'm looking for a SQLite graphical administration utility for Linux but I can't seem to find any (I found an extension for Firefox I'm not a user of that browser).

Is there any that you know of?

Improve this question
0
52

Tried Sqliteman? Look for sqliteman in your package manager. It is stable, so should be broadly available.

Improve this answer
4
  • Can confirm - it's simple and effective. – a coder Sep 16 '14 at 19:27
  • On Fedora 21 I could just run: yum install sqliteman – Raptor Jun 16 '16 at 6:13
  • for long text fields, it's bad. Much better alternative is sqlitebrowser (see below) – luca76 Mar 5 '18 at 10:59
  • 1
    It's not actively supported anymore... – MarcoS Apr 24 '19 at 8:13
45

I've been using sqlitebrowser, it is a really good options. Though probably not the only one!

On Ubuntu, it is available in the default package repositores.

Improve this answer
1
  • 1
    Thank you, SQLite Database Browser seems good too, I'll give both a try. – Jimmy May 14 '12 at 11:19
9

I've used the SQLiteStudio for working with sqlite3 database. It looks very well.

The project is maintained (as of 2018). For some reason it is not available in common packages repositories.

Improve this answer
1
  • Downloaded to Debian 10, extracted, ran. Works. 👍 – Heinrich Ulbricht Oct 26 '19 at 19:50
3

You can use for this purpose Valentina http://www.valentina-db.com/valentina-studio-overview, the program is free. It works on 3 OS: LIN, MAC, WIN. It works as with mySQL/mariaDB, so with PostgreSQL, SQLite and Valentina DB.

Improve this answer
2
  • 2
    Welcome to Unix & Linux! Generally we like answers on the site to be able to stand on their own - Links are great, but if that link ever breaks the answer should have enough information to still be helpful. Please consider editing your answer to include more detail. See the FAQ for more info. – slm♦ Apr 8 '13 at 11:02
  • 1
    Just to add: free, but not open source. The pro version is $199, and adds "Report Editor, Digram Editor, SQL Diff Wizard, Query Builder". (The free version seems to have just about everything else you'd normally need, though, and working with multiple DB engines is useful.) – Darren Cook Jul 13 '14 at 18:58
3

I have not used this yet but looks promising especially if you're looking for a web-based interface.

phpLiteAdmin

Improve this answer
3

You can try Sqlite Manager Firefox Add-on.

Improve this answer
1
  • Not maintained anymore – smonff Dec 18 '18 at 16:53
3

A friend and I made Beekeeper Studio because we wanted a modern, easy to use SQL gui client. I'm a full time Linux desktop user, so we care about Linux.

It's 100% open source! Hope someone finds it as useful as I do. Oh, it supports sqlite, MySQL, psql, etc.

enter link description here

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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