Top all-time · #1491
Big Machine
Personal blog · rob.conery.ioprogrammingcareer
Big Machine is a personal blog at rob.conery.io about programming and career. Since 2015, 50 different Hacker News readers have linked it 69 times, most often “Bring the power of Postgresql to Nodejs”. It is still writing: the last post was on 2026-07-20, and you can follow it by feed.
Most-linked posts?
- /2014/05/29/a-better-id-generator-for-postgresql/3 people · 3 mentions · first linked 2015-10-25
- Bring the power of Postgresql to Nodejs3 people · 3 mentions · first linked 2015-03-13
- The Imposter's Handbook3 people · 3 mentions · first linked 2016-07-05
- Mod and remainder are not the same3 people · 3 mentions · first linked 2018-08-22
- A Pure PostgreSQL Document Database API3 people · 3 mentions · first linked 2018-07-11
- PostgreSQL Tools for the Visually Inclined2 people · 3 mentions · first linked 2019-03-04
- Learn Elixir the Fun Way2 people · 2 mentions · first linked 2016-01-04
- Fine tuning full text search with PostgreSQL 122 people · 2 mentions · first linked 2019-10-30
- Should I Trust Firebase? Of Course Not2 people · 2 mentions · first linked 2017-06-08
- RethinkDB 2.0 is amazing2 people · 2 mentions · first linked 2015-04-17
What Hacker News says?
> In what context would a primary key change, even when sharding? The only time I've seen that happen is when a DBA evangelized for just using 'natural' keys, which in this case were slugs based on the item name. The problem came when users decided they wanted to rename things and then wondered why the IDs they were seeing in URLs didn't match the new names. I'm not a believer in natural keys anymore. > If you need…
Comment linking /2014/05/29/a-better-id-generator-for-postgresql/
on “Be Careful with UUID or GUID as Primary Keys”Submitted RethinkDB 2.0 is amazing as a story · 348 points
HN discussionScott Hanselman(dotnet and random h/w hacks) - http://www.hanselman.com/ Rob Connery(dotnet,elixir,postgres) - http://rob.conery.io/
Comment linking /
on “Ask HN: Which developers do you closely follow?”Submitted Embracing SQL in Postgres as a story · 273 points
HN discussionNote that the 9ms performance claim in this article is mistaken. The author has issued a correction: http://rob.conery.io/2015/04/17/rethinkdb-2-0-is-amazing/
Comment linking /2015/04/17/rethinkdb-2-0-is-amazing/
on “RethinkDB 2.0 is amazing”Submitted Mod and remainder are not the same as a story · 165 points
HN discussionhttp://rob.conery.io/about/
Comment linking /about/
on “The Imposter's Handbook”Submitted WTF Is Big O Notation? as a story · 143 points
HN discussionFor replication instances run in a master-replica setup using Streaming Replication try: http://www.repmgr.org/ repmgr is an open-source tool suite to manage replication and failover in a cluster of PostgreSQL servers. It enhances PostgreSQL's built-in hot-standby capabilities with tools to set up standby servers, monitor replication, and perform administrative tasks such as failover or manual switchover operations.…
Comment linking /2014/05/29/a-better-id-generator-for-postgresql/
on “What PostgreSQL has over other open source SQL databases: Part II”Submitted The Logical Disaster of Null as a story · 115 points
HN discussionWhy not use Twitter's snowflake id? Instagram blogged about a Postgres function that generates them http://rob.conery.io/2014/05/28/a-better-id-generator-for-po...
Comment linking /2014/05/28/a-better-id-generator-for-postgresql/
on “Implementing Stripe-Like Idempotency Keys in Postgres”Submitted Document Storage Gymnastics with Postgres as a story · 107 points
HN discussionHmm, going to say a hard no on naively preferring UUIDs. It's a little bit of extra work to go with the instagram style approach [0] of using many logical postgres shards with a custom id function that implements twitter snowflake style IDs, but it's an elegant, scalable and operationally simple solution. I am very fond of it. [0] http://rob.conery.io/2014/05/29/a-better-id-generator-for-po...
Comment linking /2014/05/29/a-better-id-generator-for-postgresql/
on “Mistakes Beginners Make When Working with Databases”Submitted Setting Up a Fast, Comprehensive Search Routine with PostgreSQL as a story · 99 points
HN discussionFor something a little more practical, I recently came across this postgres id generator[1], which Ive been playing around with as a solution for ordered, scalable bigint ids (that take up less space than standard uuids). [1] https://rob.conery.io/2014/05/28/a-better-id-generator-for-p...
Comment linking /2014/05/28/a-better-id-generator-for-postgresql/
on “Show HN: CuteUID – Generate Cute UIDs”Submitted Staying Hungry, Staying Foolish as a story · 99 points
HN discussionWell, the easy answer is to stop volunteering and attending family/social events[1]. Check out this[2] blog post for other possible ideas. [1] Number 3 here: http://www.aaronsw.com/weblog/morebooks [2] http://rob.conery.io/2015/10/06/how-to-learn-a-new-programmi...
Comment linking /2015/10/06/how-to-learn-a-new-programming-language-while-maintaining-your-day-job-and-still-being-there-for-your-family/
on “Ask HN: How do you find time to learn new things?”Submitted PostgreSQL for Those Who Can’t Even as a story · 60 points
HN discussion24:08 Minutes in https://github.com/robconery/pg_docs_api references: http://rob.conery.io/2015/08/20/designing-a-postgresql-docum... related: http://rob.conery.io/2015/03/13/bringing-the-power-of-postgr... https://github.com/robconery/massive-js
Comment linking /2015/03/13/bringing-the-power-of-postgres-to-nodejs/
on “Video: Document Storage Techniques with PostgreSQL and JSONB”Submitted Fine tuning full text search with PostgreSQL 12 as a story · 43 points
HN discussionThis book http://rob.conery.io/2016/07/03/imposters-handbook/ is written specifically with you in mind.
Comment linking /2016/07/03/imposters-handbook/
on “Ask HN: What resources are there for a strong dev to learn computer science?”Submitted Thinking About Function Signatures in Elixir as a story · 40 points
HN discussionSubmitted Using Recursion in Elixir as a story · 21 points
HN discussionSubmitted Transactional Data Operations in PostgreSQL Using Common Table Expressions as a story · 14 points
HN discussionSubmitted It’s Time to Get over That Stored Procedure Aversion You Have as a story · 12 points
HN discussionSubmitted It’s Time to Get Over That Stored Procedure Aversion You Have as a story · 11 points
HN discussionSubmitted Bring the power of Postgresql to Nodejs as a story · 7 points
HN discussionSubmitted Hello Elixir. Wow as a story · 7 points
HN discussionSubmitted PostgreSQL Tools for the Visually Inclined as a story · 6 points
HN discussionSubmitted A Pure PostgreSQL Document Database API as a story · 5 points
HN discussion
