DEV Community: trycatch

5 docker commands to install PostgreSQL (Postgis), MongoDB, MySQL, and Redis

trycatch — Fri, 27 Nov 2020 08:58:37 +0000

PostgreSQL

docker run --name "postgresql" -p 25432:5432 -e POSTGRES_USER=your_user -e POSTGRES_PASSWORD=your_password -e POSTGRES_DB=your_dbname -t -d postgres

where (you can change them on your choice):

your_username is required PostgreSQL user
your_password is the user's password
your_dbname is db's name (notice that the missing db_name will be substituted by your_username)
25432 is a PORT available outside docker's container
postgresql is a key you can use for accessing the container

Hint: using 25432 (or any other rarely used) port prevents conflicts

You also can install it directly to your machine using this guide:

Article No Longer Available

PostgreSQL + Postgis

docker run --name "postgis" -e POSTGRES_USER=your_user -e POSTGRES_DBNAME=your_dbname -e POSTGRES_PASSWORD=your_password -p 25432:5432 -d -t kartoza/postgis

Hint: -d flag runs the container as a daemon: it starts in the background and you can continue working with the same terminal tab

where (you can change them on your choice):

your_username is required PostgreSQL user
your_password is the user's password
your_dbname is database's name
25432 is a PORT available outside docker's container
postgis is a key you can use for accessing the container

MongoDB

docker run --name "mongodb"  -p 28777:27017 -e MONGO_INITDB_ROOT_USERNAME=your_username -e MONGO_INITDB_ROOT_PASSWORD=your_password -d mongo

where (you can change them on your choice):

your_username is required MongoDB admin user
your_password is the user's password
28777 is a PORT available outside docker's container
mongodb is a key you can use for accessing the container

Hint: -t flag runs a pseudo terminal, therefore you can send different commands to the container

MySQL

docker run --name "mysql" -p 23306:3306 -e MYSQL_ROOT_PASSWORD=your_password -t -d mysql/mysql-server

where (you can change them on your choice):

your_password is the root password
23306 is a PORT available outside docker's container
mysql is a key you can use for accessing the container

Hint: you can add a volume for any container in this guide: it will store data on your machine nevertheless the container is removed or stoped, e.g. for mysql -v $HOME/docker/volumes/mysql:/var/lib/mysql, for postgres -v $HOME/docker/volumes/postgres:/var/lib/postgresql/data

Redis

docker run --name "redis" -p 26379:6379 -t -d redis

where (you can change them on your choice):

26379 is a PORT available outside docker's container
redis is a key you can use for accessing the container

Check out more DevOps stuff on my blog

Docker connect: permission denied [Solved] in Linux

trycatch — Thu, 19 Nov 2020 11:54:42 +0000

Problem

So you've got your docker up and running but on some day it says

Got permission denied while trying to connect to the
Docker daemon socket at unix:///var/run/docker.sock:
Get http://%2Fvar%2Frun%2Fdocker.sock/v1.40/images/json:
dial unix /var/run/docker.sock:
connect: permission denied

your user is already in docker group, so

sudo usermod -aG docker $USER

doesn't help

Solution

Bad:

sudo chmod 777 /var/run/docker.sock

Good:

sudo setfacl --modify user:$USER:rw /var/run/docker.sock

Install pgadmin4 using apt on Ubuntu 20.04

trycatch — Wed, 30 Sep 2020 08:16:49 +0000

Problem

You type sudo apt install pgadmin, press TAB and see only pgadmin3 in recommendations. pgadmin3 is currently obsolete and it doesn't even work properly with the latest PostgresQL!

Solution

1) Install pgadmin's public key (if you haven't done this before)

curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add

2) Add pgadmin's repo to your source list and run update

sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

3) Install the package

sudo apt install pgadmin4

4) Run pgadmin4 in the console or from the main menu (press Win button and type "pgadmin"), done!

Top-3 outdated facts about Svelte

trycatch — Sat, 26 Sep 2020 18:12:38 +0000

Svelte doesn't support Typescript

Pretty much every article on the Internet states that Svelte doesn't support Typescript. The community points this out as the largest disadvantage (comparing to React, Vue, and Angular).

Svelte's team has announced Typescript support

Svelte doesn't have browser devtools

Anybody who worked with Big 3 frameworks knows how easy it gets with DevTools. A lot of criticism Svelte had was due to lack of DevTools. No more console.log!

There you'll find extensions for Chromium and Firefox

Svelte isn't popular

You know it's new and so on. But look at these numbers, it's breathing down angular's neck!

framework/library	stars	year
svelte	37k	2016
angular	66k	2010
react	156k	2013
vue	173k	2014

Top-5 handy lerna flags for your monorepo

trycatch — Sat, 29 Aug 2020 15:36:15 +0000

--scope

This filter limits the command execution scope only to packages that meet the condition. For example:

// starts a package with the name 'server'
lerna run --scope server start

// starts all packages end up on '-server'
lerna run --scope *-server start 

// you can select multiple scopes at the same time
// executes either '-server's and '-client's 'start' command
lerna run --scope *-server --scope *-client start

--ignore

This one works as the previous, but in the opposite way. Basically, it excludes everything that matches the pattern or name.

// Runs 'npm audit' everywhere, but in ui-library
lerna exec --ignore ui-library npm audit

// Runs 'npm audit' everywhere, but in dev-server and dev-client packages
lerna exec --ignore dev-{server,client} npm audit

--stream/--parallel

Find more about my personal monorepo experience on my blog

Open a router port for home Ubuntu Server 20.04

trycatch — Fri, 28 Aug 2020 17:26:43 +0000

Problem:

You've run your application on home server (e.g. Ubuntu Server 20.04), but it isn't available outside.

Solution:

1) Check your IPs

External:

curl ifconfig.me

Internal:

ip a

2) Make app's port available

A complete guide on how to open Ubuntu port is on my blog

7 steps after installing PostgresQL on Ubuntu Server 20.04

trycatch — Thu, 27 Aug 2020 17:07:39 +0000

Problem:

After installation (sudo apt install postgresql-12) you try to connect to your fresh PostgresQL 12 using psql, but it's responding

psql: error: could not connect to server: FATAL:  Peer authentication failed for user "postgres"

Solution:

1) Make sure you've run pg_ctlcluster

sudo pg_ctlcluster 12 main start

2) Check postgres port and change it to 5432 if needed

sudo nano /etc/postgresql/12/main/postgresql.conf

in newer versions it might be 5433 by default, so it causes problems

find a string with port = 5433 and change it to port = 5432

3) Restart postgres service (just in case)

sudo service postgresql restart

4) Sign-in into psql using sudo

sudo -u postgres psql postgres

5) Set up postgres user's password. Don't forget the semicolon!

2 last steps on my DevOps blog