DBeaver: Difference between revisions

Revision as of 15:45, 5 December 2018

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&

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 16: / Line 16: @@
   sudo dpkg -i Downloads/dbeaver-ce_4.3.3.1_amd64.deb
-=== Run ===
+=== Start ===
 The app is based on eclipse, start dbeaver to fire it up.
   dbeaver&
-IT WILL PISS YOU OFF AT FIRST because of these stupid things:
+==== Drivers ====
-* After connecting to postgres: #db > right-click > Set active
-* Drill into #db > Schemas > public > Tables > #table > Read data in SQL console
-* THEN YOU CAN WRITE SQL, ffs
-=== Drivers ===
 * Right-click in Database Navigator > rclick > Create new connection > type [postgres] or [sqlite]
@@ Line 32: / Line 27: @@
 * 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:
+* After connecting to postgres: #db > right-click > Set active
+* Drill into #db > Schemas > public > Tables > #table > Read data in SQL console
+* THEN YOU CAN WRITE SQL, ffs