Skip to content

Instantly share code, notes, and snippets.

View sumodirjo's full-sized avatar

Muhammad Panji sumodirjo

33 followers · 1 following
View GitHub Profile
@sumodirjo
sumodirjo / mysql-notes.md
Created August 17, 2022 09:28

MySQL Notes

Useful Queries

Size Specific Table

SELECT
	table_name AS `Table`,
	round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
@sumodirjo
sumodirjo / rds-ca-rotation.md
Created January 17, 2020 22:40
Notes related RDS CA 2019 Rotation

Download all RDS CA

wget -c https://s3.amazonaws.com/rds-downloads/rds-ca-2019-root.pem
wget -c https://s3.amazonaws.com/rds-downloads/rds-ca-2015-root.pem
wget -c https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem

Get fingerprint for all RDS CA

@sumodirjo
sumodirjo / looking-glass.md
Last active April 29, 2023 18:06
Looking Glasses
@sumodirjo
sumodirjo / postgresql-queries.md
Created November 8, 2019 22:06
Useful PostgreSQL Queries

Show tables using pg_catalog schema

SELECT
   *
FROM
   pg_catalog.pg_tables
WHERE
 schemaname != 'pg_catalog'
@sumodirjo
sumodirjo / 524240.txt
Created September 4, 2019 08:07
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad
@sumodirjo
sumodirjo / 524288.sh
Created September 4, 2019 06:49
printf "set key 0 60 524288\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et
@sumodirjo
sumodirjo / 524288.txt
Created September 4, 2019 06:44
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad
@sumodirjo
sumodirjo / keybase.md
Created February 7, 2019 09:42

Keybase proof

I hereby claim:

  • I am sumodirjo on github.
  • I am sumodirjo (https://keybase.io/sumodirjo) on keybase.
  • I have a public key ASBeGb3rMLzzAq4PbW7f7u2lC0hX3URTESqFUG85q51kxAo

To claim this, I am signing this object:

@sumodirjo
sumodirjo / redis-server
Created November 4, 2015 02:02
redis-server init script
#! /bin/sh
### BEGIN INIT INFO
# Provides: redis-server
# Required-Start: $syslog $remote_fs
# Required-Stop: $syslog $remote_fs
# Should-Start: $local_fs
# Should-Stop: $local_fs
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: redis-server - Persistent key-value db
@sumodirjo
sumodirjo / movies.json
Last active April 29, 2023 17:56
Movie list from : https://raw.githubusercontent.com/bantic/imdb-data-scraping/master/data/movies.json
{"title":"Wings","imdbId":"tt0018578","releaseDate":"1927-05-19T05:00:00.000Z","releaseCountry":"USA","releaseYear":1927,"releaseMonth":4,"releaseDay":19}
{"title":"The Broadway Melody","imdbId":"tt0019729","releaseDate":"1929-02-01T05:00:00.000Z","releaseCountry":"USA","releaseYear":1929,"releaseMonth":1,"releaseDay":1}
{"title":"All Quiet on the Western Front","imdbId":"tt0020629","releaseDate":"1930-04-21T04:00:00.000Z","releaseCountry":"USA","releaseYear":1930,"releaseMonth":3,"releaseDay":21}
{"title":"Cimarron","imdbId":"tt0021746","releaseDate":"1931-01-26T05:00:00.000Z","releaseCountry":"USA","releaseYear":1931,"releaseMonth":0,"releaseDay":26}
{"title":"Grand Hotel","imdbId":"tt0022958","releaseDate":"1932-04-12T04:00:00.000Z","releaseCountry":"USA","releaseYear":1932,"releaseMonth":3,"releaseDay":12}
{"title":"Cavalcade","imdbId":"tt0023876","releaseDate":"1933-01-05T05:00:00.000Z","releaseCountry":"USA","releaseYear":1933,"releaseMonth":0,"releaseDay":5}
{"title":"It Happened One Night","imdbId":"t