Skip to content

Instantly share code, notes, and snippets.

View crashbell's full-sized avatar

An Nguyen Le crashbell

32 followers · 11 following
View GitHub Profile
@crashbell
crashbell / better-nodejs-require-paths.md
Created August 13, 2017 03:58 — forked from branneman/better-nodejs-require-paths.md
Better local require() paths for Node.js

Better local require() paths for Node.js

Problem

When the directory structure of your Node.js application (not library!) has some depth, you end up with a lot of annoying relative paths in your require calls like:

var Article = require('../../../models/article');

Those suck for maintenance and they're ugly.

Possible solutions

@crashbell
crashbell / enum.sql
Created August 7, 2017 07:08 — forked from d11wtq/enum.sql
Renaming an ENUM label in PostgreSQL
/*
Assuming you have an enum type like this.
You want to rename 'pending' to 'lodged'
*/
CREATE TYPE dispute_status AS ENUM('pending', 'resolved', 'open', 'cancelled');
BEGIN;
ALTER TYPE dispute_status ADD VALUE 'lodged';
UPDATE dispute SET status = 'lodged' WHERE status = 'pending';