Lastly, it is as easy to import a CSV file into a given table or to export query results to CSV, JSON or SQL. 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.
Querying system tables to get cluster topology information. Querying system.schema tables directly to get keyspace, table, and column information. 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. Details about Cassandra database objects and cluster configuration in the system keyspace tables. 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. 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. 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)
