I was initially disappointed with this app until I found some features hidden in swipe menus on db, table, etc. Here are some ESSENTIAL features Navicat is missing:
. No way to clear a FILTER once set!!
. Synchronize from a source dB to a target dB (like phpMyAdmin)
. Backup/Restore of entire dB or selected tables and upload/download to/from Mail, Google Drive, Dropbox, OneDrive, iCloud, etc.
. Table list with Action icons, stats such as Record count, Type, Collation, Size, Overhead, etc., search boxes right under column headers (see MySQL Mobile Database Client app and its ability to use tapped column header names and real column values in search criteria), default sort by PK/unique index DESCENDING so latest records are on the top
. Table operations such as Move, Synchronize to another dB, Export, Import, save Search Criteria to re-execute later, save Filter and Sort expressions and reapply them (or make them as configurable options) when the table is loaded next time ...
. Table Inspector (Info, foreign keys, Grants at the very least), Space Usage, Row Statistics
. FREEFORM view of one record at a time in vertical layout (offers only list view of multi-records) - see MySQL Mobile Database Client app, phpMyAdmin, etc.
. Drill down from list view into free form layout and INTO other FK related tables AND data from previous table/record (see MySQL Mobile Database Client app and try their Demo MySQL Server with FK relationships - simply tap a row in list view and then tap column values in freeform layout)
. Pseudo Row NUMBER (running count) as the first column in row-list, table-list and EVERY layout that has list
. Page-Count in list view. Use SQL_CALC_FOUND_ROWS to fetch row count and compute page count from it.
. Keeps going to next page beyond last record showing empty pages on tapping Next!
. No way to skip pages as there are only previous/next icons that navigate just ONE page at a time!! No way to, for example, jump to page 5 or page 10 while navigating 100 records per page. Offer pagination links/icons and a dropdown of page numbers to select and jump to selected page.
. Queries do not use row limit from Settings - they return all rows without pagination.
. DEMO database to play with (see MySQL Mobile Database Client app and try their Demo MySQL Server)
. THEMES - a dark, stealth theme with peacock blue and mint green graphs would look awesome!! See Coda FTP app.
. Navicat Cloud -> Why is this necessary? Why cant they simply re-use iCloud and relieve themselves from the responsibility of maintaining their own SECURE server for it?? Why would anyone trust a 3rd-party server to sync profiles?
Ill update my star rating to 5-stars when these features are implemented and made available. We want to see Navicat as a powerful and go to app
PowerObject! about Navicat for MySQL