Export Sqlite Database on Android using adb (no Android Studio needed)

have you ever wanted to export sqlite database while debugging ? worry no more here is the command :

sudo adb exec-out run-as com.YOURPACKAGE cat databases/db.sqlite3 > out.sqlite3

OpenSSH client on Windows

if you are on Windows and have problem connecting to private repository in gitlab or github try this :

  1. go to services, enable OpenSSH Authentication Agent
  2. make sure openssh is in PATH C:\Windows\System32\OpenSSH
  3. add ssh key password type ssh-add on powershell
  4. Add the environment variable $ENV:GIT_SSH=C:\Windows\System32\OpenSSH\ssh.exe to your session, or permanently to your user environment.

  5. type

git config --global core.sshCommand C:/Windows/System32/OpenSSH/ssh.exe

or

git config --global core.sshCommand C:\\Windows\\System32\\OpenSSH\\ssh.exe

which will create a .gitconfig file in home directory

[core]
    sshCommand = C:/Windows/System32/OpenSSH/ssh.exe

OpenSSH client

if you are on Windows and have problem connecting to private repository in gitlab or github try this :

  1. go to services, enable OpenSSH Authentication Agent
  2. make sure openssh is in PATH C:\Windows\System32\OpenSSH
  3. add ssh key password type ssh-add on powershell
  4. Add the environment variable $ENV:GIT_SSH=C:\Windows\System32\OpenSSH\ssh.exe to your session, or permanently to your user environment.

  5. type

git config --global core.sshCommand C:/Windows/System32/OpenSSH/ssh.exe

or

git config --global core.sshCommand C:\\Windows\\System32\\OpenSSH\\ssh.exe

which will create a .gitconfig file in home directory

[core]
    sshCommand = C:/Windows/System32/OpenSSH/ssh.exe

postgre

enter postgre shell

psql

check is truly initialized

pg_isready

check systemd service

sudo systemctl status postgresql

change UNIX user postgres password

sudo passwd postgres

Creating user

 sudo -u postgres createuser <username>

Creating Database

sudo -u postgres createdb <dbname>

Giving the user a password

psql

\password <username>;

Granting privileges on database

psql 

grant all privileges on database <dbname> to <username> ;

Grant superuser

ALTER USER myuser WITH SUPERUSER;

Remove superuser status:

ALTER USER username WITH NOSUPERUSER;

check user

psql

\du

Debian Thinkpad E14

are you are using a thinkpad or maybe any laptop ? here is my tips : don't use default installer in debian.org website. it will be such pain if you do. because wifi, sound, bluetooth will be disabled. because the default installer don't have firmware needed.

instead you should install nonfree installer that have firmware.
https://cdimage.debian.org/cdimage/unofficial/non-free/cd-including-firmware/11.2.0+nonfree/amd64/iso-dvd/