approachingtraj
approachingtraj on Hacker News
Re:22nd Century C
on Sunday September 11, 2016 @11:47AM (#12473897)
This is so fucking stupid.
Re:When to Avoid JSONB in a PostgreSQL Schema
on Friday September 02, 2016 @05:47AM (#12411937)
> stuff json into a text column
You did see the article was about JSONB, which is significantly more sophisticated than "json in a text column", yes?
Re:An unexpected journey, a Postgres DBA's tale
on Tuesday August 02, 2016 @09:07AM (#12209623)
The title is misleading. The post only talks about Amazon's RDS which is not Postgres.
Re:How to move from Amazon RDS to a dedicated PostgreSQL server
on Wednesday May 25, 2016 @06:31AM (#11768806)
> Instead of resorting to those hacks, follow the PostgreSQL documentation[1] to do it the right way. The simplest way is to initialize your PostgreSQL database cluster as:
This is actually poor advice. The right way on Ubuntu is to use the packages provided by PostgreSQL Development Group (https://wiki.postgresql.org/wiki/Apt), and in that setup you use pg_createcluster instead of initdb.
The snippet in the original article was so hacky because it fixed an existing cluster instead of destroying it and creating a new one in UTF-8.