Skip to content

Instantly share code, notes, and snippets.

View Rovel's full-sized avatar
🙈
Monkey patching life

Filipe Veloso Rovel

🙈
Monkey patching life
View GitHub Profile
@Rovel
Rovel / postgres-cheatsheet.md
Created October 23, 2020 20:52 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
@Rovel
Rovel / how2gpg.md
Last active October 28, 2022 19:38
GPG Commands

Generate your keys

Prereqs

Create your keys with your email.

Execute following commands:

@Rovel
Rovel / ReadMe.md
Created June 1, 2023 15:30
How to Change Open Files Limit on OS X and macOS Sierra (10.8 - 10.12)

How to Change Open Files Limit on OS X and macOS

To check the current limits on your Mac OS X system, run in terminal:

launchctl limit maxfiles
ulimit -a

Steps

@Rovel
Rovel / docker-compose.yml
Created June 13, 2023 13:05 — forked from Nikkely/docker-compose.yml
redis replication on docker-compose
version: '3'
services:
redis:
image: redis:5.0.0
container_name: master
ports:
- "6379:6379"
networks:
- redis-replication
@Rovel
Rovel / kamal-production-server-setup.sh
Last active June 8, 2025 05:47 — forked from rameerez/kamal-production-server-setup.sh
Set up a Ubuntu server to deploy Kamal 2.x Docker containers to, hardened security and production ready
#!/bin/bash
# Ubuntu 24.04 Server Hardening Script
set -euo pipefail
IFS=$'\n\t'
# --- Constants ---
REQUIRED_OS="Ubuntu"
REQUIRED_VERSION="24.04"