Click here to Skip to main content
12,068,141 members (49,563 online)
Rate this:
 
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
emsik180
Edited 25-Aug-11 9:10am
v5
Comments
digimanus 24-Aug-11 15:58pm
   
which ones have you tried?
emsik 25-Aug-11 4:16am
   
SQLite Database Browser
Lita - SQLite Administration Tool
SQLite Expert Personal
CPallini 24-Aug-11 17:28pm
   
Real men don't use GUI managers.
emsik 25-Aug-11 10:20am
   
:-) Next post will be, "Real men use Linux!" ?
CPallini 25-Aug-11 11:18am
   
Real men code Linux.
cvanti 6-May-14 6:10am
   
Real men code Linux using vi
CPallini 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 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.
   
"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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160208.1 | Last Updated 17 Mar 2014
Copyright © CodeProject, 1999-2016
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