Dbeaver Commit Types
The link below is the official Dbeaver documentation. Of note, setting your connection to Production uses manual commit as default unless you override the setting. Smart commit seems to be a good choice, but choose what best fits your project.
DBeaver CSV import tips
- Use "Insert Multiple Rows" option. Be careful. It defaults to 100 records. If there are too many fields it'll get a "too many parameters" error. Meds had 47 fields so I had to drop it to 25. That's still 25 times faster than not using the option and inserting one at a time. From experimentation I've found that you can calculate the maximum for a file by dividing 2095 by the number of fields in the CSV file.
Quoting Text
- You've seen this before. You have a query with a WHERE xxx IN () clause. You paste in a list of text: Item1, Item2, Item3, etc. and now you have to put a single qotue before and after each item. That's tedious.
- Instead highlight a word and press the single quote. it'll wrap the highlighted text in quotes!
Font Sizing
- Increase font size: Ctrl =
- Decrease font size: Ctrl -
*Of course it's Command for Apple, not Ctrl
Auto-Save
- Click Window at the top of the screen. Scroll down and click Preferences. Click Editors, SQL Editor, there are several auto-save options.
Exporting Data
- When exporting data based on a temp or derived table you must uncheck "Open new connection(s)".
Exporting Large CSV files
- On the third page of exporting CSVs you can split the file by size with this option:
