Click here to Skip to main content
11,490,007 members (49,039 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Sqlite
What SQLite GUI tools are available for Windows to edit/manage SQLite databases?

The goals are:

free
user-friendly
easy to work with SQLite databases for create, delete, fill tables
import (csv, xls, mdb, ...) and export
Posted 24-Aug-11 10:39am
emsik170
Edited 25-Aug-11 9:10am
v5
Comments
digimanus at 24-Aug-11 15:58pm
   
which ones have you tried?
emsik at 25-Aug-11 4:16am
   
SQLite Database Browser
Lita - SQLite Administration Tool
SQLite Expert Personal
CPallini at 24-Aug-11 17:28pm
   
Real men don't use GUI managers.
emsik at 25-Aug-11 10:20am
   
:-) Next post will be, "Real men use Linux!" ?
CPallini at 25-Aug-11 11:18am
   
Real men code Linux.
cvanti at 6-May-14 6:10am
   
Real men code Linux using vi
CPallini at 6-May-14 6:12am
   
Exactly.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Here is a list of tools:

http://www.sqlite.org/cvstrac/wiki?p=ManagementTools[^]
I have tried many of them and finally I choose

SQLite2009 Pro Enterprise Manager
http://osenxpsuite.net/?xp=3&uid=managementtools[^]

This is also good alternative

SQLite Manager - Add-on for Firefox
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/[^]
http://code.google.com/p/sqlite-manager/downloads/list[^]
  Permalink  
v6
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Did consider using google? I know... Stupid question...

http://sourceforge.net/projects/sqlitemanager/[^]
  Permalink  
Comments
emsik at 24-Aug-11 16:01pm
   
Thanks, I already installed and tried few managers but none is useful and easy, so I rather ask professionals for best one.
John Simmons / outlaw programmer at 25-Aug-11 15:08pm
   
"Best" is a completely subjective term. What's "best" for you, may not be best for me.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

For mac osx you could try SQLite Professional.They also have a pretty good Windows beta out.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Starting with 14 Feb of 2013 year you can enjoy by a Valentina Studio 5.x
http://www.valentina-db.com/valentina-studio-overview


* it is FREE
* It works natively (!) on all 3 os: linux, mac and windows
* it works with SQLite as well as with mySQL, PostgreSQL and Valentina DB

It has a lots of advanced tools:

* Diagrams with forward engineering
* Schema Editor, which can change structure of your SQLite tables even if they have records
* Data Editor
* SQL Editor with syntax highlighting and auto-completion
* visual Query Builder
* Import/Export
* SQL Dump
* and many others
  Permalink  
Comments
Chikako Hatanaka at 8-Apr-13 13:43pm
   
I see there is a new version 5.1.1 available today.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 610
1 Andy Lanng 233
2 OriginalGriff 208
3 Maciej Los 160
4 Sascha Lefèvre 160
0 Sergey Alexandrovich Kryukov 9,608
1 OriginalGriff 8,475
2 Sascha Lefèvre 3,419
3 Maciej Los 3,106
4 Richard Deeming 2,370


Advertise | Privacy | Mobile
Web03 | 2.8.150520.1 | Last Updated 17 Mar 2014
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100