SQLite管理工具介绍

2019独角兽企业重金招聘Python工程师标准>>>

1、SQLite Expert(Free, $59)，后边9个特效是收费版本具有的，官方网址：http://www.sqliteexpert.com/
– Manage SQLite3 databases: create database, view/change parameters.
– Check integrity, reindex all tables, transaction support.
– Supports attached databases and SQLite extensions.
– Manage tables: create, delete, rename, reindex.
– Restructure tables: fields, indexes, foreign keys, unique and check constraints, triggers.
– Manage views: create, delete, rename, restructure. Manage view triggers.
– Supports temporary tables and views.
– Advanced SQL editor with code completion and syntax highlighting.
– Advanced data editing capabilities in the grid: image, BLOB and text editors.
– Custom and predefined data types.
– Copy/Paste records and tables between databases via clipboard.
– Full Unicode support.
– Customize the look and feel of the application using skins.
– *Visual SQL Query Builder.
– *Copy tables between databases using drag and drop.
– *Supports encrypted databases.
– *Supports SQLite auto extensions.
– *Export data to Excel, XML, HTML, CSV, TSV, ADO data sources, SQL script, SQLite database.
– *Import data from ADO data source, SQL script, SQLite.
– *Send the contents of any grid to printer or export it to a PDF file.
– *Generate SELECT, INSERT, UPDATE and DELETE statements based on the visible fields on the current table.
– *Lua and Pascal scripting support.

2、SQLite Administrator(Free)，免费软件，支持中文，官方网址：http://sqliteadmin.orbmu2k.de/

– Create / Modify / Delete Tables by Wizard
– Create / Modify / Delete Indices by Wizard
– Create / Modify / Delete Views by Wizard
– Create / Modify / Delete Triggers by Wizard
– SQL Code Completion that supports table aliases
– SQL Code Highlighting
– SQL Error Locating
– Import Data from CSV Files
– Export Data ( XLS / CSV / HTML / XML )
– Store User Queries into Database
– Search for User Queries
– Store Images into Blob Fields ( JPG / BMP )
– Show SQL of each Database Item
– Migrate SQLite2 Databases to SQLite3
– Try to keep Indices and Triggers after modifying a Table

3、SQLite Developer(Free, $49)，似乎是国人开发的软件，官方网址：支持中文http://http://www.sqlitedeveloper.com/
– Power SQL Editor(Sqlite Sql Syntax Highlight; Sql history; Sql keyword autocomplete; Parenthesis matching; Table/View/Field; Autocomplete; Live Sql Syntax Check; Unicode support)
– SQL Formatter
– Supports ansi, unicode data encoding and decoding.
– Customizable Data Type Mapping.
– Execute multiple sql separated by semi colon.
– Execute sql script with parameters.
– Master Detail Browser.
– Test Data Generator
– Generate Database Schema Report
– SQL Monitor.
– Visual Query Builder.
– Visual tables ,views ,trigger, foreign key, check, unique check and index management.
– View and edit field as Text , Hex , HTML or bmp, jpeg, gif.
– View and edit temporary tables, views and triggers.
– Memory Database support
– Query plan.
– LiveUpdate.
– Export data to sql,csv,excel, word, html, xml.
– Import/Export(Import data from sql, csv, sqlite database and ado datasource; Extract db schema and data; Paste Data from Clipboard)
– Backup/Restore Database.
– Treeview style db explorer with smart filter
– Attach and Detach databases
– support encrypt and decrypt database (encrypted databases are compatible with System.Data.SQLite )
– RTree and ICU support
– Find in Database Schema
– Cancel long-time query
– Support loadable extension and virtual table
– Multi Languages support(English, Japanese, Simple Chinese)

4、Sqlite Spy(Free)，免费的，用起来不错，官方网址：http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index
– Database at a Glance: The schema treeview displays all items contained in a database, including tables, columns, indexes and triggers. Press F5 to update the schema tree, double-click a table or view to display its data, use the context menu for frequently used commands.
– Grid Cell Editing: Table cells are editable in the grid: Display a table via the schema treeview, select a cell and press F2 to invoke the editor. Then modify and confirm to write your changes back to the table.
– Data Type Display: The native SQL data types are displayed with different background colors to help detect type errors. Type errors can cause performance degradation or wrong SELECT result sets if NULL values are confused with empty strings.
– Full Unicode: SQLiteSpy fully supports SQLite’s Unicode capabilities. Data display and entry is completely realized as Unicode, including SQL commands.
– Multiple SQL Edits: Modern tabs are used to edit and display multiple SQL queries for easy comparison of query statements and results. SQL queries are executed by typing or loading them into the SQL edit. Then press F9 to run the query, or CTRL+F9 to run the current line or selection only.
– Time Measurement: SQL execution time is automatically measured and displayed to help optimize queries.
– Regular Expressions: The SQL keyword REGEXP is supported and adds the complete regular expression syntax of Perl 5.10 to SQLiteSpy. The implementation was realized using the DIRegEx library.
Mathematical SQL Functions – The following mathematical SQL functions are available in addition to the SQLite default: ACOS(), ASIN(), ATAN(), ATAN(), ATAN2(), CEIL(), CEILING(), COS(), COT(), DEGREES(), EXP(), FLOOR(), LN(), LOG(), LOG(), LOG2(), LOG10(), MOD(), PI(), POW(), RADIANS(), SIGN(), SIN(), SQRT(), TAN(), TRUNCATE().
– Data Compression: The SQL functions COMPRESS() applies zlib’s deflate to any text or BLOB value. The raw deflate data stream is returned. UNCOMPRESS() inflates this stream back to the original. Integers, Doubles, and Nulls are returned unchanged.
– Compact Result Storage: The internal data storage mechanism uses SQLite’s native data types for optimal compatibility. As a result, SQLiteSpy uses far less memory than other SQLite managers and handles large tables much more efficiently.
– Built-in SQLite Engine: SQLiteSpy comes as a single file executable with the SQLite database engine already build into the application. There is no need to distribute any DLLs, which makes SQLiteSpy easy to deploy with customers.
– Encryption Support: SQLiteSpy can read and modify encrypted database files generated by DISQLite3. DISQLite3 implements its own native AES encryption which is not compatible with the commercial SQLite Encryption Extension (SSE) or any such implementation offered by other 3rd parties.
– Easy Install & Uninstall: To run SQLiteSpy, just extract the SQLiteSpy.exe file to any directory and execute the file. No installation is needed – when first started, the program creates a single file SQLiteSpy.db3 (a SQLite3 database) to store options and settings. It does not write any other files or to the registry. Uninstalling is as simple as deleting two files only: The application’s executable and its options database file.
– Freeware: SQLiteSpy is Freeware for personal and educational use. If you are using SQLiteSpy commercially, your donation is welcome to promote the ongoing development of this software. Thank you!

