In production I use a managed redis cluster which does not support multiple databases so I avoid using more than one database in the redis server. Note: the prefix setting is used instead of using different database number to be able to segment the keys. It's currently available for macOS, Windows, iOS, and Linux.//the redis client (requires installing the phpredis.so extension using pecl) 'client' => 'phpredis', //the redis driver 'redis' =>, //the `default` connection of the redis driver //Note: The Laravel Redis facade is hard coded to use this connection unless its connection is explicitly specified 'default' =>, //the `cache` connection of the redis driver 'cache' =>, //the `queue` connection of the redis driver 'queue' =>, //the `session` connection of the redis driver 'session' =>, ], You can check it out at TablePlus website. This plugin system allows TablePlus to always be simple with the necessary features while having the ability to be extended and personalized without being too bulky.Įven though TablePlus is still in its early days, it is very well suited for everyday SQL tasks, from the basic to advanced ones. You can install plugins written by others or write your own plugin in Javascript. For example, to use the filter, simple press cmd + F. Writing query is more efficient with code completion feature, along with some of the best practices for SQL editor: Beautify SQL, Highlight Syntax, Split Results into Tabs, Split pane Horizontally that are all included in TablePlus.Įvery function in TablePlus is assigned to a shortcut key, which later you can customize, makes it quite handy for a lot of people. It can hold multiple statements then you can choose to run the current statement where the cursor is pointing at or run all statements. The core feature of TablePlus is its powerful query editor. Using code review, you can stay in control of what you’ve changed on your database and reverse it anytime. Since TablePlus supports multiple drivers including PostgreSQL, MySQL, SQLite, MS SQL Server, Redshift, Redis, MariaDB, you can work with a lot of different databases at the same time without having to switch between different apps.Īfraid that you made a silly mistake somewhere? Not anymore. With its multiple tabs and multiple windows view, you can get a snapshot of your databases and manages them simultaneously. You can apply multiple filters to quickly filter out the records you want to see. Each filter contains there simple boxes: a dropdown list of the column name, common conditions such as “equal”, “contain”, “IS NULL”,… and one text box to fill the value. ![]() While browsing data, there’s a very cool filter that you can pop up near the top window. You can use TablePlus to browse and edit data directly in the grid without having to write SQL code. That’s how you can secure your connection and protect your database. TablePlus only accepts connections from itself and prohibits connections from the outside. Because ssh tunneling is a part of TablePlus, the application can control the number of connections through ssh. Instead of using open-ssh to create a tunneling that might leak your connection, TablePlus has implemented its own ssh lib with () and secured the port. It offers many security features to protect your database, including native libssh and TLS to encrypt your connection. It automatically establishes the SSH tunnel to the correct port and logs you in seamlessly. It gives you the power to edit your data and database structure easily.Ĭonnect to your database in a fast and secure way. Ok, let’s dive in, what can TablePlus do for you? And because of the native build, it can get up and running in less than a second. ![]() This post I’m introducing TablePlus as a tool to manage your database easily.Īt a glance, TablePlus has a very well-designed interface that makes it easy for new users to adapt to the tool. You also need a more convenient query editor. You might run into a situation where you need to access multiple databases at the same time with complex queries but it’s not fast enough. ![]() If you’re working with database on a regular basis, finding a good GUI tool is like making friends for life. It supports Postgres, MySQL, SQLite, MS SQL Server, Redshift, Redis, MariaDB. TablePlus is a native tool with an intuitive interface that you can use to create, query, edit and save your databases in a very fast and secure way.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |