zmts

Insert(push) object to nested array. JSONB PostgreSQL

// posts table

| id | content          |
|----|------------------|
| 40 | jsonb data       |

zmts

Can't connect to PostgreSQL. SSL error with Nodejs/Knexjs (Digital ocean)

Issues:

Case 1

{
  client: 'pg',
  connection: {
    host: process.env.DB_HOST,
    port: process.env.DB_PORT,

zmts

base64 on Unix systems

How get base64 from any file ?

Write to output

cat var/tmp/myFile.txt | base64

Or write to file

cat var/tmp/myFile.txt | base64 > var/tmp/decodedFile.txt

zmts

Permissions for ssh/id_rsa

Case 1

git clone [email protected]:....git

fails with:

Permissions 0644 for '/root/.ssh/id_rsa' are too open.

zmts

PM2

https://pm2.keymetrics.io/docs/usage/startup/

npm install -g pm2@latest
pm2 startup

Saving current process list

zmts

How To Install Node.js on Debian 10

https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-debian-10 https://www.digitalocean.com/community/tutorials/how-to-set-up-time-synchronization-on-debian-10

cd ~
curl -sL https://deb.nodesource.com/setup_12.x -o nodesource_setup.sh
sudo bash nodesource_setup.sh
sudo apt install nodejs
node -v

zmts

Deploy nodejs app with gitlab.com and pm2

This manual is about setting up an automatic deploy workflow using nodejs, PM2, nginx and GitLab CI. It is tested on:

• Target server: Ubuntu 16.04 x64. This is suitable for Ubuntu 14.x.
• Windows 10 on my PC to work.

zmts

Get access to localhost database from docker container

• Run containerized application on 0.0.0.0 address
• Use host.docker.internal as database hostname

zmts

Tiny Library for Basic but Precise Arithemetic

For when you don't want 0.1 + 0.2 to equal 0.30000000000000004 use https://github.com/nefe/number-precision

zmts

Get image width and height with JavaScript

function imageSize (image) {
  return new Promise((resolve, reject) => {
    try {
      const fileReader = new FileReader()

      fileReader.onload = () => {
 const img = new Image()