Private DB

July 1, 2021

- Regular expressions in SQL, such as: SELECT * FROM Maintenance WHERE Description REGEXP '^Fixed' - SQLite 3.36.0

May 28, 2021

- If you open a database that has a field value that cannot be displayed as a text string, then a special string is displayed instead. This is to prevent unexpected behavior when binary data is in the field but the Raw field format is not selected. - Bug fixes - SQLite 3.35.5

April 6, 2021

Includes SQLite 3.35.4: - Built-in math functions, such as sin() and log() - ALTER TABLE DROP COLUMN - Generalized UPSERT - RETURNING clause lets you see the values after an INSERT, UPDATE, or DELETE. NOTE: This is a major release. If you have critical databases, you must back them up using iTunes or iCloud or Dropbox before updating this app!

January 15, 2021

Fix for selecting field values in Date and Time formats in iOS 13.4 and above.

January 5, 2021

- SQLite 3.34 - The generate_series() virtual table is now built in to this app. As an example, the SQL executed below would make a virtual table of 6 rows with even values starting from 0 up to 10: SELECT value FROM generate_series(0, 10, 2) - Bug fix for importing large files Note: Backing up your databases before a major software update is good practice and recommended. To backup your databases, sync your phone with iCloud or your computer, or go to the Files tab and Share your databases with another computer.

September 14, 2020

- The Tables List now has a database file settings button. This lets you more easily make tables or views hidden in the currently selected database. - See the file size of any file by tapping it in the Files List then tapping its details button. - Picker Types are now called Pickers that are stored in the system tables. - Bug fixes SQLite 3.33: - Decimal math functions - Support for UPDATE FROM IMPORTANT: This is a major release. If you have critical databases, you MUST back them up before updating this app. To back them up, share them with your computer or iCloud, or upload to Dropbox.

July 6, 2020

- More documentation for SQL functions - New search bar for SQL functions - SQLite 3.32.3 - Bug fixes Although this is a minor release, it is good practice to back up any critical databases you have before updating the software.

June 13, 2020

Hide tables and views in the List of Tables. This helps when working with databases that have a lot of tables and views, some of which you rarely use. It can also be useful if you are distributing your databases to others, who do not need to see all the tables. To hide a table or view, go to the List of Files, tap your database file, then tap the table or view you wish to hide and tap the "Hide" button. To un-hide it, do the same thing but tap the "Show" button. To temporarily display the hidden tables and views in the List of Tables, long-press the info button in the toolbar below the List of Tables. Make any field an expanded field, not just fields with Text format. The expanded fields will be concatenated together in the Expanded Fields Section of the Row Display. Go to the table settings of a table to select the expanded fields. Hide the first section in the Row Display. The first section normally displays the field name and the first line of each field. If you hide it, and select some fields to be displayed in the Expanded Fields Section, all the lines of the selected fields can be displayed. This makes for easier browsing through the rows. Go to the table settings of a table to hide the first section in the Row Display. The Expanded Fields Section now is sized better when multiple fields are expanded. The SQL Console now has a "Functions" button that presents a window showing all the functions available in the app. Tap the function to see its description if it has one. There is a Long-Presses section in the Help in the app info, describing the long-press shortcuts in the app. The release date of the SQLite library used in the app is shown in the Diagnostics in the app info. SQLite 3.32.2 Bug fixes. NOTE: This is a major release. If you have critical databases, you MUST back them up before updating your software. To back them up, share them with your computer using AirDrop, or upload them to iCloud or Dropbox.

May 5, 2020

- Fields with the Text field format can now have the "Show Expanded" style. This lets you see multiple lines of a field in the Row screen in an expansion section underneath the fields. Useful when navigating up and down through rows. - Bug fix: Fields with the Number field format are shown without formatting if the accessory button is tapped.

March 24, 2020

- Allow override of the number of "Fields to Show" in a table's settings. - Allow override of the "Row Format" in table's settings. - Number fields with the format style None can be edited in-line. - Override format styles of Number fields with field format style of None. - In the "Tables Display" section of the App Info, the "Show Detail Button" option was removed as it was replaced with long press. Even though this is a minor release, it is prudent to back up your critical databases and files before updating the app. To back them up, either use Dropbox or iCloud, or sync them with your computer.