![]() Working with the Northwind Sample Database Hit “Test” and “Connect” if it all looks good. Just like a regular PostgreSQL cluster, password authentication for the “postgres” user is disabled, and hence no password should be specified to get started. Note: By default in the configuration screen, port 5432 is used, and this should be changed to 5433. Assuming you installed the Northwind sample database, specify it as the database you want to connect to by default. In YugabyteDB, by default the hostname and port number are localhost and 5433 respectively. Right-click on the blank canvas to create a new connection and select “PostgreSQL”. Once you have downloaded, installed and opened up the TablePlus application you’ll see the To get the latest version, check out the TablePlus download page. In this how-to we’ll be focused on getting up and running on a Mac, although YugabyteDB and TablePlus supports the most popular operating environments. ![]() The instructions for how to get up and running in just a few minutes can be found in our previous blog post, “The Northwind PostgreSQL Sample Database Running on a Distributed SQL Database.” For the purposes of this blog post we’ll be using the Northwind sample database. Prerequisitesīefore we get into TablePlus, you’ll need to set up YugabyteDB and install a sample database. For more info, check out their pricing page. In a nutshell, the free trial is limited to 2 opened tabs, 2 opened windows, 2 advanced filters at a time. To get started there is a free trial and paid for version. TablePlus is a modern, native, and friendly GUI tool for relational databases including MySQL, PostgreSQL, SQLite & more. ![]() Similar to Google Spanner, YugabyteDB gives you all the scalability characteristics of NoSQL, without sacrificing the ACID transactions or strong consistency you are accustomed to with PostgreSQL. YugabyteDB is a PostgreSQL-compatible database. What’s YugabyteDB? It’s a high performance distributed SQL database for global, internet-scale apps. in this post we’ll show you how to get up and running with YugabyteDB and TablePlus. In a previous posts we covered how to get started with DBeaver, PGAdmin, and SQL Workbench/J. Whether it is for creating schemas, ad-hoc querying, backups, or diving deeper to troubleshoot a database issue, a database tool can make your life much easier and increase your productivity. That didn't work, but its behavior of adding it to the pane where the cursor was last works well.If you’re a database developer, you already understand the importance of a tool to manage your databases. Could this concept be expanded to include query results? My first instinct was also to try dragging and dropping one of the queries from my history into the desired pane. In addition to the query, it has the timestamp my terminal doesn't have that. The app has a nice query history sidebar. It would be nice to have a table view in one pane, and a query editor in the next. ![]() One limitation in the current implementation is it looks like table views need to take up the whole tab. Terminal has a lot of other disadvantages, but I've accumulated a lot of tricks to mitigate them.Ī nice implementation of tabs and panes could chip-away at that advantage, definitely, so this app is exciting. This is great for comparing results, printing out a few table schemas to help write a query, and acting as kind of a log of my thought process. The main reason I've been using the terminal instead of SequelPro is my terminal has the scrollback available from my previous queries. Today, I use mysql in the terminal most of the time. When you click on a row it also appears in a vertical orientation in the sidebar on the right, that's a nice touch. I love having multiple panes, multiple tabs, and good shortcuts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |