Is there a good IDE for SQLite ?

views:

5493

answers:

+30 Q:

Is there a good IDE for SQLite ?

Is there a tool out there that can interact with a SQLite database in a similar way that TOAD works with Oracle or Management Studio works with SQL Server?

I'm looking for something that visually shows table structures, views, etc.

Looking to target the Windows platform (preferably Win 7).

Thanks!

+25 A:

Sqlite Administrator.

Ant points to the excellent FireFox add-on sqlite-manager. It's quite nice, easy to use, and... well, probably no more glitchy than Sqlite Administrator. At this point, I've switched to it for most of my interactive SQLite needs.

Shog9 2008-08-29 14:58:54

the problem here is that SQLite Admin is specific for Windows Systems :( So it is always best to use the Firefox plugin :)

balexandre 2008-12-28 12:03:03

@balexandre: finally got around to trying that add-on. Pretty slick... SQL editing seems to have a few glitches, but definitely a useful tool overall.

Shog9 2009-01-07 01:45:03

-100; a tool that is unable to display UTF-8 text in columns, size them to less than two screens wide, or just show the integer 633975308759166780 as something other than 0, is more dangerous than useful. Unfortunately, the vote count reflects the truth - other tools are even worse.

romkyns 2009-12-27 17:31:41

Have I mentioned yet that Ctrl+S clears the huge query you just typed and clears the undo history? Better fight your habit of saving your work if you're going to use this.

romkyns 2010-02-01 22:53:48

@romkyns, it is a freeware **beta** app. Instead of whinging about it how about contacting the author with suggestions on helping them make it better?

Ash 2010-04-30 05:24:44

+5 A:

There are a number of management tools to interact with SQLite, if that's what you're looking for.

You will probably get answers from more savvy users if you post a clearer question without too many question marks.

guillermooo 2008-08-29 15:02:04

@romkyns: your suggestion would probably be more useful if you addressed the actual maintainers of such list.

guillermooo 2010-01-12 13:42:27

@guillermooo: that is certainly true; comment deleted.

romkyns 2010-02-01 19:30:28

+2 A:

@Jason Baker sqlitebrowser also works for Mac and Windows.

Thomas G. Mayfield 2008-08-29 15:02:25

DbVisualizer works with any database that has a JDBC connector. As the name implies, it is quite visual.

Ed.T 2008-08-29 15:42:46

+31 A:

I’m surprised nobody has suggested the sqlite-manager FireFox addin. It’s not as powerful or friendly as SQLite Administrator, but handy if you need to poke about in a sqlite database on occasion. It gets updated regularly too.

Ant 2008-08-30 10:19:43

Even if you're not doing sqlite development, this addon is very handy for FF users in general, because starting with FF3 a variety of config data is managed by sqlite.

Chris Noe 2008-12-18 19:38:44

Just installed this and found it very intuitive. Was up and running in seconds.

Mike B 2010-01-07 04:49:37

sqlite-manager for the win! I prefer the stand-alone XUL application rather than the Firefox add-in though.

Francois Botha 2010-09-29 08:31:08

+3 A:

SQLite Expert is a nice tool and has a free version.

Matt 2008-10-31 18:43:02

No autocomplete, SQL Lite Administrator has it.

jcollum 2009-01-25 01:00:10

Actually rather more usable than most other SQLite tools - definitely give this one a go.

romkyns 2010-02-01 23:57:31

+3 A:

I've had good results with sqliteman.

trendl 2008-12-28 11:55:33

and the big plus is that it also runs on linux

André 2009-01-11 22:22:32

+1 A:

SQLite Manager by SQLabs is pretty decent and it works on both Mac OS X and Windows.

Paul Lefebvre 2009-01-11 22:16:04

Not a dedicated SQLite-IDE, but I was amazed that NetBeans (at least version 6.5) has a built-in SQLite explorer.

Henrik Paul 2009-02-13 06:56:17

+3 A:

For a great SQLite tool, check out SQLite Database Browser.

It is open source, works with Macs, on Windows (Vista / XP) and Linx...

Gabriel 2009-06-04 21:05:01

+2 A:

Sqlite Administrator seems to be a great tool, but unfortunately it can not display international characters correctly (for me, NVARCHAR fields, in Persian). I use SQLite Database Browser. It is simple but it does all I want from such a program. Besides, be careful while trying to browse database tables with any of these two applications because it seems that they both try to fully load all tables data into view (without any paging) and this can become problematic on large tables.

hamid reza 2009-09-10 16:38:04

The SQLite command line is actually the best tool in my opinion. Queries that you pass to the SQLite command line interpreter are actually the same ones that you'll use when you program against SQLite. Check out the following:

This video shows how to use the SQLite command line tool.
This video shows how to run SQL commands in the SQLite command line tool.
This video shows how to program SQLite with Ruby.
This video shows how to program SQLite with Lua.

If you watch the videos, it will be pretty obvious that using the command line gives you the smoothest transition to programming against SQLite. It shows that everything you can do with a GUI-based tool can be done with the command line.

Jay Godse 2010-01-08 15:27:08

I can do everything there is to do in SQL Server by using the command line also, but that doesn't mean I'm going to, given the availability of graphical tools. Why use a rock when a hammer will do the job easier?

Robert Harvey 2010-10-25 02:52:27

Good point, especially if you find the graphical tools more intuitive than command line tools. I find the command line more intuitive for SQL than graphical tools. I tried graphical tools for building SQL queries and found that I got confused easily. Using command line tools is nice because you can use exactly the same command-line queries in your program when you drive the database with code. I find that to be very useful because I can design my software with working queries, and when I go to code, I just have to put the SQL queries in to the code almost as is (except bound parameters).

Jay Godse 2010-10-25 04:08:29

SQLite Database Browser is pretty nice.

Yada 2010-01-20 05:12:49

+4 A:

Try SQLiteStudio. Its:

Free and open source
Runs from a single .exe file, so no install needed.

voon 2010-01-20 05:24:53

Approved. Simple and efficient.

Eduardo 2010-09-10 12:30:55

I have tried several sqlite managers. SqliteStudio is simple and more advanced than most others

goths 2010-10-19 10:39:38

+1 A:

Navicat for SQLite: http://www.navicat.com/en/products/navicat_sqlite/ is quite good

Mathias Lin 2010-05-20 11:40:12

Kind of an old question but still relevant. I tried out tksqlite the other day, and doesnt seem to be too bad of a program. Much easier to use than some other programs I have tried.

http://reddog.s35.xrea.com/wiki/TkSQLite.html

radix07 2010-05-26 19:39:24

that's ok that it's old. someone could stumble upon this question tomorrow or next year and find your answer

Chris Conway 2010-05-27 00:54:46

The best IDE for SQLite is Maestro for sqlite:

http://www.sqlmaestro.com/products/sqlite/maestro/

msfanboy 2010-07-15 20:13:08

+1 A:

My favorite is SQLite Analyzer. It's not as nice as IDE's for other databases, but I believe it's the least buggy SQLite IDE.

http://www.kraslabs.com/sqlite_analyzer.php

Sam 2010-10-26 12:35:32

ansaurus

tags:

views:

answers:

Is there a good IDE for SQLite ?

related questions