Skip to content

Instantly share code, notes, and snippets.

View achmadhadikurnia's full-sized avatar
🎯
Focusing

Achmad Hadi Kurnia achmadhadikurnia

🎯
Focusing
23 followers · 73 following
View GitHub Profile
@achmadhadikurnia
achmadhadikurnia / gist:3ba0b60ab4a6ab77a5614f02d7e010b9
Created August 17, 2024 04:11
docker_create_metabase.bat
docker run -d -p 3000:3000 --name metabase -d metabase
@achmadhadikurnia
achmadhadikurnia / optimize_vhdx_file.bat
Created June 23, 2024 12:31
Optimize-VHD -Path c:\path\to\data.vhdx -Mode Full
@achmadhadikurnia
achmadhadikurnia / docker_create_mongo-express_container_with_network.bat
Created May 3, 2024 01:26
docker network create mongo
docker run --name mongo-express --network mongo -e ME_CONFIG_MONGODB_SERVER=mongo -p 8081:8081 mongo-express
@achmadhadikurnia
achmadhadikurnia / docker_create_nginx_container_with_volume.bat
Created May 2, 2024 02:06
docker run --name nginx -p 8080:80 -v nginx:/usr/share/nginx/html -d nginx
@achmadhadikurnia
achmadhadikurnia / docker_create_mariadb_5-5_container_with_volume.bat
Created May 2, 2024 02:02
docker run --name mariadb-5.5 -e MYSQL_ROOT_PASSWORD=password -e MYSQL_ALLOW_EMPTY_PASSWORD=true -p 33060:3306 -v mariadb-5.5:/var/lib/mysql -d mariadb:5.5.64
@achmadhadikurnia
achmadhadikurnia / .gitignore_global
Last active April 28, 2024 03:56
# Node
npm-debug.log
# Mac
.DS_Store
# Windows
Thumbs.db
desktop.ini
@achmadhadikurnia
achmadhadikurnia / docker_create_mysql_container_with_volume.bat
Last active April 26, 2024 02:46
docker run --name mysql -e MYSQL_ROOT_PASSWORD=password -e MYSQL_ALLOW_EMPTY_PASSWORD=true -p 3306:3306 -v mysql:/var/lib/mysql -d mysql
@achmadhadikurnia
achmadhadikurnia / query_to_string_replace.sql
Created April 4, 2023 02:42
UPDATE table
SET field = REPLACE(field, 'replace string', 'replace to')
WHERE field LIKE '%replace string%'
@achmadhadikurnia
achmadhadikurnia / docker_create_mongo_container_with_volume.bat
Last active May 3, 2024 01:35
docker run --name mongo -p 27017:27017 -v mongo:/data/db -v mongoconfig:/data/configdb --network mongo -e MONGO_INITDB_ROOT_USERNAME=root -e MONGO_INITDB_ROOT_PASSWORD=password -d mongo
@achmadhadikurnia
achmadhadikurnia / query_to_delete_all_except_latest_x_records.sql
Last active April 4, 2023 02:41
DELETE FROM table WHERE id NOT IN (
SELECT id
FROM (
SELECT id
FROM table
ORDER BY id DESC
LIMIT x
) temporary
);