I found that having multiple tabs and windows can be distracting. There have been times I find myself wanting to fiddle with multiple queries side-by-side. Nothing worst then building a super awesome query and then losing it!Įxecuting select highlighted portions of your SQL + 'Execute Statement' hotkey The UI for the editor & query results is clear and intuitive.įairly self-explanatory, but the ability to easily save and load your queries is a must have in these client tools. On first load, you are presented with a few options that feel intuitive and easy to navigate.Īdding and saving configurations for accessing local or deployed databases is a breeze. Their biggest selling point is the minimalist UI in their product. Please purchase their license to support them if you have the means to :) Plus, you can use the free edition for as long as you want! I feel like these limitations aren't the most annoying for most use-cases. Here are the limitations as per their FAQ: The free edition of Postico does come with limitations but aren't those that would make you want to pull your hair out. There are some products out on the market that makes their free edition very annoying to use as a sales tactic. The free version of Postico provides enough utility to be useful and is not super annoying. I am just a web developer who thinks this can help others :). Note - I am not financial tied with the success of Postico. In terms of simplicity, ease of use, minimalism, I believe Postico is a great fit for beginners or a basic user that just wants to wipe up some queries quick. Of course, there are several PostgresSQL clients available with their various advantages & disadvantages. He suggested using Postico, a PostgresSQL client, and I've been happily using it since. Admittedly, I was also one of these developers until my boss at the time offered me an alternative. I've noticed on numerous occasions of developers that might be giving themselves a more difficult time practicing or playing with their PostgresSQL database using the default interactive terminal. If you have Dash installed, you can use the command "Look Up In Dash" in the context menu or press Ctrl-H to look up the current word (or selection) in Dash.Disclaimer - Postico is only supported by MacOSX. Use the command "Shift Left" in the "Edit" menu or press ⇧⇥ or ⌘[ to shift the selected line(s) to the left (decrease indentation). Use the command "Shift Right" in the "Edit" menu or press ⇥ or ⌘] to shift the selected line(s) to the right (increase indentation). Multiple selected lines can be indented at once. Multiple matches of the same suggestion will be grouped by type, use the left and right arrow keys to expand and collapse grouped suggestions. In the autocompletion window, use the arrow keys to select a completion, then hit the return key to confirm. You can also trigger autocomplete using the command "Show Completions" in the "Edit" menu. you are trying to "complete" a whitespace character). This mode can even be used if there is no word (e.g. Press Ctrl-Space or ESC, and Postico shows a list of all possible completions in a popup window, including additional matches related to the word you have typed. We tried to make the behaviour similar to tab completion in command-line tools like psql and bash. Press Tab again to display a list of possible completions in a popup window. When multiple completions are possible, you hear a beep. Tab Completion: Press Tab, and Postico automatically tries to complete the word you are typing.There are two autocomplete modes available in the SQL query view. To clear the result area, use the command "Clear Results" in the "Connection" menu or press ⌘K. Use the command "Execute All Queries" in the "Connection" menu or ⌥⌘↩︎ to execute all statements at once. You can switch between results using a popup menu button at the bottom left. When you execute multiple statements, Postico will display the first result. They will be executed in an implicit transaction, so if one of the statements fails, all changes to the database will be rolled back. You can execute multiple statements at once by selecting them. The corresponding results are displayed below the text view. Use the command "Execute Query" in the "Connection" menu or press ⌘↩︎ to execute the current statement (or the current selection, if any). The query view highlights the current statement in light grey. There's also a keyboard shortcut (⇧⌘T) to navigate to the query view. You can get to the SQL Query View by clicking on "SQL Query" in the sidebar. You are looking at the documentation for Postico v1.3.5 - would you like to go to the latest version instead? Using the SQL Query ViewĬustom database queries can be executed from the SQL Query view in Postico.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |