SQLite Visual Management Tools Summary

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

The collection of some SQLite tools, here to do a summary, some tools with more, some just a simple trial, not even trial, so there is a description of the improper also please reply, also welcome the addition of perfect!

2015-03-11 Update:

Sqlitespy Latest Version 1.9.8, major change, support db drag

Sqlitestudio Latest Version 3.0.3, major changes, open data volume of the database speed significantly improved, as well as the Count query, comparable to Sqliteexpert

Sqliteexpert the latest version of 3.5.76, I believe that the better use, has not experienced, Sqlitestudio has been very satisfied, recommended!

"Free and Stay updated"
1, sqlitespy free Single file
http://www.yunqa.de/delphi/doku.php/products/sqlitespy/
As of 2012/9/14 latest version Sqlitespy 1.9.1–28 Jul 2011
Single file, the interface design is compact, more stable, less function, create table and add data need SQL statement, shortcut key teaching convenient,
As the data browsing and modification tool is very good, the view is encoded as Utf-8, the gbk2312 display garbled.
Can satisfy the general application, but does not export the data table function,
Only one database file can be opened at the same time
Binary field editing is not supported

2. Sqlitestudio (recommended) Open source free Single file
http://sqlitestudio.one.pl/
Updated timely, fully functional sqlite2 and sqlite3 tools, view encoding support UTF8.
Supports Export data formats: CSV, HTML, plain, SQL, XML,
Multiple database files can be opened at the same time
Support for viewing and editing binary fields

3, Sqliteexpert personal free to install
http://www.sqliteexpert.com/
The function is very powerful, if the above two is not enough, try this one.

4, SQLite Manager (Firefox plugin) free, need to install the Firefox browser in advance

https://addons.mozilla.org/zh-cn/firefox/addon/sqlite-manager/

The basic function is complete, you can export the data table to SQL data format.

"Free but may have stopped updating"

1, Sqlite3explorer Free
http://www.singular.gr/sqlite/
Not updated in two years as of 2012/9/14, latest version V3.04 04/12/2010
But XP just don't gbk2312 coding, the interface is compact, full-featured.

2, SQLite Database Browser free

http://sqlitebrowser.sourceforge.net/
Simple to use, with basic database management query capabilities, and the ability to import and export data tables, support SQL files and CSV two ways.
No longer appears to be updated as of 2012/9/14, the latest version:
Version 2.0b1 released-based on qt4.6-12/09/2009

3, Sqliteadmin Free

http://sqliteadmin.orbmu2k.de/
Full-featured, multi-lingual interface, with export function, long time not updated, only identify Sqlite2, can be used for Sqlite2 to sqlite3 conversion,
Win XP under the code of the view is gbk2312, the utf-8 display garbled.
As of 2012/9/14, the latest version [0.8.3.2] is probably October 2007.

"Paid version, usually feature rich, update timely"

1, sqlite.developer fee ￥ 79 yuan has Chinese version
Http://www.sqlitedeveloper.com

2, SQLite Code Factory charges non-commercial single-user $49
Http://www.sqlmaestro.com
Similar products with the company SQLite Maestro charges non-commercial single user $79
The company produced a lot of database management tools

3, SQLite Manager fee $49 need to install
http://www.sqlabs.com/sqlitemanager.php

4. Navicat for SQLite

Http://www.navicat.de/cn/products/navicat_sqlite/sqlite_overview.html

Very good, very powerful, but the price is equally strong, suitable for enterprise use.

SQLite Visual Management Tools Summary