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.

Table plus create database