SQLiteStudio is a SQLite database manager with the following features:. Portable - no need to install or uninstall. Just download, unpack and run. Intuitive interface. Additionally,.db files are database files created in popular lightweight database SQLite. The.db files can be created by several applications including Firefox, Google Chrome, Opera and other apps to store information.
Active3 years, 7 months ago
There are quite a few Sqlite GUI applications listed here:
some appear to be incomplete, buggy, not maintained, etc. Do you have any recommendations?
P a u lP a u l4,15214 gold badges51 silver badges87 bronze badges
closed as off-topic by ChrisF♦Oct 24 '13 at 12:07
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.' – ChrisF
16 Answers
I use the SQLite manager plugin for Firefox.
It seems pretty stable to me.
John Sheehan65.6k26 gold badges151 silver badges186 bronze badges
Fortyrunner![Browser Browser](/uploads/1/3/3/4/133401491/306710675.png)
10.9k3 gold badges27 silver badges51 bronze badges
Here's another free option. It has been pretty stable for me. SQLiteStudio
Travis CollinsTravis Collins3,0942 gold badges24 silver badges41 bronze badges
For Windows: I've been looking for functionality and a comfortable GUI - it's been particularly hard to satisfy the latter requirement, but these two picks are both fine:
a) Good enough:SQLite Expert
Tableau reader for mac. Less expensive, fully featured manager. The author is very responsive to comments and bug reports, and publishes updates frequently. The flip side, if you look at version history, is that new releases seem to introduce new bugs, which are then fixed in sunsequent builds. The GUI is fine, very good for quickly designing new databases; a little less so for designing queries and working with large amounts of data. Main gripe: you can't see the schema while editing a query (without flipping tabs in the program).
b) Nearly perfect:SQLite Maestro
Pricier. Rich UI, easy access to all features, nice visual query builder and automatic SQL formatter for readability, lots of eye candy. There is a separate, more specialized query builder (SQLite Code Factory), but you can make do with just the main Maestro application. Main gripe: can't seem to be able to change font size for table display and the default is a little too small; at the beginning it's easy to get lost in the thicket of tabs, though overall I find the GUI very productive.
Both solutions are very stable in my experience, and both seem to offer occasional discounts, if you can afford to wait.
For just browsing data, try SQLite Spy - free and lets you execture queries, but no or little GUI support for editing. Very convenient for quick lookups though.
Marek JedlińskiMarek Jedliński3,8589 gold badges36 silver badges53 bronze badges
Spent the morning looking for a good Sqlite Database Manager/Browser and have settled on SqliteStudio, currently v2.20.28, which I'm running on Ubuntu Linux 10.04.
- The download is one 4.3MB uncompressed executable file. Period!
- It's fast, well-behaved, and uses modest resources.
- The interface is clean and attractive with logical functionality.
- I don't say this often, but it's just a 'A Joy to Use'.
- It was developed and is actively maintained by Pawel Salawa who is is to be commended for producing a very nice program.
I just used it to merge two Firefox FloatNotes databases (Sqlite v3), which just use a single table..
- The target database is on the local host where SqliteStudio is running (i.e. /0/LX02)
- The source database file is on a remote host mounted via SSHFS to /0/LX04
- Opened the two database files using Add Database.
- Used the SQL Editor to execute an INSERT to the LX02 database from a SELECT on the LX04.
- Click the Commit icon when all goes well or Rollback if there are errors to fix.
- Refresh the table data to see the inserted rows.
There's no Import GUI functionality but merging is pretty simple if you know SQL. I supplied NULL for the first column which is the unique-id primary-key so that Sqlite would autoincrement, thus renumbering the rows being merged in..
DocSalvagerDocSalvager
John SheehanJohn Sheehan65.6k26 gold badges151 silver badges186 bronze badges
bluebrotherbluebrother7,4301 gold badge16 silver badges20 bronze badges
Lukas Cenovsky4,1722 gold badges23 silver badges38 bronze badges
Orhan CinarOrhan Cinar7,6152 gold badges29 silver badges46 bronze badges
Sqlite.org has a list of management tools available here:
SandySandy5881 gold badge13 silver badges28 bronze badges
I've been using SQLite Professional and it's been reliable. The only downside was that changes I made to the db via the iOS simulator didn't resolve in the app (I had to close it and reopen for changes to show) but that feature was added in a recent version. So now it does everything I need. I'm happy with the support. It's good for testing and I use it to build out the db structure. Never been buggy.
mollymoranmollymoran
If your using OSX you may like SQLPro for SQLite (App Store). Dwg reader for mac free.
The app has a few neat features such as:
- Versions Integration (rollback to previous versions).
- Inline data filtering.
- Exporting options to CSV, JSON, XML and MySQL.
- Column reordering.
- Full screen support.
8,31924 gold badges117 silver badges219 bronze badges
I've been using SQL Explorer. The firefox plugin is awesome, but it couldn't handle BIGINTs properly (it truncated them). I have noticed that the .jar driver doesn't seem to support FTS4 (but it does support FTS3) and doesn't show indexes in the data structure.
I like SQL explorer as you can use other providers like mySQL too with the one client.
E-reader For Mac
Matt C![Mac Mac](/uploads/1/3/3/4/133401491/456820524.jpg)
1981 gold badge3 silver badges15 bronze badges
You didn't mention a platform, so here's a great comparison of Mac OS X SQLite tools. I personally found MesaSQLite to be most like my preference for database tools, which was CocoaMySQL incidentally. (For Windows, I just used the Firefox add-on mentioned above.)
bbrownbbrown5,5625 gold badges33 silver badges41 bronze badges
If you're within Visual Studio most of the time then System.Data.SQLite is good, and as a plus handles encrypted databases.
RoryRory25.8k42 gold badges138 silver badges215 bronze badges
Sqlite Database Reader For Mac
Navicat SQLite is very good and they support Windows, OS X and Linux too.
gotomannersgotomanners6,4151 gold badge18 silver badges36 bronze badges
You might want to check MYZSQLExplorer, here.
Unlike the other tools, it is running on iOS devices (or in the simulator). It is a Viewer, not a management tool, and is not as feature-complete as some of the other tools, but is convenient as you can launch it from within your code and browse your databse from within your app.
Or you can 'Open In..' it sqlite stores, by sending them as email attachments.
I developed it in order to help myself during the development and testing phases, and it did help.
If you have any feedback on it, I'd love to hear it.
meizymeizy
Best Sqlite Editor For Mac
If you want just CRUD operations on the sqlite database file, then SQuirreL is a very option as it has an auto complete feature which drastically improve the speed and efficiency of typing the sql queries.
To use the SQLite database in SQuirreL first download the JDBC driver of the SQLite from here then drop the jar in the lib folder of the SQuirreL folder. Now open SQuirreL and choose Create a New Driver.In the Example URL field put
jdbc:sqlite:$file_url
and in Class Name put
https://newuber407.weebly.com/blog/latest-version-of-pdf-reader-free-download-for-mac. org.sqlite.JDBC
After that choose Create a New Alias and choose the driver that you just added and replace $file_url with the actual location of the sqlite file then click ok and you are done.
ThunderThunder2,2561 gold badge18 silver badges14 bronze badges
Not the answer you're looking for? Browse other questions tagged sqlite or ask your own question.
SQLiteManager is a powerful database-management system for SQLite databases. It combines an easy-to-use interface with blazing speed and advanced features. SQLiteManager allows you to work with a wide range of SQLite 3 databases (like plain databases, in-memory databases, AES 128/256/RC4 encrypted databases, and also with cubeSQL server databases).
You can perform basic operations like create and browse tables, views, triggers, and indexes in a very powerful and easy-to-use GUI. SQLiteManager's built-in Lua scripting-language engine is flexible enough to let you generate reports or interact with SQLite databases in just about any way you can imagine.
Features:
Adobe Reader For Mac
- Wide range of sqlite 3 databases support (plain, in-memory, AES 128/256 and RC4 encrypted)
- cubeSQL support
- New flagship Retina-ready interface
- Inline editing done right
- Powerful table editor with realtime SQL generator
- Built-in Lua scripting language
- Built-in virtual-machine disassembler
- Built-in chart generator
- Detailed analyzer feature
- Foreign key support within the table editor
- Advanced import and export capabilities
- and much much more!