DBeaver

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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-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:

Drill into #db > Schemas > public > Tables > #table > Read data in SQL console
THEN YOU CAN WRITE SQL, ffs