DBeaver - Revision history

M: /* Start */

2023-08-26T16:00:02Z

Start

← Older revision		Revision as of 16:00, 26 August 2023
Line 19:		Line 19:
	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 ====

2018-12-30T23:47:38Z

← Older revision		Revision as of 23:47, 30 December 2018
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:		* You need to change an "Editors" setting:

			[[File:DBeaverAutosync.png]]

	* 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

2018-12-30T23:43:01Z

How to write queries

← Older revision		Revision as of 23:43, 30 December 2018
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:
	* ~~After connecting~~ to ~~postgres~~: ~~#db > right-click > Set active~~		* 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

2018-12-05T15:45:09Z

← Older revision		Revision as of 15:45, 5 December 2018
Line 16:		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&

	~~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]		* 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		* 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:
			* 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

2018-12-05T15:43:45Z

Run

← Older revision		Revision as of 15:43, 5 December 2018
Line 19:		Line 19:
	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&

			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

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

2018-12-05T15:00:04Z

PPA (preferred)

← Older revision		Revision as of 15:00, 5 December 2018
Line 7:		Line 7:
	sudo apt update		sudo apt update
	sudo apt install dbeaver-ce		sudo apt install dbeaver-ce

			[https://github.com/dbeaver/dbeaver/issues/2355 See here] for ppa discusion.

	==== deb ====		==== deb ====

2018-12-05T14:55:29Z

PPA (preferred)

← Older revision		Revision as of 14:55, 5 December 2018
Line 5:		Line 5:
	sudo add-apt-repository ppa:serge-rider/dbeaver-ce		sudo add-apt-repository ppa:serge-rider/dbeaver-ce
	# [ENTER] to continue		# [ENTER] to continue
	sudo apt~~-get~~ update		sudo apt update
	sudo apt~~-get~~ install dbeaver-ce		sudo apt install dbeaver-ce

	==== deb ====		==== deb ====

2018-10-15T17:56:47Z

PPA (preferred)

← Older revision		Revision as of 17:56, 15 October 2018
Line 4:		Line 4:

	sudo add-apt-repository ppa:serge-rider/dbeaver-ce		sudo add-apt-repository ppa:serge-rider/dbeaver-ce
			# [ENTER] to continue
	sudo apt-get update		sudo apt-get update
	sudo apt-get install dbeaver-ce		sudo apt-get install dbeaver-ce

2018-10-13T01:12:04Z

← Older revision		Revision as of 01:12, 13 October 2018
Line 17:		Line 17:

	dbeaver&		dbeaver&
	~~# open a sqlite file, it will prompt to download sqlite driver, good to go~~

	=== ~~Set up foreign keys~~ ===		=== 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!

2018-10-13T01:04:17Z

Install

← Older revision		Revision as of 01:04, 13 October 2018
Line 1:		Line 1:
	=== Install ===		=== Install ===

			==== PPA (preferred) ====

			sudo add-apt-repository ppa:serge-rider/dbeaver-ce
			sudo apt-get update
			sudo apt-get install dbeaver-ce

			==== deb ====

	* [https://dbeaver.jkiss.org/download/ Download] the 64-bit deb file		* [https://dbeaver.jkiss.org/download/ Download] the 64-bit deb file
	* Install:		* Install:
	sudo dpkg -i Downloads/dbeaver-ce_4.3.3.1_amd64.deb		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
			=== Run ===
			The app is based on eclipse, start dbeaver to fire it up.

			dbeaver&
			# open a sqlite file, it will prompt to download sqlite driver, good to go

	=== Set up foreign keys ===		=== Set up foreign keys ===