Click here to Skip to main content
11,701,616 members (71,595 online)
Rate this: bad
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:

easy to work with SQLite databases for create, delete, fill tables
import (csv, xls, mdb, ...) and export
Posted 24-Aug-11 9:39am
Edited 25-Aug-11 8:10am
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
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Here is a list of tools:[^]
I have tried many of them and finally I choose

SQLite2009 Pro Enterprise Manager[^]

This is also good alternative

SQLite Manager - Add-on for Firefox[^][^]
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Did consider using google? I know... Stupid question...[^]
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
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.
Rate this: bad
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

* 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
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 324
1 Maciej Los 275
2 Sergey Alexandrovich Kryukov 250
3 Mika Wendelius 189
4 CHill60 110
0 OriginalGriff 8,274
1 Sergey Alexandrovich Kryukov 7,317
2 CPallini 4,912
3 Maciej Los 4,146
4 Mika Wendelius 3,556

Advertise | Privacy | Mobile
Web02 | 2.8.150819.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