Click here to Skip to main content
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
emsik157
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 OriginalGriff 365
1 Sergey Alexandrovich Kryukov 329
2 CPallini 270
3 Afzaal Ahmad Zeeshan 204
4 DamithSL 194
0 OriginalGriff 5,515
1 DamithSL 4,451
2 Maciej Los 3,902
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,175


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