Comparison of features of SQLite GUI application programs for Mac OSX-优快云博客

本文对比了多个SQLite客户端的功能特性，包括SQLiteManager、SQLGrinder、DBSolo等，详细介绍了它们的操作系统支持、数据库浏览编辑能力、SQL编辑及执行等功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Developer

SQLiteManager

SQLGrinder

DB Solo

RazorSQL

Froq

Navicat

Navicat Essentials

SQLite Manager for FireFox

DBVisualizer

Base

Spatialite

MesaSQLite

Orac

SQLiteQuery

SQLEditor

Icon

URL

http://www.sqlabs.net/sqlitemanager.php

http://www.sqlgrinder.com/

http://www.dbsolo.com/

http://www.razorsql.com/

http://www.alwintroost.nl/?id=82

http://www.navicat.com/en/products/navicat_sqlite/sqlite_detail_mac.html

http://sqlite-manager.googlecode.com

http://www.dbvis.com/products/dbvis/

http://menial.co.uk/software/base/

http://www.gaia-gis.it/spatialite/

http://www.desertsandsoftware.com/?realmesa_home

http://www.oractotherescue.com/

http://www.software-by-mabe.com/software/freeware.html#sqlitequery

http://www.malcolmhardie.com/sqleditor/

Developer

SQLabs

Advenio

DB Solo LLC

Richardson Software

Alwin Troost

PremiumSoft

Mrinal Kant

Minq Software

Menial

Alessandro Furieri

Rick Praetzel

Arten Science

Manfred Bergmann

MalcolmHardie Company

Price

US$49

US$59

US$99

US$59.95

€49.99. Approx US$60

US$99 or $69 non-commercial, for the SQLite only version

US$10. SQLite only version

Free

US$149

£19.99

Free

US$20

Beta

Free

US$79

Reviewed Version

3.5.1

2.0.8

3.0

4.5.8

2.2.2 B1937

10.1.1

10.1.6

0.2.39

6.0.8

2.0

2.2

3.0.6

1.0.0 beta 060509_2330 (1.0.1 according to macupdate.com, but devloper website has disappeared)

0.7.3

1.4b19

Reviewed Date

2011-02-09

2012-11-13

Technologies

SQLiteManager

SQLGrinder

DB Solo

RazorSQL

Froq

Navicat

Navicat Essentials

SQLite Manager for FireFox

DBVisualizer

Base

Spatialite

MesaSQLite

Orac

SQLiteQuery

SQLEditor

Operating System

Mac

Mac, others

Mac, others?

Mac

Mac, Linux, Windows

Mac (also available for Linux, Windows)

Mac, others?

Mac 10.6 (Base 1.4.2 for 10.5)

Mac, Linux, Windows

Mac

Platform

Cocoa, RealBasic

Cocoa

Java?

Java

Cocoa

Firefox or oter Mozilla app

Java (Mac theme)

Cocoa

Java?

Cocoa, RealBasic

RealBasic

Cocoa?

Database

SQLite

JDBC gives SQLite and others. Fussy about driver.

JDBC gives SQLite and others

SQLite (Razor built in), others, or JDBC

SQLite, Oracle, MySQL, others

SQLite. Also available for MySQL, Oracle, PostgreSQL

SQLite

JDBC gives SQLite and others

SQLite

SQLite, Oracle, others?

SQLite

JDBC gives SQLite and others

Driver

Built in

Zentus JDBC v044 added

Zentus JDBC added

Mac OS X, or select SQLite program

Zentus? JDBC built in

Built in

Zentus JDBC added

Built in

Zentus JDBC added

SQLite version

3.6.23.1

3.5.8

3.5.6

3.6.13 or latest

3.6.14.2

3.7.11

3.3.5

3.5.6

3.7.5

3.6.2

3.6.20

3.4.2

3.5.6

Can open SQLite file from Finder

Yes

Can open database file on AppleShare volume

Yes

Yes using other JDBC. No using Zentus JDBC

Yes

Yes using other JDBC. No using Zentus JDBC

Yes

Yes using other JDBC. No using Zentus JDBC

Demo/shareware limit

Query results limited to 20 rows. Disabled export, import, report generator, dump database. Limited print.

20 launches, with the ability to extend the trial period.

30 day limit

30? day eval period, thereafter can't launch.

25 day trial

30 day trial

Free

Free version doesn't allow editing of data, but doesn't explain that. Free 21 eval version on automated request, allows data entry.

15 minute sessions. 5 rows from custom SQL queries

Beta

Beta until June

Free

Beta

Data browse

SQLiteManager

SQLGrinder

DB Solo

