DBeaver: Difference between revisions

Latest revision as of 16:00, 26 August 2023

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.

sudo dpkg -i Downloads/dbeaver-ce_4.3.3.1_amd64.deb

The app is based on eclipse, start dbeaver to fire it up.

dbeaver-ce& # or use albert

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!

IT WILL PISS YOU OFF AT FIRST because of these stupid things:

@@ Line 1: / Line 1: @@
 === Install ===
+==== PPA (preferred) ====
+ sudo add-apt-repository ppa:serge-rider/dbeaver-ce
+ # [ENTER] to continue
+ sudo apt update
+ sudo apt install dbeaver-ce
+[https://github.com/dbeaver/dbeaver/issues/2355 See here] for ppa discusion.
+==== deb ====
 * [https://dbeaver.jkiss.org/download/ Download] the 64-bit deb file
 * Install:
   sudo dpkg -i Downloads/dbeaver-ce_4.3.3.1_amd64.deb
- dbeaver& # open a sqlite file, it will prompt to download sqlite driver, good to go
-=== Set up foreign keys ===
+=== Start ===
+The app is based on eclipse, start dbeaver to fire it up.
+ dbeaver-ce& # or use albert
+==== 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:
+[[File:DBeaverAutosync.png]]
+* Drill into #db > Schemas > public > Tables > #table > Read data in SQL console
+* THEN YOU CAN WRITE SQL, ffs