There is a nice filtering option that allows to select and highlight only records that match a series of conditions. The SQL query editor allows to write specific SQL queries that can be sent to the database server. It is possible to browse each table and edit records by double-clicking on the data cell and “comitting” the change. I only tested it with SQLite and MySQL databases.īelow is a list of nice features, but you will probably learn more by following the online tutorial. TablePlus works with standard SQL databases (MySQL, Postgres and SQLite) but it also supports NoSQL backends such as Redis, Cassandra, or Vertica. Compared to PHPMyAdmin, which I used on remote servers, TablePlus is a native and quite responsive app, which helps to focus on the data tables rather than the UI. If you don't click on it you don't get the alert. For example the Dark Theme in TablePlus seems cool : if you click on the option, you get the alert. The other way is to avoid annoying people, but still without offering them the feature.
#TABLEPLUS WACKY SOFTWARE#
Although I primarily use a terminal to interact with my local SQL server (yes, I know, OVH does not allow remote connection and I’m reduced to making dump of my databases to work on them locally!), I found that TablePlus does things right. They can also uninstall the software and use another one.
TablePlus, in the spirit of Postico or Induction (RIP), is a minimalist frontend to MySQL where you can visualize and query your records in just a few clicks. I discovered this app several months ago and I never used it for real, except for testing a toy example before one of my latest course. Here is a quick review of TablePlus which is a lightweight app that all Mac users should fell in love with when it comes to querying SQL databases.
0 kommentar(er)
