Skip to content

Instantly share code, notes, and snippets.

@thomasdarimont
thomasdarimont / keycloak_dashboard.sql
Last active August 31, 2021 14:20
Postgresql View Definitions for Keycloak Analytics Dashboard
-- View: analytics_event_count
-- DROP VIEW analytics_event_count;
CREATE OR REPLACE VIEW analytics_event_count AS
WITH event_data AS (
SELECT ee.realm_id,
timezone('UTC'::text, '1970-01-01 00:00:00'::timestamp without time zone + (ee.event_time / 1000)::double precision * '00:00:01'::interval)::date AS event_date,
ee.type AS event_type,
ee.user_id
@leonardofed
leonardofed / README.md
Last active November 12, 2025 11:14
A curated list of AWS resources to prepare for the AWS Certifications


A curated list of AWS resources to prepare for the AWS Certifications

A curated list of awesome AWS resources you need to prepare for the all 5 AWS Certifications. This gist will include: open source repos, blogs & blogposts, ebooks, PDF, whitepapers, video courses, free lecture, slides, sample test and many other resources.


@dersam
dersam / gitkraken.zsh
Last active October 15, 2025 19:16
Open GitKraken using the current repo directory in the cli.
## Open GitKraken using the current repo directory.
## For when you want a prettier view of your current repo,
## but prefer staying in the cli for most things.
## This will break if GitKraken ever removes the -p flag.
## If you're not using OSX, the path is definitely different.
kraken () {
~/Applications/GitKraken.app/Contents/MacOS/GitKraken -p $(pwd)
}

FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.


Effective Engineer - Notes

What's an Effective Engineer?

@demmer
demmer / slack-messages-by-user.py
Created December 2, 2016 22:59
count slack messages posted to a channel by user
#!/usr/bin/python
'''
Script to count messages by user posted to a channel for a given date range.
Install:
# sudo pip install slackclient
Also you will need to obtain a slack API token:
https://api.slack.com/docs/oauth-test-tokens
@serithemage
serithemage / AWSCertifiedDeveloperUnofficialStudyGuide.md
Last active January 14, 2025 02:29
AWS 공인 개발자 - 어소시에이트 수험 가이드
@sebble
sebble / stars.sh
Last active October 27, 2025 01:21
List all starred repositories of a GitHub user.
#!/bin/bash
USER=${1:-sebble}
STARS=$(curl -sI https://api.github.com/users/$USER/starred?per_page=1|egrep '^Link'|egrep -o 'page=[0-9]+'|tail -1|cut -c6-)
PAGES=$((658/100+1))
echo You have $STARS starred repositories.
echo
@andytumelty
andytumelty / aws query example: show VPC ID, Name and CIDR
Last active September 3, 2024 15:19
AWS CLI List VPC ID, Name and CIDR Block
# display VPC ID, CIDR Block and Name
aws ec2 --output text --query 'Vpcs[*].{VpcId:VpcId,Name:Tags[?Key==`Name`].Value|[0],CidrBlock:CidrBlock}' describe-vpcs
@gene1wood
gene1wood / aws_iam_managed_policies_2019-02-12.json
Last active May 14, 2025 18:03
Script to export all AWS IAM managed policies as well as the resulting list of all managed policies
[
{
"Document": {
"Statement": [
{
"Action": [
"directconnect:Describe*",
"ec2:DescribeVpnGateways"
],
"Effect": "Allow",
@serithemage
serithemage / AWSSecurityContents.md
Last active July 24, 2025 04:30
AWS 보안 관련 자료 모음집

AWS 학습 링크집 시리즈