Skip to content

Instantly share code, notes, and snippets.

@z-kk
z-kk / setup-debian.bash
Last active October 19, 2025 09:30
Debian setup command
#!/bin/bash
sudo apt update
sudo apt upgrade
sudo apt install git
sudo apt install vim
sudo apt install wget curl
sudo apt install make procps
@z-kk
z-kk / init.sql
Last active April 5, 2023 12:14
mariadb command sample
ALTER USER root@localhost IDENTIFIED BY 'password';
CREATE DATABASE testdb;
CREATE USER `newuser` IDENTIFIED BY 'userpass';
GRANT ALL ON *.* TO `newuser` WITH GRANT OPTION;
CREATE USER `appuser` IDENTIFIED BY 'appuser';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, LOCK TABLES, CREATE VIEW, SHOW VIEW ON testdb.* TO `appuser`;
@z-kk
z-kk / docker-compose.yaml
Created December 6, 2022 12:36
Docker compose sample
version: "3"
services:
maria:
image: mariadb
restart: always
ports:
- 3306:3306
volumes:
- ./data:/var/lib/mysql
- ./workdir:/work
@z-kk
z-kk / wsl.conf
Created March 7, 2022 10:41
wsl.conf file sample
[automount]
enabled = true
root = /mnt/
options = "metadata,umask=22,fmask=11"
#!/bin/sh
compare $2 $1 png:- | montage -geometry +4+4 $2 png:- $1 /tmp/diff.png
open /tmp/diff.png
@z-kk
z-kk / trelloJsonToCsv.py
Last active April 7, 2019 13:02
trelloJsonToCsv.py
import os
import sys
import datetime
import json
import csv
from operator import itemgetter
fName = 'trello.json'
csvName = 'trello.csv'
timeFormat = '%Y-%m-%d'