ceobad.blogg.se - Tableplus app

On top of that you can assign colours and label connections as things like Production, Staging or Local. Databases can be grouped (much like in Sequel Pro), but each group can be given a custom icon to distinguish between them. You can easily sort and label your different database connections so that they are easy to work with. I mainly deal with MySQL/MariaDB connections, but also have some data stored in Redis, so being able to use one app to access all of them is really useful. It even supports in-memory databases like Redis. Unlike some of the alternatives that I have used in the past like Sequel Pro and PHPmyAdmin it supports PostgreSQL, SQL Server, Mongo and SQLite as well as MySQL (and the MariaDB fork). Connectionsįirst up, TablePlus will connect to virtually any database type you could ever need. Just to be clear, this is a personal piece I have not been paid to write this and have no affiliation with TablePlus or its developers. I want to share with you some of the reasons why I like it. However, rather than let another month pass by without me contributing to this site I thought I’d write something a little different to normal.įor the last few months I’ve been using a great app for working with databases called TablePlus.

We’re currently enduring a heat wave with record breaking temperatures so focusing on anything is feeling like an up hill battle.

From there, you can click on individual rows and edit their values in the right sidebar, or double-click on a specific cell and edit it directly.The last few months have been a bit hectic for me and so I’ve not had a lot of time to devote to writing on this site. Double-clicking a table opens it in the main workspace. Once you've established the connection (by clicking "Connect"), you're good to go! You can select schemas from the menu on the bottom left and view a list of tables on the left sidebar. Select PostgreSQL and click "Create."Ĭopy the connection details as shown in the "Connect" menu on the bit.io repo page. This can be found by signing in to bit.io, clicking "Connect" on the upper right side of the page, and copying the PostgreSQL Connection String.

Select "Import from URL" and paste in your PostgreSQL Connection String.

There are two ways to create the connection at this point. Right click in the area on the right or click "Create a new connection" at the bottom.

Troubleshooting Common Connection IssuesĪfter you've installed and opened TablePlus, you'll see a screen that looks like this:.

Python-psycopg2 and the bit.io Python SDK.

Programming Language PostgreSQL Interfaces.

JetBrains IDEs (IntelliJ, P圜harm, DataGrip, etc.).