DBeaver: Difference between revisions

From Bitpost wiki
No edit summary
 
(7 intermediate revisions by the same user not shown)
Line 4: Line 4:


  sudo add-apt-repository ppa:serge-rider/dbeaver-ce
  sudo add-apt-repository ppa:serge-rider/dbeaver-ce
  sudo apt-get update
# [ENTER] to continue
  sudo apt-get install dbeaver-ce
  sudo apt update
  sudo apt install dbeaver-ce
 
[https://github.com/dbeaver/dbeaver/issues/2355 See here] for ppa discusion.


==== deb ====
==== deb ====
Line 13: Line 16:
  sudo dpkg -i Downloads/dbeaver-ce_4.3.3.1_amd64.deb
  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.
The app is based on eclipse, start dbeaver to fire it up.


  dbeaver&  
  dbeaver-ce& # or use albert


=== Drivers ===
==== Drivers ====


* Right-click in Database Navigator > rclick > Create new connection > type [postgres] or [sqlite]
* Right-click in Database Navigator > rclick > Create new connection > type [postgres] or [sqlite]
Line 24: Line 27:
* Alternately, you can open a sqlite file, it will prompt to download sqlite driver
* Alternately, you can open a sqlite file, it will prompt to download sqlite driver
* Good to go!
* 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

Latest revision as of 16:00, 26 August 2023

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

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:

DBeaverAutosync.png

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