Users can then then select a user and find the admin section for the Create Temp Table privilege. Users can activate it by going to Connection > User Management.

Tick on Allow computer password/TouchID to unlock Safemode.įinally, users can Create Temporary Tables privilege in the MySQL User Management panel.

When these are on, TablePlus will recommend TouchID rather than passwords, though users can override this. Users can use computer passwords or TouchID as options. Safe mode enhancements: Users with Safemode enabled will need to enter the database's password every time they send a query to the server.

Users can ignore foreign key checks and delete by using Cmd + Delete. To change, select the settings button near the bottom left of the editors, select Query params options, then Change query params Regex.ĭelete items and ignore foreign key checks allows users to delete a table that has a foreign key check with a different table. Query params regex can now be changed between four variables:

To use double quotes, simply use the Shift key and the double quote (“) key.

Users also have the ability to wrap selected in quotes by highlighting strings in the editor and then pressing the quote (‘) key, which will wrap the highlighted area with the single quote. You can read our review of TablePlus for MacOS here.Īmongst numerous bug fixes and performance improvements, the changes include multiple cursors (carets) to enable multiple selection in TablePlus Query Editor.

The most recent version, designed for macOS 10.11 and newer, brings a number of new changes. It supports databases including: PostgreSQL, MySQL MariaDB SQLite Microsoft SQL Server Amazon Redshift Oracle CockroachDB Snowflake Cassandra Redis Vertica MongoDB (Beta) and any databases that use the same protocol with the databases listed above such as Percona, and Yugabyte DB. Users will also have the ability to edit inline, preview SQL, view data structure run custom queries and use advanced filters.Ĭurrently TablePlus provides apps across macOS, iOS and Windows. The beta app will include MySQL and PostgreSQL support, as well as an SSH tunnel with password/private key. TablePlus, a creator of GUI tools for relational databases, has provided a sneak peek of its new Linux app, due for release at the end of November.

Tableplus mongodb