SQLite vs Collections Database

SQLite-Pro is a professional SQLite database manager which allows you to graphically open and manage SQLite database files on the iPhone, iPad, and MacBook. The app combines the power and flexibility of SQLite with an intuitive graphical interface for tapping to view all tables and rows. You can also tap on the search icon to enter advanced SQL queries and get results immediately. You can create a new table easily with the Create Table panel, and add new rows with the Add Row panel. You can also tap and drag to highlight any table or rows for copy, paste, and share. The app also automatically formats SQLite query results to fit each column perfectly for thousands of rows in a few seconds. An innovative, powerful, and easy-to-use SQLite database app. This is the solution that SQLite-Pro delivers for you today. Features: - Opens all SQLite database files - View and manage multiple SQLite database files from the iCloud drive - Tap on a table name to view the table - Tap on a column title to sort by the column - Tap on the search icon to enter advanced SQL queries and get results immediately - Create a new table with the Create Table panel or create SQL command - Add a new row with the Add Row panel or insert SQL command - Tap and drag to highlight any table or rows for copy, paste, and share - Built-in iCloud integration for automatically synchronizing SQLite database files - Automatically formats SQL query results to fit each column perfectly - E-mail any SQLite database file instantly - Works anywhere online or offline - Works with all international text SQLite-Pro runs on the iPhone, iPad, and MacBook. Subscription is auto-renewable which means that once purchased it will be auto-renewed. Payment will be charged to iTunes Account at confirmation of purchase. Subscription automatically renews unless auto-renew is turned off at least 24-hours before the end of the current period. Manage your Subscription and Auto-Renewal by going to your Account Settings. Terms of Service: http://impactfinancials.com/terms_of_service Privacy Policy: http://impactfinancials.com/privacy_policy

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