MSSQL Commander for iPad vs Collections Database

Powerful MSSQL Server client for iPad Great SQL query editor with syntax highlighting and fast query editing Queries are saved across devices using iCloud Work with and see multiple SQL queries and results at the same time. You get to set how much space each query should have on the screen. Helps you generate advanced queries, but always lets you review before you execute them. Save favorite queries for later. And when you close MSSQL Commander and later reopen it, your queries are exactly where you left them, ready to be replayed Open connections to different (or even the same) instance using multiple windows in split view Full SSH support - Authenticate either with certificates or passwords - Connect to either the database host you're tunnelling too, or to a database on a remote host the tunnel gives you access to Browse query results like you do in a spreadsheet Export data as CSV, XML and JSON to your favorite apps such as Apple Numbers or Microsoft Excel. Both light- and dark-mode support. Respects your text size preferences via Dynamic Text Your purchase includes all current features and all features that are provided during the next year. For features developed thereafter, an in-app purchase will become available.

Collections is a personal database app to organize anything. 1. A field for every use Collections supports over 20+ field types: • Text, Number • Boolean • Picture • Select • Email, URL, Phone • Password • Date, Time • Color • Barcode And with the Pro version you can use even more advanced fields. • Document reference - Link documents together • Group - Add multiple values for a field • Formula - Create a formula for calculated values. Powerful formula editor with full support to math functions like SUM, AVG • Sources - Import documents from external APIs with Javascript 2. Customizable • Add and reorder fields • Add a separator between fields to better visualize them • Fields have different display styles like primary, secondary, thumbnail • Filter and sort data 3. Templates Collections includes basic templates to get started: • Books • Contacts • Expenses • Subscriptions • Credentials • Inventory • School 5. Advanced management Collections has different tools to help you creating the data model. SUBCOLLECTIONS Organize data into collections and subcollections. Simply said, they are like folders. LISTS A list contains items used in documents and it's very flexible. It could represent a Genre for a book or a Status like 'Available', 'Out of stock' for an object in the inventory. 6. Security • Protect collections using a password, Face ID or Touch ID • Sensitive data such as passwords are encrypted by default 7. iCloud Sync Data is synced automatically between devices through iCloud. 8. Apple's Shortcuts support Expand the app capabilities with Apple's Shortcuts support. 9. Pro version features • Add unlimited documents (free version is limited to 100 documents) • Add files to documents • Add advanced fields • Views • Grid • Use Summary to perform calculations across documents