RazorSQL

Froq

Navicat

Navicat Essentials

SQLite Manager for FireFox

DBVisualizer

Base

Spatialite

MesaSQLite

Orac

SQLiteQuery

SQLEditor

Resize columns

Yes, manually

Yes, manually. Double click border to autosize.

Yes, drag

Yes. Manual and autosize

Yes, manually. Double click border to autosize.

Yes, manually. Autosizes.

Yes manually or via "Set to natural widths" button.

Yes, manually

Reorder Columns

Yes

Yes, drag

Yes, drag.

Yes, drag

Yes

Yes in tables via drag. No in views.

Horizontal scroll through columns

Yes, if preferences set to "Always add Horizontal Scroll" and "Columns can't be smaller than 80 pixel"

Yes

Yes?

Yes

No, so too cramped when many columns.

Yes

Yes (option)

Yes

Show/hide columns

No. Can manually shrink to zero width.

Yes. Edit -> Show/Hide Columns

Yes, via pop up menu on right of column headers

Yes

Yes, click on "Limit columns" button, or right click on column to choose "Hide column" from context menu.

Quick sort columns

Yes, click single column header

Yes. Double click column header. Or click "Sort Query Results" button to sort via popup menus.

Yes, click single column header. Click "Sort" button to sort multiple.

Yes. Sort by a column or custom sort

Yes. Click on first sort column, control click on second.

Yes. Click header to sort ascending/descending

Yes, click on single column header. Or click on "Set multiple sort" button to show dialog. Fails for column names that should be quoted.

Yes. Click header to sort ascending/descending

Quick filter rows

Yes, match one or all columns

Yes

No. Can refine/add "where" clause

Yes, extensive. Can also drag cell from result set to filter, hold option to filter out, or drag to table browser to search another table.

Yes. Click "Filter Wizard" button, then File -> Apply Filter. Or right click on cell -> Filter For... Extensive. Slight bug with numeric inequalities?

Yes, one condition per column

Yes, match one or all columns

Yes, can also "send to SQL" to make select query.

Yes for tables. No for views.

Show column info in data editing

No, not in column view, but entity browser can be expanded to show columns of a table, which includes type and PK.

No, but can see column names and types in Info for table/view

Yes, key icon in header, tooltip shows column info.

No, but can select column in entity browser, pop up menu select "Geometries"

Modes for viewing data

SQLiteManager

SQLGrinder

DB Solo

RazorSQL

Froq

Navicat

Navicat Essentials

SQLite Manager for FireFox

DBVisualizer

Base

Spatialite

MesaSQLite

Orac

SQLiteQuery

SQLEditor

Column mode

Yes

Yes "Grid view"

Yes

Yes. Edits direct in cell if numeric, opens text in cell mode when double clicked.

Yes

Line/form mode

Yes, click pencil button to show "Record Editor".

Yes, with next/previous. Click "Info" button to show in pane over columns.

Yes. Click "Form View" button.

Yes, for tables not views, as panel over column view without next/previous.

Yes "Form view", initiated from hilighted row in column mode, but can't move to another record in form mode.

Yes for tables, no for views. Click icon left of row.

Yes, after double click row

Cell mode (large wrapped field)

Yes. Selected cell shown in large field in line mode ("Record Editor")

Select cell in column mode appears in own text entry field

Yes

Yes, via right click on cell, choose "Edit Value"

Yes. Form view text cells are large, or click "Text" button.

Yes, via expand button next to cell in line mode.

Yes, via context menu or button

Yes. Set the long text threshold in Preferences.

Yes. Opens in panel if cell is text.

Yes, hover box

Other modes

Generate saved "Report" in HTML or other text based format.

text column

image or hex

Data entry

SQLiteManager

SQLGrinder

DB Solo

RazorSQL

Froq

Navicat

Navicat Essentials

SQLite Manager for FireFox

DBVisualizer

Base

Spatialite

MesaSQLite

Orac

SQLiteQuery

SQLEditor

Entry in tables

Yes

Yes, via popup menu "Edit table rows"

Yes

Entry in views (with "instead of" triggers)

Yes for update. no for insert.

Yes. Asks for key field to use.

Yes

Yes, but only works if the view contains a "rowid" key column.

Mark & submit

No, immediate

No? Bug with data entry.

Yes

Yes, optional connection type for commit/rollback. Incorrectly updates whole row instead of just changes. Does have commit/rollback mechanism.

Yes. Can use auto commit or manual commit.

No, immediate

Yes

No, immediate

Yes?

Changes not marked. Can autocommit or begin/end transaction via buttons.

Null distinct from text

