#Tableplus see field restrictions pro#
Filtering TablesĬompared with Sequel Pro filtering data feels a lot slicker. Tabs can be the spreadsheet-like editor of a table or TablePlus’ SQL editor. I also like that you can have multiple tabs for each open connection. If it doesn’t then I’d love to see this get added. It possibly already exists, but I haven’t seen this yet.
#Tableplus see field restrictions code#
One feature that would be really nice to have would be a proper Command Palette that lets you also fuzzy search for commands available in the menus like seen in the code editors I’ve just mentioned. This is really slick and I’ve found it really helps me work with servers that have many databases or databases with many tables. TablePlus comes with a similar feature: Open Anything allows you to call up a fuzzy search field via a keyboard shortcut to search a connection’s databases, tables and functions. I regularly work with Visual Studio Code (and before that Sublime Text) and love being able to quickly switch between projects and files via the Command Palette shortcut. It means that when I am working with a database I can clearly see whether I am playing with live data or just some local test data that doesn’t matter too much if it gets messed about with. 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. 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.
0 kommentar(er)
