Bruno Almeida brunomgalmeida

brunomgalmeida / decrypt_dbeaver.py

Created August 6, 2020 09:09 — forked from felipou/decrypt_dbeaver.py

DBeaver password decryption script


	# https://stackoverflow.com/questions/39928401/recover-db-password-stored-in-my-dbeaver-connection

	import sys
	import base64

	print(sys.argv[1])

	PASSWORD_ENCRYPTION_KEY = b"sdf@!#$verf^wv%6Fwe%$$#FFGwfsdefwfe135s$^H)dg"

brunomgalmeida / decrypt_dbeaver.py

Created August 6, 2020 09:09 — forked from felipou/decrypt_dbeaver.py

DBeaver password decryption script - for newer versions of DBeaver


	# https://stackoverflow.com/questions/39928401/recover-db-password-stored-in-my-dbeaver-connection

	# requires pycrypto lib (pip install pycrypto)

	import sys
	import base64
	import os
	import json
	from Crypto.Cipher import AES

brunomgalmeida / jsonb_generic.sql

Created July 8, 2020 14:51 — forked from kmoppel/jsonb_generic.sql

	DROP TABLE IF EXISTS pgbench_generic_log;
	CREATE TABLE pgbench_generic_log (
	mtime timestamptz not null default now(),
	action char not null check (action in ('I', 'U', 'D')),
	username text not null,
	table_name text not null,
	row_data jsonb not null
	);

	CREATE INDEX ON pgbench_generic_log USING brin (mtime);