Syntax Create table KeyspaceName.TableNameġ. Column family is used to store data.Ĭommand ‘Create Table’ is used to create column family in Cassandra. Lastly, it is as easy to import a CSV file into a given table or to export query results to CSV, JSON or SQL.The syntax of Cassandra query language (CQL) resembles with SQL language.Ĭolumn family in Cassandra is similar to RDBMS table. 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. 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)
