Skip to content

Instantly share code, notes, and snippets.

View geothachankary's full-sized avatar

Geo J Thachankary geothachankary

1 follower · 6 following
View GitHub Profile
@geothachankary
geothachankary / modern_sql_style_guide.md
Created August 15, 2022 05:29 — forked from mattmc3/modern_sql_style_guide.md
Modern SQL Style Guide
layout author title revision version description
default
mattmc3
Modern SQL Style Guide
2019-01-17
1.0.1
A guide to writing clean, clear, and consistent SQL.

Modern SQL Style Guide

@geothachankary
geothachankary / dotnetlayout.md
Created August 21, 2020 10:17 — forked from davidfowl/dotnetlayout.md
.NET project structure 
$/
  artifacts/
  build/
  docs/
  lib/
  packages/
  samples/
  src/
 tests/
@geothachankary
geothachankary / postgres_queries_and_commands.sql
Created August 16, 2020 15:12 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@geothachankary
geothachankary / commit-message-guidelines.md
Created August 7, 2020 04:05 — forked from robertpainsi/commit-message-guidelines.md
Commit message guidelines

Commit Message Guidelines

Short (72 chars or less) summary

More detailed explanatory text. Wrap it to 72 characters. The blank
line separating the summary from the body is critical (unless you omit
the body entirely).

Write your commit message in the imperative: "Fix bug" and not "Fixed
bug" or "Fixes bug." This convention matches up with commit messages