Need a quick edit on the go? Download TablePlus for iOS. Not on Mac? Download TablePlus for Windows. There’re more to it, but it’s better to try the app and feel it yourself. I particularly use TablePlus to connect to Cassandra database clusters across multiple environments simultaneously from different tabs. I can also keep a track of the queries from the history tab which is particularly useful for me on a daily basis. If one editor is not enough, you can split the current editor into many different editors that run separately. TablePlus help me to connect and query a wide range of databases from one single tool. When you have more than one query and need to execute them simultaneously, or you have a stored procedure with multiple select queries, TablePlus’ Query Editor can split the results into multiple tabs so you can view each separately. You can add it to favorite and assign a keyword for reference and call it quickly using that keyword later. 1592528567.644 ERROR (clusterconnector. There are some queries you want to reuse in different contexts or with different objects quite frequently. The query history feature will help you record all executed queries so that later you can come back and see if you made a mistake somewhere, or just to reuse. Query History and Keyword Binding Favorite ![]() That means it won’t block the UI, you can do other tasks while waiting for a long run query.Ĥ. The fetching progress is also a background task. When you have a slow connection or need to fetch a table containing megabytes of data each row, TablePlus will fetch and show them one by one. The best part is that TablePlus supports streaming results row by row. When writing multiple queries in the SQL Query editor, apart from selecting with cursor position and executing each query separately, you also have an option to execute all queries at the same time. When typing an SQL query in the SQL editor, it will perform an auto suggestion for SQL keywords and database objects such as table, column, procedure, function…, to help you finish writing queries faster without having the hassle of remembering stuff. TablePlus’ SQL editor supports auto-completion and auto lookup. TablePlus offers native support for a handful of drivers and the query editor supports each driver’s features and syntax correctly. SQL is the standard query language used in every relational database management system, however, it might vary as each database has its own extension and functionalities. ![]() Highlighting the syntax not only helps improve the readability and context of the queries but also prevents having some human errors such as typos. TablePlus provides a powerful SQL query editor that boost your productivity tremendously. ![]() TablePlus is a modern, native client with intuitive GUI tools to create, access, query & edit multiple relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Oracle, plus Cassandra and Redis.Įven though TablePlus allows users to browse and manipulate data effectively through an intuitive table tool with inline editing, import and export CSV, multiple filters, safe mode, code review…, writing queries is still an inevitable part of working with the database and having a good SQL query editor would save a lot of time and effort. Query History and Keyword Binding Favorite.To learn more about it, go here.Tl dr: TablePlus offers a handy SQL query editor with: The price shown here is for the "Full Version". Note: TablePlus can be used for an unlimited amount of time for free with the featured-limited trial download. Customizable Appearance: You can choose the appearance and config the shortcuts that best match your personal taste. ![]() Powerful SQL Editor: We've built the best practices for SQL Editor into our defaults to help you boost your productivity, including: Beautify SQL, Highlight Syntax, Split Results into Tabs, Split pane Horizontally and many more.Multi Tabs and Code Review: Quickly get a snapshot of your database with multi-tab and multi-window view, as well as stay in control of what you have changed on your database with Code Review.It’s also equipped with many security features to protect your database, including native libssh and TLS to encrypt your connection. Native, Fast, and Secured: Query, edit, and save your database easily with a native app that can run really fast.TablePlus is a modern, native, and friendly tool to manage multiple databases including MySQL, PostgreSQL, SQLite, SQL Server, Redis, Cassandra.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |