DBEAVER is a very open SQL open SQL, but there are several factors that people do not know. In this case, I will share with you several features to speed up your work travel, zero fluff.
I've read these as I am currently grinding in deeply on the tools I use every day, starting with DBEAVER. In the next post, I will compare work between DBEAVER VERSAS to create your SQL development environment in vscode (or cursor). If you are interested in that, make sure you follow my books!
However, today, it is very focused on learning the coolest DBEAVA features. Let's get started.
Command of the command
This is one of the most powerful but hidden features in DBEAVER. Maybe people don't care because it is not called “Command Palette”. You can open it with CMD + 3 (Mac) or CTRL + 3 (Windows).
From here, you can basically any action in a long. I use it a lot for you:
- To switch between SQL documents.
- Navigation in specific settings.
- Right Access to actions such as shipping results, update schema, open templates, reset file, etc.
(Officially, this feature in DBEAVER is called “Find Acts.”)
SQL SQL format
Did you know that you can easily set out a different form in DBEAVER? I'm not a person who likes the default formatting, and as I use mainly PostgreSQL, I like PG_Formter.
Let me show you how it works for PG_Formter, but remember that the process will be the same and any relevant SQL you can call the end.
# Install PG Formatter
brew install pgformatter
# Find where the program is located.
# In my case: opt/homebrew/bin/pg_format
which pg_formatNext, go to The benefits → Organizers → The SQL Store → Formatting, select “form for Fefer,” Then paste the way to your desired format.
💡 or you can only open the command palette and search “to format”.
Expand columns in select
Usually, you may need to select multiple columns on the table, do not enter a few. DBEAVER Makes this easy by increasing your * Choice of column names.
You can do this with CTRL space + Hotkey, both in Mac or the windows. This may not work if you have one of the system shortcut, where you can look “the content helps” in Command Palette.
Find Quickly Find Column Mathematics
DBEAVER has a large number of features of speed up your analysis. One of them regularly applying “Calc Tab”, is at the right of your Question results. It allows you to get information immediately about columns in your question results.
Here's what you can do about:
- Find the amount of different numbers and are not null of the column of the category.
- Get minutes, Max, said, Median, etc.
It is very suitable for quickly understanding your data!
Ad-Hoc groups
Similarly in the Calc tab, “Groupings Tab” allows you to quickly create a group – questions without writing SQL manually.
What you can do about:
- Immediately sleep price prices.
- Add multiple components.
Although this is very good for simple characters, I find it slightly reduced as there is no different price rates, as I do the above, without handwriting.
SQL templates
SQL templates have great power, even though I admit that I don't use it as often as you can. Templates saves you from writing and even regular expressions.
You can see the built-in templates by opening the Command Palette and you want to “templates”. You will see the shortcuts of:
SELECT * FROM {table}SELECT * FROM {table} WHERE {col} = {value}- And some, like choosing and order, counting groups, etc.
All you need to do is writing a shorthand for the question and press the tab:
You can also create your templates, which is not difficult as long as you copy existing and adapt.
Advanced Tips
You may already know the DBEAVER with major data shipping options. However, Standard Export Wizard can feel a little surprise, because it shows you tons of configuration, even if you want to remove CSV immediately.
The quick way to select the data on the results tab, by right clicking, and select “a higher copy”. By doing this, you can copy your data in multiple formats like CSV, JSON, Markdown, TXT, and SQL Add Statements.
I get this wonderful thing, especially when I need to quickly send the data to a colleague.
The bonus tip is to copy this data to TSV, well found in Excel and Google sheets of their right cells! This, you should make twice, according to DBEAVER 😅
Conclusions
I love DBEAVER like SQL edge. There is great power and the interface is very clean. Remembering that this tool is free and open. If you have never tried yet, I commend you!
I have never seen how many people talk about their very best and tricks, and many tips I have set from using the software. Likely, much I missed, especially when it comes to plugins, which I didn't use.
I know I'm through all the tips as soon as possible, so if you doubt, feel free to reach. Also, if you have many tips for work, I would like to hear about them!
Hope you learned something new!
If you want to know about other tips I did not do with this post, or enjoy reading about regular data headings, Sign up for my Free Newsletter of Expack. I publish whenever I have something truly interesting to participate.
Want to connect directly or have questions? Access anytime Mtrentz.com.
All photos and pictures, unless noted in another way, they are the author
