Click here to Skip to main content
13,056,397 members (101,567 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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
Updated 25-Aug-11 8:10am
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
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 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
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 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.170728.5 | Last Updated 17 Mar 2014
Copyright © CodeProject, 1999-2017
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