TablePlus does all these and in some cases I’ve felt like its done a better job of them compared with some of the alternatives I’ve tried.
Most of them offer some form of autocomplete, syntax highlighting and query reformatters so that you can beautify your code. Query editorĮvery database app I’ve used has come with a query editor.
Sequel pro autocomplete update#
Of course, the same can be achieved by writing your own update query which brings me to the Query Editor. You can also easily modify multiple rows via the row detail pane that can be toggled on or off on the right hand side of the window so you can quickly select multiple rows and then set a value to be saved to all of them. TablePlus also highlights any pending changes until they are committed. This acts as a handy guard against accidentally changing something on a database, especially a production one. There are buttons in the toolbar for discarding all the changes, previewing them and committing them to the database. However, TablePlus won’t save your changes until you are ready to commit them. Much like other database apps you can edit rows directly inline. The way that editing a table’s data works in TablePlus caused me a little confusion at first but has since become one of my favourite features. TablePlus also provides a simple interface for restricting which columns are shown as part of its table editor. I find this part of the app superior to the alternatives out there. TablePlus makes it easy to add multiple filters (including raw SQL) and then toggle them off and on individually. It’s better integrated into the interface. 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.
Sequel pro autocomplete 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)
