Posts

Showing posts from November, 2022

Useful GPG commands

 From  Useful GPG commands (iu.edu) Encryption/decryption commands To encrypt a plaintext file with the recipient's public key: gpg -e -r recipient_userid textfile To sign a plaintext file with your secret key: gpg -s textfile To sign a plaintext file with your secret key and have the output readable to people without running  GPG  first: gpg --clearsign textfile To sign a plaintext file with your secret key, and then encrypt it with the recipient's public key: gpg -se -r recipient_userid To decrypt an encrypted file, or to check the signature integrity of a signed file: gpg [-o outputfile] ciphertextfile Key management commands To generate your own unique public/secret key pair: gpg --gen-key To add a public or secret key file's contents to your public or secret key ring: gpg --import keyfile To extract (copy) a key from your public or secret key ring: gpg -ao keyfile --export userid or gpg -ao keyfile --export-secret-key To view the contents of your publ

DBeaver Shortcuts

From  DBeaver 6.0 Shortcuts - Cacher Snippet   CTRL + ENTER = Executes SQL. CTRL + ALT + ENTER = In Editor, inits statement templates ALT + X = Executes All queries in current editor CTRL + ALT + SHIFT + X = Execute a script opening each query results in a separate tab CTRL + ] = New SQL Editor Windows CTRL + SHIFT + F = Format SQL CTRL + 9 = Set active connection CTRL + 0 = Set active Schema CTRL + 6 = Toggle Results Panel CTRL + SHIFT + 6 = Maximize Results Panel Tab (when a datarow is selected) = Toggle vertical view CTRL + Alt + Right/Left (When in vertical view) = Browse rows CTRL + SPACE = To perform some object name auto-complete F4 = To open current object (under cursor) definition From  Shortcuts · dbeaver/dbeaver Wiki · GitHub Here is a complete list of default hotkeys in DBeaver UI for Windows, Linux, and macOS users. It will help you work in DBeaver faster and more efficiently. Remember that you can always change the keyboard shortcut in the DBeaver settings. Go through:  W