No, but does have "Set to null" command in cell entry.

No, but can set string to show

No in column mode, NULL appears same as 'NULL' literal text. In Cell mode shows number of characters.

Yes, pink (adjustable) cell color for nulls.

Yes. Shows as grey [Null] and has "Set Null" context menu.

No, appears as "NULL"

Yes, can choose string and cell color.

No, but can set text to show (default 'NULL')

No. NULL appears same as "NULL"

Yes uses "NUL" graphic

GUI Create

SQLiteManager

SQLGrinder

DB Solo

RazorSQL

Froq

Navicat

Navicat Essentials

SQLite Manager for FireFox

DBVisualizer

Base

Spatialite

MesaSQLite

Orac

SQLiteQuery

SQLEditor

Add Column

Yes for tables. No for views.

Yes. Right click table, choose "Alter", "Add Column"

Yes for tables and views but buggy. Drops and creates table, but doesn't bring triggers. Identifiers in views not quoted.

Yes

Yes. Click "Action" button under entity list, choose "Alter", then add column. Includes GUI for constraints. Mistakenly shows some table constraints as columns and an "Origin" column (which is only relevant for views).

No. "Add New Column" popup menu just shows template SQL

Yes in tables

Drop Column

Yes for tables. No for views.

No since tries "alter table... drop column" syntax which SQLite doesn't support.

Yes for tables and views but buggy. Drops and creates table, but doesn't bring triggers. Identifiers in views not quoted.

Yes

Yes. Click "Action" button under entity list, choose "Alter", then select and delete column.

Yes

Yes in tables

Reorder column definitions

Yes for tables and views (but buggy eg Fails for identifiers with spaces)

Yes, via Action -> Alter popup button under entity list.

Yes in tables, no in views. Buggy for some tables.

GUI create table

Yes (buggy?)

Yes

No, "Create Table" menu item disabled for SQLite.

Yes. Great except fails for identifiers with spaces

Yes

Yes, right click on "Tables" in browser -> "Create Table"

Yes

No. "Create New Table" popup menu just shows template SQL

Yes, via grid

Yes

GUI create view

No, just shows dialog with field for name and select statement

