DBeaver: Difference between revisions
No edit summary |
|||
| Line 31: | Line 31: | ||
IT WILL PISS YOU OFF AT FIRST because of these stupid things: | IT WILL PISS YOU OFF AT FIRST because of these stupid things: | ||
* | * You need to change an "Editors" setting: | ||
* Drill into #db > Schemas > public > Tables > #table > Read data in SQL console | * Drill into #db > Schemas > public > Tables > #table > Read data in SQL console | ||
* THEN YOU CAN WRITE SQL, ffs | * THEN YOU CAN WRITE SQL, ffs | ||
Revision as of 23:43, 30 December 2018
Install
PPA (preferred)
sudo add-apt-repository ppa:serge-rider/dbeaver-ce # [ENTER] to continue sudo apt update sudo apt install dbeaver-ce
See here for ppa discusion.
deb
- Download the 64-bit deb file
- Install:
sudo dpkg -i Downloads/dbeaver-ce_4.3.3.1_amd64.deb
Start
The app is based on eclipse, start dbeaver to fire it up.
dbeaver&
Drivers
- Right-click in Database Navigator > rclick > Create new connection > type [postgres] or [sqlite]
- You will be prompted to set up the drivers, noice
- Alternately, you can open a sqlite file, it will prompt to download sqlite driver
- Good to go!
How to write queries
IT WILL PISS YOU OFF AT FIRST because of these stupid things:
- You need to change an "Editors" setting:
- Drill into #db > Schemas > public > Tables > #table > Read data in SQL console
- THEN YOU CAN WRITE SQL, ffs