How to setup databases for your application and testing? Database creation CREATE DATABASE mydb; CREATE DATABASE test_mydb; CREATE USER me WITH PASSWORD 'password'; -- Connect to mydb \connect mydb; -- AWS quirks GRANT me TO POSTGRES; -- Create a schema with me as owner CREATE SCHEMA my_schema AUTHORIZATION me; -- Create an extension CREATE EXTENSION postgis SCHEMA my_schema; -- Connect to test_mydb \connect test_mydb; -- Create a schema with me as owner CREATE SCHEMA test_schema AUTHORIZATION me; -- Create an extension CREATE EXTENSION postgis SCHEMA test_schema; GRANT ALL PRIVILEGES ON DATABASE my_db TO me; -- Settings recommended by Django doc ALTER ROLE me SET client_encoding TO 'utf8'; ALTER ROLE me SET default_transaction_isolation TO 'read committed'; ALTER ROLE me SET timezone TO 'UTC'; The DATABASE_URL will be DATABASE_URL='postgresql://me:password@myHost:myPort/mydb?options=–search_path%3Dmy_schema,test_schema' ...

10 Things Software Developers Should Learn about Learning Human memory is not made of bits A large chunk of learning is about remembering. Yet a human's memory is quite different from a computer's memory. We commit to our memory what we want to remember often imprecisely. The addition of related or unrelated memories may distort it ("spreading activation"). Not to mention the fact that we constantly forget what we learned as long as we don't use it. Overall it is a haphazard event. ...

I'm spending a little time each day to read some traditional Chinese literature. Recently I've been interested in a book that can be dated to the early Zhou dynasty. I Ching was believed (by some) to be written by King Wen of Zhou when he was a prisoner at Youli, apparently before 1000 BC. If it is true, this is currently the oldest book that I've ever read. What I'd like to share today is some comment on the first stacked line of the hexagram qian (䷀) from Confucius. ...

First level Second level Third level Fourth level Markup Mary has a little lamb, little lamb, little lamb, little lamb, not-big lamb. Verses don't work Great clouds overhead Tiny black birds rise and fall Snow covers Emacs —AlexSchroeder Quotes work Everything should be made as simple as possible, but not any simpler —Albert Einstein Centering works Everything should be made as simple as possible, but not any simpler ...