Skip to content

Instantly share code, notes, and snippets.

View cloverink's full-sized avatar
🍀
Error Driven Development

Aran Chananar cloverink

🍀
Error Driven Development
View GitHub Profile
docker stop kong-database
docker rm kong-database
docker stop kong
docker rm kong
---------------------
docker run -d --name kong-database ^
-p 5432:5432 ^
-e "POSTGRES_USER=kong" ^
version: '2'
services:
mongodb:
image: bitnami/mongodb:latest
container_name: newsurvey-mongodb
environment:
- MONGODB_USERNAME=admin
- MONGODB_PASSWORD=admin1234
- MONGODB_DATABASE=newsurvey
ports:
@cloverink
cloverink / docker-compose-graylog
Created December 5, 2021 19:58
example docker compose graylog
version: '2'
services:
mongodb:
image: mongo:3
elasticsearch:
image: docker.elastic.co/elasticsearch/elasticsearch-oss:6.6.1
environment:
- http.host=0.0.0.0
- transport.host=localhost
- network.host=0.0.0.0
@cloverink
cloverink / gist:b4782e5e99dfb86b53d1e200fe68e8f9
Created January 14, 2022 04:21
S3 Upload /w gzip from stream
const config = require('../../config')
const AWS = require('aws-sdk')
const zlib = require('zlib')
const Duplex = require('stream').Duplex
const s3 = new AWS.S3({
credentials: {
accessKeyId: config.aws.accessKey,
secretAccessKey: config.aws.secretKey
}
})
@cloverink
cloverink / test.js
Created April 1, 2022 08:37
find zero from between number [ 1 ... 10000 ]
[...Array(10000).keys()].map(a => (a+1).toString()).join('').match(/0/g).length
@cloverink
cloverink / test.js
Created July 5, 2022 07:52
stopPropagation()
const onClick = (e: MouseEvent) => {
e.stopPropagation();
// ...
};
@cloverink
cloverink / script.sql
Created July 8, 2022 17:20
How to Group by Time in PostgreSQL
select
date_trunc('minute', created_at), -- or hour, day, week, month, year
count(1)
from users
group by 1;
@cloverink
cloverink / script.sql
Created August 11, 2022 05:44
Postgres Duplicate Database
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'db-name-1'
AND pid <> pg_backend_pid();
CREATE DATABASE "db-name-2"
WITH TEMPLATE "db-name-1"
OWNER produsr;
@cloverink
cloverink / script.sh
Created January 19, 2023 14:39
list dir size
du -d 1 -h node_modules/ | grep prisma
@cloverink
cloverink / .zprofile
Created January 27, 2023 05:21
nvm-loader
# place this after nvm initialization!
autoload -U add-zsh-hook
load-nvmrc() {
local nvmrc_path="$(nvm_find_nvmrc)"
if [ -n "$nvmrc_path" ]; then
local nvmrc_node_version=$(nvm version "$(cat "${nvmrc_path}")")
if [ "$nvmrc_node_version" = "N/A" ]; then
nvm install