How I take time off in an “unlimited” PTO world

Unlimited PTO can be a double-edged sword. Have you ever worked at a company where PTO was discouraged? The landscape has changed dramatically over the last 20 years. When I started my career, most companies had “sick time” separate from “vacation time”. Vacation had to be approved in advanced. And the concept of a mental … More How I take time off in an “unlimited” PTO world

Backup and Restoring Databases in Postgres

TL;DR 1. pg_dump -d my_database > my_backup_script.sql 2. rake db:create OR psql: CREATE DATABASE my_database_name 3. psql my_database_name < my_backup_script.sql Running into issues, or want to understand in more detail? Let’s dig in some more. Step 1: Backup Your Data Open up your favorite terminal. Make sure your database server is running (in Docker, in … More Backup and Restoring Databases in Postgres

The Samuel E. Wilson Volunteer of the Year Scholarship

(Last updated June 22nd, 2019) Applications are now closed. We are reviewing all entries in detail and will be replying to all applicants on June 30th. This scholarship is available to students who have made an impact to another person, a small group, or a community through self-sacrifice. This award celebrates the power of helping … More The Samuel E. Wilson Volunteer of the Year Scholarship

Upgrading Postgres in a Rails codebase

If you’re looking to upgrade Postgres locally in a Rails project, it’s straight-forward-yet-not-simple. It’s not a one-click/one-command operation. I used the pg_dump command, along with Homebrew in this example. I have also seen a good post from Christopher Brown and Keita on manually backing up and copying data files using pg_upgrade. These involve a few more steps … More Upgrading Postgres in a Rails codebase