5、SQLiteManager(开源)，所谓基于Web的SQLite管理工具，官方网址：http://www.sqlitemanager.org
– Management of several databases (Creation, access or upload)
– Management of the attached databases
– Create, edit and delete tables and indexes.
– Insert, edit, delete records in these tables
– Management of the View, possibilities of creating a view from a SELECT
– Management of Trigger
– Management of the users defined functions, these functions are in continuation usable in the requests manual, as in the form of insertion/modification of data
– Manual request and from file, it is possible of defined the format of the requests, sqlite or MySQL; a conversion is doing in order to directly import a MySQL base in SQLite.
– Importing of records from a formatted text file
– Export of the structure and the data
– Choice of several display skin

6、SQLite Database Browser(免费)，支持多平台，windows平台下的更是只有一个exe文件，官方网址：http://sqlitebrowser.sourceforge.net/
– Create and compact database files
– Create, define, modify and delete tables
– Create, define and delete indexes
– Browse, edit, add and delete records
– Search records
– Import and export records as text
– Import and export tables from/to CSV files
– Import and export databases from/to SQL dump files
– Issue SQL queries and inspect the results
– Examine a log of all SQL commands issued by the application

【免费且保持更新】
1、SQLiteSpy  免费 单文件
http://www.yunqa.de/delphi/doku.php/products/sqlitespy/
截至2012/9/14最新版本 SQLiteSpy 1.9.1 – 28 Jul 2011
单文件，界面设计紧凑，较稳定,功能较少，创建表与添加数据均需sql语句，快捷键教方便，
作为数据浏览和修改工具极佳，视图编码为utf-8，对gbk2312显示乱码。
能满足一般的应用，但没有导出数据表功能，
同时只能打开一个数据库文件
不支持二进制字段编辑

2、SQLiteStudio （推荐）开源 免费 单文件 
http://sqlitestudio.one.pl/
更新及时，功能完善的sqlite2和sqlite3工具，视图编码支持utf8。
支持导出数据格式：csv、html、plain、sql、xml，
可同时打开多个数据库文件
支持查看和编辑二进制字段

3、SQLiteExpert 个人免费 要安装
http://www.sqliteexpert.com/
功能非常强大，如果上述两款不能满足，就试试这个吧

 4、SQLite Manager（Firefox插件）免费，需要提前安装Firefox浏览器

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

基本功能齐全，可以将数据表导出为sql数据格式。

【免费但可能已停止更新】

1、Sqlite3Explorer 免费  
http://www.singular.gr/sqlite/
两年未更新，截至2012/9/14最新版本 V3.04 04/12/2010 
但xp下只是别gbk2312编码，界面紧凑，功能全面。

2、SQLite Database Browser 免费  

http://sqlitebrowser.sourceforge.net/ 
简单易用，具有基本数据库管理查询功能，并且能够导入和导出数据表，支持sql文件和csv两种方式。
似乎不再更新，截至2012/9/14最新版本：
Version 2.0b1 released - Based on Qt4.6 - 12/09/2009

3、SQLiteAdmin 免费

http://sqliteadmin.orbmu2k.de/
功能齐全，界面有多语言，带导出功能，很久未更新，只识别sqlite2，可用于sqlite2到sqlite3的转换，
win xp下视图的编码为gbk2312，对utf-8显示乱码。
截至2012/9/14最新版本 [0.8.3.2]大概是2007年10月份

 

【收费版，通常功能丰富，更新及时】

1、Sqlite.Developer 收费 ￥79元 有中文版
http://www.sqlitedeveloper.com

2、SQLite Code Factory 收费 非商业单用户 $49
http://www.sqlmaestro.com
同公司类似产品 SQLite Maestro 收费 非商业单用户 $79
该公司出品了很多数据库管理工具

3、SQLite Manager 收费 $49 需安装
http://www.sqlabs.com/sqlitemanager.php

 4、Navicat for SQLite

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

很好用，很强大，不过价格也同样强大，适合企业使用。

转载于:https://my.oschina.net/mickelfeng/blog/118044