Skip to content

Instantly share code, notes, and snippets.

View mcornejo's full-sized avatar

Mario Cornejo mcornejo

31 followers · 39 following
View GitHub Profile
@mcornejo
mcornejo / postgres_queries_and_commands.sql
Created April 12, 2023 11:32 — 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%'
@mcornejo
mcornejo / bitbucket-pipelines.yml
Created October 11, 2022 07:26 — forked from tstrohmeier/bitbucket-pipelines.yml
AWS ECS: Script for creating a new revision of a task definition and update a service
# enable Docker for your repository
options:
docker: true
pipelines:
branches:
development:
- step:
# python image with aws-cli installed
@mcornejo
mcornejo / Effective Scala Case Class Patterns.md
Created March 1, 2022 21:24 — forked from chaotic3quilibrium/Effective Scala Case Class Patterns.md
Article: Effective Scala Case Class Patterns - The guide I wished I had read years ago when starting my Scala journey

Effective Scala Case Class Patterns

Version: 2022.02.28

Available As

@mcornejo
mcornejo / keybase.md
Created August 22, 2016 14:33

Keybase proof

I hereby claim:

  • I am mcornejo on github.
  • I am murdix (https://keybase.io/murdix) on keybase.
  • I have a public key whose fingerprint is 049D B440 5600 170D E283 D6B5 4189 8F0C 28D9 5D67

To claim this, I am signing this object: