转：http://www.navicat.com/en/products/navicat_sqlite/sqlite_detail_mac.html
System Requirements
- Mac OS X 10.5 Leopard, 10.6 Snow Leopard, 10.7 Lion or Mountain Lion
- Intel CPU
|
All SQLite Versions Support
- Support of SQLite 2 and 3.
- Support of multiple connections to local/remote SQLite databases.
- Support all SQLite objects: tables and views.
- Support all subobjects: triggers and indices.
- Support to view master table.
- Support of character set and unicode.
 |
|
Well-Designed Visual Builder/SQL Editor
 Visual
SQL Builder
Visual SQL Builder - which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
|
| |
|
 Query
Editor
It allows you to create and edit SQL text for a query, prepare and execute selected queries.
|
| |
|
 Support
of Parameter Query
Set query parameters to add variable values to a query each time you run it.
|
| |
|
 SQL
Beautifier
With SQL Beautifier, you can format your SQL through a user-defined set of rules. This feature will increase your coding productivity and will improve the readability of your SQL code.
|
| |
|
 SQL
Minifier
Eliminate unnecessary spaces, line breaks, and indentation come in handy if you want to copy and paste your SQL to anywhere without unwanted whitespaces.
|
| |
|
 Smart
Code/Word completion support
Experience a quick way in constructing SQL statements in SQL Editor with the code/word completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.
|
| |
|
 Support
of standard editing features
Show line numbers, convert cases, zoom in/out and more.
|
| |
|
 Code
Folding
Code Folding lets you collapse (hide) and expand (show) sections of your code to make it easier to navigate and read. What you need to do is just to click the plus (+) and minus (-) signs next to the code.
|
| |
|
 Matched
Brace/Bracket Highlighting
when you place the cursor just after a closing (or just before an opening) brace, bracket, or parenthesis. Navicat will try to locate its matching brace, bracket, or parenthesis and highlight their companion with pre-defined colour.
|
|
Powerful Data Manipulation Tools
 Form
View
Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.
|
| |
|
 Support
of Foreign Key Data Selection
With the GUI tool - Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!
|
| |
|
 Data
Transfer
Data Transfer allows you to effortlessly transfer data between databases. This feature will drastically simplify the process for migrating data.
|
| |
|
 Export
data and create records as INSERT statements in sql file
During Data Transfer, you can choose to export data as sql file with designated SQL format and encoding.
|
| |
|
 Data
Synchronization
Navicat allows you to transfer data from one SQLite database to another with detailed analytical process. In other words, it provides the ability for data in different databases to be kept up-to-date so that each repository contains the same information.
|
| |
|
 Create
Schedule for Import/Export, Data Transfer, Queries and Data Synchronization
Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Backup, Data Transfer, Data Synchronization, Import and Export.
|
| |
|
 Send
notification e-mail for schedule task
Generate notification e-mails to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule. Also, exported file can be added to the batch job as mail attachment
so that you can share your data easily.
|
| |
|
 Support
of Backup and Restore SQLite databases
Regular backup on database is important to users. Backup/restore all tables and records, views etc for your SQLite database using Navicat. You can also schedule backups between databases.
|
|
More Great Features
 ER
Diagram View
ER Diagram view helps you achieve a better understanding of your database schema by displaying the structure in a graphical format. So, you can see the interrelationships between tables in a database.
|
| |
|
 Database
Wide Search
Navicat provides a powerful search function to find records on the entire database. You can search for whole words only, use regular expressions etc to search in. It is particularly useful if you want to limit your search to a particular type of records.
|
| |
|
 Connection
Coloring
You can immediately know which server you are connected to. It includes a colored strip indicator shown on the sub-window toolbar for identifying connections and their database objects.
|
| |
|
 Favorites
Navicat makes it easy for you to return to a particular database object you visit often within easy reach. By adding paths to your favorites list, you can go to those database objects with a single click, instead of having to navigate the connection and databases
in Navicat.
|
| |
|
 Object
Filter
If you want to narrow the list of database objects displayed in Navicat, why don't you try our Object Filtering feature. Type in text, and only those database objects that start with the specified string are shown.
|
| |
|
 Virtual
Grouping
Have a better organization over connection and objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature.
|
| |
|
 Support
of Increment Search
Incremental Search allows you to perform a find, instead of waiting for the complete search string to be entered it will search for the closest match as the string is typed, reposition (caret) to the found string as it is typed. In other words, the matched
text is found and highlighted instantly. This saves your time from typing the entire text.
|
| |
|
 Text/Hex/Image
Viewer
Navicat provides Text/Hex/Image Viewer and Editor to view/edit text and image field contents. The editor allows you to view, update, insert or delete data in a table.
|
| |
|
 SQL
Console
To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
|
