Erik Telepovský eriktelepovsky

FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.

Effective Engineer - Notes

By Edmond Lau
Highly Recommended 👍
http://www.theeffectiveengineer.com/

What's an Effective Engineer?

-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;

-- Then change column name of  your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;

	# Add this code in any Django app's admin.py
	# Works for all Task Statuses; you can filter them in line 12.

	import ast
	import importlib
	import json

	from django.contrib import admin
	from django.contrib import messages
	from django.utils.safestring import mark_safe

	-- Get Max ID from table
	SELECT MAX(id) FROM table;

	-- Get Next ID from table
	SELECT nextval('table_id_seq');

	-- Set Next ID Value to MAX ID
	SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));

	#!/bin/bash
	# Autor: Nilton OS -- www.linuxpro.com.br
	echo 'setup-web2py-nginx-uwsgi-centos64.sh'
	echo 'Support CentOS 6.4'
	echo 'Installs Nginx 1.4.1 + uWSGI + Web2py'


	# Get Web2py Admin Password
	echo -e "Web2py Admin Password: \c "
	read PW

	# coding: utf-8
	"""
	Cauê Thenório - cauelt(at)gmail.com

	This snippet makes Django do not create URL languages prefix (i.e. /en/)
	for the default language (settings.LANGUAGE_CODE).

	It also provides a middleware that activates the language based only on the URL.
	This middleware ignores user session data, cookie and 'Accept-Language' HTTP header.