Single connection mode
dbeaver usually opens multiple connections to databases. If you have limited connections, then it is necessary to restrict the pool size or connection numbers. Since dbeaver does not have a “Single connection mode”, a few tweaks are necessary.
Disable using one exclusive connection for metadata:
Uncheck:
> File
> Properties
> Metadata
> Open separate connection for metadata read
Disable using exclusive connections for SQL Editors:
Uncheck:
> Right mouse click in SQL Editor
> Preferences
> DBeaver
> Editors
> SQL Editor
> Open separate connection for each editor
Loading extensions in SQLite
It is possible to load SQLite extensions in the Community Edition:
> Set enable_load_extension = true in the Driver Properties tab
> Enter Connection Initialization Settings
> Create a query with SELECT load_extension('name.so')