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
相关推荐
SQLite开源数据库管理工具SQLite开源数据库管理工具SQLite开源数据库管理工具
sqlite管理工具 免费无注册 需要的朋友请下载
sqlite管理工具源代码sqlite管理工具源代码
自己写的文档,为了以后自己查阅方便。 分享给大家。 介绍了一些sqlite的三种简单易用的管理工具。 介绍了sqlite时间查询,解决时间显示问题。
qlite数据库远程管理器,只要在SQLITE数据文件所在目录下运行SQLITE3SERVER服务器程序就可以在于之联网的机器管理SQLITE数据库。可同时管理多台SQLITE数据库服务器。 实现的功能如下: 1、可列出远程SQLITE数据库...
sqlite 数据库管理工具 虽然说不上强大,但是胜在是中文界面,用起来比较简单,导出数据方便
wince下sqlite开发,包括sqlite如何生成dll和lib文件以及sqlite管理工具。
SQLite 免费管理工具,SQLite 免费管理工具
简单的sqlite 管理工具 (有源代码)
类似phpMYadmin的一款工具,不过这个是用来管理SQLITE的
SQLITE3 是一个软件库,实现了自给自足的、无服务器的、零配置的、事务性的 SQL 数据库引擎。SQLite3 是在世界上最广泛部署的 SQL 数据库引擎。SQLite3 源代码不受版权限制。
SQLite 管理工具 sqliteadmin 和 sqlitestudio 感觉都挺不错,都是绿色版的. 资源分下载后评论,不会减少.
SQLite Expert Personal 3.4.50.2278 sqlite数据库管理工具,十分好用,是免费版本
sqlite developer SqliteDev387.zip sqlite管理工具
sqlite可视化管理工具 sqliteadmin SQLiteStudio sqlite可视化管理工具 sqliteadmin SQLiteStudio
3、启动sqlitemanage.exe,点击工具栏中的第二个远程登录按钮输入IP,WINDOWS可以通过点击查询数据库名得到远程SQLITE数据库名选择一个数据库登录,LINUX直接输入远程数据库名,就可以以所见即所得的方式管理远程的...
sqlite最好用的管理工具/客户端,sqlitestudio3,安卓数据库管理工具,免安装,直接解压双击SQLiteStudio.exe即可运行
SQLite数据库管理工具,轻松管理数据库,专家版
目前发现最好用的Sqlite管理工具,支持中文,编辑数据都比较方便。比SqlAdmin好用