Skip to content

Instantly share code, notes, and snippets.

View aloaisa's full-sized avatar

Alvaro Garcia Loaisa aloaisa

View GitHub Profile
@aloaisa
aloaisa / ngrok-installation.md
Created September 28, 2020 14:44 — forked from wosephjeber/ngrok-installation.md
Installing ngrok on Mac

Installing ngrok on OSX

brew cask install ngrok

Using ngrok

The easiest way to use ngrok to tunnel into your localhost is if your local project is running on a specific port (e.g. not using named vhosts). You just run ngrok http [port number].

You can quickly boot up a local webserver using ruby. cd into the project's root directory and run ruby -run -e httpd . -p [port number].

@aloaisa
aloaisa / how-to-copy-aws-rds-to-local.md
Created May 28, 2020 15:05 — forked from syafiqfaiz/how-to-copy-aws-rds-to-local.md
How to copy production database on AWS RDS(postgresql) to local development database.
  1. Change your database RDS instance security group to allow your machine to access it.
    • Add your ip to the security group to acces the instance via Postgres.
  2. Make a copy of the database using pg_dump
    • $ pg_dump -h <public dns> -U <my username> -f <name of dump file .sql> <name of my database>
    • you will be asked for postgressql password.
    • a dump file(.sql) will be created
  3. Restore that dump file to your local database.
    • but you might need to drop the database and create it first
    • $ psql -U <postgresql username> -d <database name> -f <dump file that you want to restore>
  • the database is restored
@aloaisa
aloaisa / postgres-cheatsheet.md
Created March 2, 2016 19:07 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

@aloaisa
aloaisa / OfertaSupertruperBackend
Last active August 29, 2015 13:59
Oferta de trabajo para Supertruper Backend
En Supertruper buscamos incorporar un desarrollador de backend versátil, proactivo y con ganas de aprender.
Somos una pequeña Startup orientada al desarrollo de aplicaciones móviles y web especializada en comparadores de productos.
(http://www.supertruper.com)
Tu experiencia es importante, pero mucho más tus ganas de aprender!
Estas son las tecnologías con las que trabajamos (no son excluyentes):
- Groovy/Grails (Java)
- Linux - Administración
- Apache/Tomcat
- Scripting - Bash
@aloaisa
aloaisa / about.md
Created August 18, 2011 06:50 — forked from jasonrudolph/about.md
Programming Achievements: How to Level Up as a Developer