No ("Create Table" panel offers "view" option but does same as table.

No. Dialog allows view name and SQL of select, but limited usefulness.

Yes. Great except fails for identifiers with spaces

No, just shows dialog with field for name and select statement

No. "Create New View" popup menu just shows template SQL

Yes basic. Can save a GUI query on a table as a view. "Add View" button asks for SQL.

Link tables

No (though "Foreign Keys" tab might be promising when it works)

Yes. Foreign keys and view definition

No, not in SQLite, requires support for "foreign key" in tables, wheras SQLite only links in views.

Entity browsing

SQLiteManager

SQLGrinder

DB Solo

RazorSQL

Froq

Navicat

Navicat Essentials

SQLite Manager for FireFox

DBVisualizer

Base

Spatialite

MesaSQLite

Orac

SQLiteQuery

SQLEditor

Shows entities

Tables, views, triggers, indexes

Tables, views, indexes, triggers

Tables and views but not indexes or triggers?

Tables, views, triggers, indexes

Tables, views, indexes, triggers

Tables, views, no triggers or indexes

Tables, views, triggers. Indexes appear with selected table.

Tables, views. Expanding a table/view reveals associated columns, triggers and indexes

Tables and views in separate panes

Tables, indexes, but not views or triggers

Tables only

Filter list

Yes, after customizing toolbar to have search field.

Yes. Right click, "Filter Navigator".

Yes

Yes, with wildcards

Yes

Sorted list

Yes

Refresh manually

Yes, collapse/expand grouping

Yes, "Reload" button

Yes, right click on "Tables" -> "Refresh"

Yes. Right click -> "Reload Navigator"

Yes, "Reload Connection info" from "Connection" menu. Also auto every 30s.

Yes. "Refresh Connections" popup menu

Yes, click "Refresh" toolbar icon

Yes, right click -> "Refresh Objects Tree"

Yes, via "Reload" toolbar button. Also refreshes automatically after each SQL execution.

Yes. Popup menu "Refresh".

Yes via "Refresh Tables" button

Rename

Yes for tables. No for views, but can double click, change name field (fails if name contains space).

Yes

Yes. However, renaming views (and tables?) doesn't bring triggers

Yes

Yes. Also correctly alters triggers associated with renamed table/view.

No. "Rename table" popup menu just shows template SQL

Yes, double click on name to edit.

No (not existing entities)

View/edit data of selected table/view (without need for explicit query)

Yes, for tables, right click -> "Query". No for views.

Yes, click "Data" tab and start button

Yes, click "Execute" button in "Data" tab.

Yes, right click -> "Edit"

Yes

Yes, double click

Yes

Yes, in "Data" tab

Yes

Yes via popup menu "Edit table rows" or "Query view"

Yes for view. No for table, but can select table from menu with two clicks and then click "Show All" button in "Content" pane.

Shows indexes belonging to selected table

Yes

Yes, via "Info" -> "Indexes"

Yes in "Design", not in entity hierarchy.

No, though does show number of associated indexes

Yes, in "Indexes" tab

Yes

Yes, by expanding table in entity browser

Yes

Shows triggers belonging to selected table/view

Yes for Tables, no for views.

Yes, via "Info" -> "Triggers"

Yes for tables in "Design", not in entity hierarchy. No for views.

No, missing for SQLite

Yes, by expanding table/view in entity browser

Yes, but you have to reselect the table or view first.

Can show SQL of triggers/indexes with SQL of parent table/view

Yes

Show/edit schema SQL of selected table, view

Yes

No. Recreates its own SQL, ignoring original, adding unnecessary (200000000) parameters, reformatting

No? Not yet implemented?

Yes. Right click -> "View DDL"

Yes, click "info" then "DDL" button.

Yes, can view SQL in "DDL" tab, and edit via GUI and preview. Fails to include triggers and indexes

Yes, in "Structure" tab, though scrolling field is too small at only 4 lines.

No, missing for SQLite

Can show but not edit schema of views. Can't show SQL of table schema, only GUI.

Yes, via popup menu "Show CREATE statement"

Yes can view SQL of tables and views but can't edit. For tables need to click on "Show create table" button.

SQL Editing

SQLiteManager

SQLGrinder

DB Solo

RazorSQL

Froq

Navicat

Navicat Essentials

SQLite Manager for FireFox

DBVisualizer

Base

Spatialite

MesaSQLite

Orac

SQLiteQuery

SQLEditor

SQL text editor

Yes

Yes "Custom Query"

Yes

Syntax color

Yes for queries, but not existing schema.

Yes (slight bug when encountering a "/")

Yes

Yes. Simply keyword, number, literal, comment, other

Yes

Yes, only keywords

Colors are context aware

Yes?

No?

Mostly. Some inconsistent coloring of entity names.

Yes?

Distinct color for quoted identifiers vs literals

Yes

Yes. Quoted identifiers are black like unquoted and most syntax.

Yes, though default (in preferences) is same color.

Distinct color for tables/views

Yes

Yes, but inconsistent

Distinct color for join aliases

SQL indenting

Yes but ignores level

Yes, "Format indenting" command

Yes, via "Beautify SQL" popup menu. Navicat Essentials: No

Yes, extensive including alignment

Keeps original case for keywords

Yes

Yes. Can manually select text and choose upper/lower

Yes

Yes. Optional upper

Yes

Yes, although "Beautify SQL" changes to upper case.

Yes

Yes. Optional upper or lower

Yes

Yes (option for Caps)

Yes

creates upper

Copy from manually activated list of tables/columns

No, but can paste from list of shortcuts

Yes

Yes, but pops up automatically

Drag and drop objects into text

Yes, but dragging table from browser drops other table's column names

Yes (entities but not columns), from entity list and "Statement Recall". But doesn't quote identifiers that need quoting (eg containing a space).

Yes, from entity list

No. Entity list not visible in "Custom Query" tab.

Auto completion

Yes. Hit escape key to show list of options. Problem with being case sensitive and doesn't quote entity names that need it.

Pop up of tables/views (not columns)

Yes, but offers Entities when it should offer columns (eg after "where").

Yes context aware popup, but keywords are uppercase only

No "Show Autocompletion" from menu doesn't work

No, but list auto appears

Execution

SQLiteManager

SQLGrinder

DB Solo

RazorSQL

Froq

Navicat

Navicat Essentials

SQLite Manager for FireFox

DBVisualizer

Base

Spatialite

MesaSQLite

Orac

SQLiteQuery

SQLEditor

SQL Execute

Yes

Copes with spaces and reserved words in identifiers

Yes. Query on table uses [] but should use "".

Yes for column names if enable preference "Browser" -> "Quote table column names when querying". No for table/view names.

Yes?

Yes

Mostly Yes. Fails in design or rename of tables, views

Yes

Yes, if set option for delimiters to ""

Yes

Yes, except incorrectly uses single quotes instead of double

[From]

http://www.barefeetware.com/sqlite/compare/?mlp

转载于:https://www.cnblogs.com/abnercai/p/3142938.html