Skip to content

Instantly share code, notes, and snippets.

View gcaraciolo's full-sized avatar
🏠
Working from home

Guilherme Caraciolo gcaraciolo

🏠
Working from home
View GitHub Profile
@k4ml
k4ml / messaging.py
Created January 29, 2014 23:26
POPO - Plain Old Python Object
class Messaging(object):
def __init__(self, user, sender, receiver, message):
self.user = user
self.sender = sender
self.receiver = receiver
self.message = message
def send(self):
required_points = self.get_required_points()
if required_points > self.user.points:
@sirbrillig
sirbrillig / pgsql_backup.sh
Last active May 14, 2025 05:51 — forked from dangerousbeans/pgsql_backup.sh
Postgresql daily backup script.
#!/bin/bash
#
# Backup a Postgresql database into a daily file.
#
BACKUP_DIR=/pg_backup
DAYS_TO_KEEP=14
FILE_SUFFIX=_pg_backup.sql
DATABASE=
USER=postgres
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active May 28, 2025 00:59
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%'