• Navicat for SQLite For Ma OS X


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

    For Mac OS X

    All SQLite Versions Support
    Additional Connection Options
    Instant Navigation over Connections
    Powerful Visual Database Designer
    Well-Designed Visual Builder/SQL Editor
    Diversified Import and Export Competence
    Powerful Data Manipulation Tools
    More Great Features
    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.



    Additional Connection Options

    Support of HTTP Tunnel
    Navicat comes with HTTP Tunneling while your ISPs do not allow direct connections to their SQLite servers but allow establishing HTTP connections. HTTP Tunneling is a method for connecting to a SQLite server that uses the same protocol (http://) and the same port (port 80) as a webserver does.

     

    Import/Export Connection Settings
    You can easily transfer your connection settings while migrating Navicat from one computer to another new machine. Simply export your connections via Navicat and restore it on the new machine.


    Instant Navigation Over Connections

    Show connections as an open status
    Have your preferable connections opened right after Navicat is launched. Save your time and work more efficiently!

     

    Attach/detact database files in just a few clicks
    You can easily add another database files to the current database connection, and remove an additional database connection previously attached.


    Powerful Visual Database Designer *only available in Enterprise Version

    Support of Reverse Engineer
    With the Reverse Engineer in Navicat, you can create a database model from an existing database and graphically visualize and edit the structure of your database. Or, you can graphically create a model, and generate a database that supports your model.

     

    Compare and Synchronize between Model and Database
    Synchronize to Database will give you the full picture of all databases differences. Once your databases are compared, you can view the differences and generate the necessary synchronization script to update the destination database and make it identical to your model. Flexible comparison and synchronization settings will enable you to set up a customized comparison key for comparison and for synchronization.

     

    Support of SQL/DDL Script Generation
    Export SQL gives you the opportunity to get a full control over the final SQL script, generate individual parts of your model, generate referential integrity rules, comments, character set etc. The Export SQL feature may save you hundreds of hours of your work.


    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.


    Diversified Import and Export Competence

    Import data from ODBC

    You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.

     

    Import data from up to 5 most popular formats including XLS, XML, CSV, TXT and DBF
    Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.

     

    Export data to XLS, TXT, CSV, DBF, XML
    Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.


    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.

  • 相关阅读:
    cookie、localStorage、sessionStorage及三者的区别
    js中的宏任务和微任务
    IDEA工具第二篇:自定义Java注释模板
    JDBC注册驱动的三种方式
    Java POI导出Excel,打开提示“此文件中的某些文本格式可能已经更改......”
    day29 文件的上传和下载 socketserver(并发)
    day 28 黏包 ssh模块 subprocess模块
    day 28 网络基础相关的知识
    day 27 网路编程 面向对象多继承
    day 26 约束、自定义异常、加密hashlib、logging
  • 原文地址:https://www.cnblogs.com/jackljf/p/3589235.html
Copyright © 2020-2023  润新知