Navicat for SQLite - database editor & manager
Developer: PremiumSoft CyberTech Ltd.
Current Version: 11.2.18
Last Updated: 9 months ago
Download Size: 64.2 MB - Download
***** Navicat Premium named “Best Database Administration Solution” by Database Trends and Applications Magazine *****
** Best-in-Class Database Management Tools **
Navicat for SQLite Enterprise Edition is a powerful database administration and development tool for SQLite. It comes with advanced features such as the Data Modeling Tool, Import/Export, Visual Query Builder, Database Migration, and Batch Job Scheduling. Create, organize, access, and share information securely and easily with an intuitive GUI and take advantage of the flexibility of Navicat Cloud to sync your connection settings, models, queries and virtual groups to the cloud so you can get real-time access to them anytime.
Navicat’s sophisticated features provide professional developers with the tools they need, but are designed to be easy to learn for users new to database servers. Navicat for SQLite is compatible with SQLite versions 2 and 3, and supports most of the latest SQLite objects.
- Visual Database Designer
The Data Modeling Tools allows you to create graphical representations of a relational database. The Reverse Engineer lets you create and edit database models from existing databases or create a model and generate a database to support it.
Navicat Data Modeling also allows you to compare and synchronize between Models and Databases and generate SQL/DDL scripts.
- Query-Building Tools
The Visual Builder allows you to build complicated queries without knowledge of SQL syntax. Quickly construct SQL statements in SQL Editor with the code/word completion feature. All it takes is a pick from the drop-down list.
- Data Import and Export
Navicat for SQLite provides a wide variety of file formats for inserting and extracting data to/from your database. Create new tables or update existing ones with formats including XLS, XML, CSV, TXT, and DBF.
- Data Manipulation Tools
Advanced Data Transfer brings a new level of reliability in data transfers between databases. Navicat’s synchronization tools help you centralize data and keep databases up-to-date so that each repository contains the same information.
- Navicat Cloud
Sync your connection settings, models, queries and virtual groups to the cloud so you can get real-time access to them anytime, anywhere. With Navicat Cloud Collaboration, you can create, organize and share files/projects with your coworkers from anywhere, on any device.
You can take control of your project -- adding members you choose, defining the role of each member, and get visibility into your team activities from the Activity Log to align your team for greater productivity.
Other useful features:
- ER Diagram View
- Database Backup and Restoration
- User Privilege Manager
- Form View
- Text/Hex/Image Viewer and Editor
- SQL Beautifier
- Connection coloring
- Virtual grouping
- Database Wide Search
- Object Filter
* For more detailed information, please visit:
** For technical questions related to the Mac App Store, please visit:
Some minor bug fixes and improvements.
Most Helpful Reviews
Superb - This app is above and beyond the other database admin apps for SQLite. - Great UI. The new database I'm developing requires a ton of data entry on my part. Navicat's data entry is the most painless I've used. It functions very much like Excel where you can tab and arrow around- you can even create a new row by tabbing or arrowing. Some other apps require mouse clicks and/or a manual db commit before switching rows (painful!). Navicat has an autocommit option and still catches things like primary key violations. For me this is the primary reason for seeking an SQLite GUI. - The query builder is great for mapping out complex queries much faster and less error-prone than I can type them. It generates SQL which you can also tweek and these changes also update the query builder. So far the query builder seems to generate better SQL too (i.e. INNER JOIN instead of WHERE statements). Oh, and typing SQL has autocomplete (nice when trying to remember field names in huge tables). - Since this is SQLite specific, it holds to the nuances of SQLite. For example data types default to SQLite's type affinity. I know data types are dynamic in SQLite but it's nice to see things the way SQLite sees them. Also you see your sqlite_sequence table which you probably won't use but it's nice to know it's there. The free Firefox extension is nice but it really wasn't helping me too much on data entry, and I appreciate the luxury of a query builder. Base's data entry was also click heavy (click to add new row) . This and Base have free demos on their website, try them. If you need support only for SQLite, this is the one. I'd rather spend more time on my app and less on the SQL.