Rangkuman Belajar Elasticsearch

Istilah database di elasticsearch

Database -> tidak ada di elasticsearch

Table -> index

Column -> Field/Attribute

Row/Record -> Document (JSON)

Join Table -> Embeded Document, Reference

SQL -> JSON

Cara install Elasticsearch

File config

config/elasticsearch.yml

cluster.name -> nama untuk cluster (kumpulan dari elasticsearch)

node.name -> nama aplikasi (harus uniq per aplikasi)

xpack.security.enabled -> mematikan xpack dengan isian false

http.port -> port yang digunakan elastic secara default di 9200

path.data: lokasi folder untuk simpan data, misal data

path.logs: lokasi folder untuk log misalnya log

Continue reading...

Rangkuman Query PostgreSQL

Check Max Connection

SHOW max_connections;

Query menampilkan total connection, active connection, idle connection, dan max connection di database postgresql

SELECT 

    count(*) AS total_connections,

    count(*) FILTER (WHERE state = 'active') AS active_connections,

    count(*) FILTER (WHERE state = 'idle') AS idle_connections,

    (SELECT setting::int FROM pg_settings WHERE name = 'max_connections') AS max_connections

FROM pg_stat_activity;

asdas

Continue reading...

Error Git Push ke Repository

error: remote unpack failed: error VS403702: The push was rejected because one or more commits contain author email '1878631-awanz@users.noreply.gitlab.com' which does not match the policy-specified patterns.

git config user.email yournewemail@example.org

git commit --amend --reset-author

git commit --amend --reset-author --no-edit

Continue reading...

Cara menghapus Aplikasi di Ubuntu

 Ubuntu Software

APT Command

- Command list aplikasi yang terinstal

sudo apt list --installed

- Command untuk menghapus

sudo apt-get remove <nama_aplikasi> -y

snap Command

- Command list aplikasi yang terinstal

sudo snap list

- Command untuk menghapus

sudo snap remove <nama_aplikasi>

dpkg

- Command list aplikasi yang terinstal

dpkg --list

- Command untuk menghapus

sudo dpkg -r <application_name>

atau

sudo apt-get remove --purge <nama_aplikasi>

Cara Remove Dependencies

sudo apt autoremove 

Continue reading...

Memperbarui ulang .gitignore

git rm -r --cached .

git add .

git commit -m ".gitignore is now working" 

Continue reading...

Composer SSL certificate problem: unable to get local issuer certificate

Problem

curl error 60 while downloading https://repo.packagist.org/p2/picqer/php-barcode-generator.json: SSL certificate problem: unable to get local issuer certificate

Solution

composer config -g -- disable-tls false

Continue reading...

Skipping acquire of configured file 'main/binary-i386/Packages' as repository 'http://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease' doesn't support architecture 'i386'

Problem

N: Skipping acquire of configured file 'main/binary-i386/Packages' as repository 'http://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease' doesn't support architecture 'i386'

Solution

Pertama buka file menggunakan gedit

sudo gedit /etc/apt/sources.list.d/pgdg.list

ubah menjadi

deb [arch=amd64] http://apt.postgresql.org/pub/repos/apt/ focal-pgdg main

Lalu lakukan update kembali dan berhasil

sudo apt-get update

Continue reading...