Today’s protagonist is TablePlus, a very good local native database management software, with clients on Mac/Win, supporting Oracle, Microsoft SQL Server, SQLite, Vertica, Cockroach, MySQL (MySQL 8), PostgreSQL, MariaDB, Redis, Cassandra is a variety of database types.
TablePlus is developed with high-efficiency language such as Swift. The original biochemical design makes this software very reasonable for system resources. It helps users manage countless database tables in multiple database connections at the same time. The flexible interface interaction design makes the switching task very simple.
For the first time using this software, click “Create a new connection” on the lower right side to create a new database connection, but the entrance style design of this new button is so low-key and simple, it is hard to understand, but the backup on the left side, the restore button does Very refined.
To create a new link, you can choose to set a status color or tag for the period, enter the name of the database above, enter the database management user information and the account information of the SSH remote link. You can select psw or key to access the database.
Getting Started TablePlus
A summary of all the contents of the database
TablePlus can search all the contents of the database, such as various tables, views, snapshots and functions. Click on the magnifying glass in the top toolbar to pop up a Spotlight-like search box, you can enter any content of the database, the software will automatically associate when searching As a result, you can use the arrow keys to select the content and press Enter to go directly to the target position.
In the table view, you can double-click on the project to edit the content, or edit the content in the details bar on the right column.
The table data modified in TablePlus needs to be saved before it can take effect. There are two ways:
Use the segment controller in the upper left corner to directly select Save (the rightmost button in the figure below, the two on the left are the abandonment of the edit results and the preview results)
Use the key combination: Command + S.
All changes will be credited to the history channel.
Use the SQL language editor
Click the SQL button below the search magnifying glass to go directly to the SQL language editor, or use the key combination ⌘ + Return (or ⌘ + E).
The built-in command preview window can visually show you all the results, while the fields that have been created, deleted, and modified are marked with different background colors:
When editing a command, TablePlus will automatically recommend the field name to you:
Excuting an order
After editing the command, click the Run All button in the lower right corner of the “Run Current” button, or use the key combination ⌘ + Enter to start executing the command.
Create a data table
Click the button marked in the red box below or right-click on an existing data table item to create a new table and confirm the new operation with the key combination ⌘ + S.
Filter display fields
Click on the “Columns” button at the bottom to add any table fields to filter.
The software also provides a variety of numerical filtering features for all fields, such as a set of complex filtering mechanisms that filter user comment time and comment content, as well as conversion to SQL commands.
Database editing interface switching form is rich
TablePlus’s editing interface switching format is very rich, for example, you create a new database link, there are multiple databases, you can use the left navigation to switch, you can also use the key combination “⌘+Shift+\” to switch directly to the “Tabs” interface. The latter is the same as Safari’s web page switching design, which is ideal for switching between databases.
Advanced play method
SSH login supports keyboard interactive authentication mode
The latest version of TablePlus supports the third type of SSH protocol authentication, which is the keyboard interactive authentication method. This method is especially suitable for the two-step verification login method. There are two SSH authentication methods that we often use before, namely:
Based on the password authentication method, the login verification of the remote machine is performed by inputting the user name and password. This is the commonly used method;
Based on the public key authentication method, the user’s login authentication is implemented by generating a set of keys (public key/private key). This method is relatively safe, but it is cumbersome to operate.
TablePlus’s new keyboard interactive authentication method is to send a prompt message to the client through the server, and then the client sends it back to the server through manual input according to the corresponding information. When the client logs in, in addition to the password, you must enter the instant verification code for the 2-step verification push.
Import database link URL
If you feel that the way to enter the account password to log in to the database is troublesome, you can try to generate the entire login operation as a URL, and then directly paste the URL to complete the login when the software creates a new database link.
History and collection
All operation records can be found in the “History” list. If this record is useful, you can right click and add to the “Favorites” list.
Browse by column
The design of the column browsing is convenient for the user to perform two sets of “write/run” commands at the same time:
Support hotkey operation
With KeyCue you can quickly get familiar with TablePlus’s key combination operations:
Create Keyword Binding Quick Execution Command
For commands that need to be executed frequently, you can create Keyword Binding, which automatically expands the complete command statement and automatically executes it each time you enter an abbreviation. That is, similar to Text Expander, you can set an abbreviation snippet. After input, you can expand the complete text paragraph. ,Steps:
Select a group of commands
Add to favorites
Enter Keyword Binding in the edit window
Execute Cmd + S save
For example, the statement in the figure below, its Keyword Binding is q30p90
Now just type q30p90 to complete the fast execution of the statement.