Quickly edit database from an iPhone

TablePlus iOS makes it easy to manage your database from a device as small as an iPhone.  

If you haven’t installed TablePlus iOS on your iPhone, get it here.

The following guide was demonstrated on an iPhone 6 (4.7 inches).

1. Inline edit

TablePlus open a database in a spreadsheet-like view. On a small screen like this one, you can save more screen space by hiding the left sidebar when you don’t need it. Simply drag its borderline to the left side.

With the table view, you can select and edit any data cell directly with a double-tap. 

If the value is long and you need more space to work on it, you can use the text editor instead. To use the text editor:

• Tap and hold on the data cell you need
• Select Text Editor from the popup menu
• Edit the long value in a bigger text editing view
• Tap outside of the editor to close it

2. Right sidebar

When you have a table with many columns, this right sidebar will help you view and edit a specific record easily and you will not mistake it for another row while scrolling. To use it, drag in the borderline on the right of the data table, then drag it out when you don’t need it anymore.

3. Advanced data filters

To quickly filter out the records you want to see, use this. By default, the filter is hidden above the data table and to use it, you just need to drag the upper borderline down.

4. Code review

The main concern for working on a small screen is that we might accidentally make a change, like a delete action, without knowing it. Then when we figure it out, it might be too late. TablePlus has an editing mode that is both convenient and safe to use. The change you have made will be pending, you can either review it first, choose to commit to the server or cancel it.

Furthermore, you can undo and redo all those changes easily using the classic combination of Cmd + Z, or holding the title bar and select Undo, everything is always under control.

5. Multiple tabs and multiple workspaces

When you work with multiple databases at the same time, it’s easy to open another table, or switch to another connection and have them active at the same time.