HNHacker News
TopNewBestAskShowJobs

andorov

133 karma · joined May 6, 2014

submissionscomments
andorov··on Idempotency
I always remember this from the example my professor gave -

   'raise the control rods by 1 inch' 
vs 'raise the control rods to a height of 4 inches'
andorov··on The costs of microservices (2020)
I've been using the term 'macro-services' to describe this middle ground.
andorov··on Upsert in SQL
worth re-upping -

postgres requests an id from the sequence for each row of the incoming data ahead of time since it doesn't know which rows are updates and which are inserts (although presumably this could be changed?). the sequence doesn't reset down for the unused so this can eat through it unexpectedly quickly if you have a table with a relatively large volume of updates.

also as a tip if you hit the max integer for the sequence and need space to implement a fundamental fix you can quickly change the sequence to start at -1 and go down. there's no issue with negative ids since they're also integers.

andorov··on Excellence is a habit, but so is failure
Similar quote from Lao Tzu. I like the inclusion of thoughts -> words -> actions.

"Watch your thoughts, they become your words;

watch your words, they become your actions;

watch your actions, they become your habits;

watch your habits, they become your character;

watch your character, it becomes your destiny."

andorov··on Ways to shoot yourself in the foot with Postgres
this also matters if you do a lot of upserts on a table that are predominantly updates. postgres requests an id from the sequence for each row of the incoming data ahead of time since it doesn't know which rows are updates and which are inserts. the sequence doesn't reset down for the unused so this can eat through it unexpectedly quickly.

if you hit the max integer for the sequence and need space to implement a fundamental fix you can quickly change the sequence to start at -1 and go down. there's no issue with negative ids since they're also integers.

andorov··on Space Elevator
SpinLaunch is pretty interesting too - throwing ships into space https://www.spinlaunch.com/
andorov··on A trick to reaching flow: Leave your work broken
Hemmingway would leave off writing for the day in the middle of a sentence for the same reason.
andorov··on Who becomes an entrepreneur? Insights from research studies
In my experience people are inaccurately pessimistic, in part due to a lack of imagination. So risk assessment that's more accurate will present as more optimistic.
andorov··on Repeat yourself, do more than one thing, and rewrite everything (2018)
DRY needs to be balanced with SRP (Single Responsibility Principle). You can legitimately have two functions that are exactly the same but they should not be DRY'd up if they are actually serving different purposes.

The use cases will likely diverge in the future, and if the functions are DRY'd making changes will make introducing bugs from the calling code that you're not working on easy. Eventually the single function will likely have a lot of conditions in it, which is a red flag for this situation.

andorov··on How New Ideas Arise
Ramanujan attributed all of his conjectures to being visited by a goddess in his dreams.

https://kristinposehn.substack.com/p/ramanujan-dreams?r=feux...

andorov··on My “favorite” magtape story
the Magic / More Magic switch is a favorite http://www.catb.org/jargon/html/magic-story.html
andorov··on Guide to Software Architecture Documentation
Also changes to the diagram (at a certain resolution) require looping in specific senior people for review.
andorov··on The Spaceballs Argument for Unconditional Basic Income
I'm not presenting an argument against UBI - I am pointing out that his argument is flawed.

Small tribes of humans defending hunting/foraging grounds is a state of pre-civilization. Life required work then too, and things were worse. His premise is that things used to be better and we've made it worse. Hard disagree.

andorov··on The Spaceballs Argument for Unconditional Basic Income
> Land used to exist without a monetary cost to access it. That was the natural way of things prior to the private property system and monetary system.

All land / resources were staked out by small tribes of humans who might kill you for using it?

andorov··on Problems with disk encryption in AWS
What about the disk being reused by another process without being thoroughly wiped by AWS?
andorov··on Questions about the hard limits of human intelligence
We can't even fully understand chess (or even checkers), in the way that we can completely understand tic-tac-toe.
andorov··on Why we ignore thousands of daily car crashes
You can buy clips that prevent the beeping.

The top result is also a bottle opener... https://www.amazon.com/seat-belt-buckle-alarm-stopper/s?k=se...

andorov··on Dangerous Gift
I got flagged for paying a friend back for "cuban food"...
andorov··on The rise of remote work may reshape college towns
computer science is applied math, and software engineering is applied philosophy
andorov··on X-COM
Heh also firing a stun grenade into your ship at the end of a mission. Promotions for everyone!
andorov··on Upsert anti-pattern in SQL Server
Thank you for your work! Postgres is great to use and the regular release of useful features has been a very nice benefit.

One unobvious (to me) but possibly necessary side effect of the INSERT...ON CONFLICT pattern is that it reserves a primary id for every row ahead of time, presumably because it does not know what will be updated and what will be inserted. We have a heavily updated table that started failing inserts one day because the primary id sequence hit the max int (2.1b), despite the table only reaching 100mm rows. The immediate fix was to reset the sequence to -1 and have it start going down...

andorov··on Bosch Smart glasses: A tiny laser array paints images directly onto your retina
What if someone hacks it to intentionally blind you?
andorov··on Learning at work is work, and we must make space for it
I found that studying philosophy has had an extremely useful application to software development and architecture.
andorov··on Four kinds of documentation
I think it is also useful to be aware of the specific terms your team might need and introduce words to those more abstract concepts. This frequently happens with naming specific code patterns or important classes in the code, but can also be for how the team operates in general. A DSL for how your team operates.
andorov··on Computational survivalist
This one too - 10 pages of Pascal to six shell commands https://leancrew.com/all-this/2011/12/more-shell-less-egg/
andorov··on The “greased sled” theory of Stonehenge
In Peru I saw are several very large stones sitting on the trail between the quarry and a partially finished temple. One of them at the bottom of a very steep hill. Our guide did speculate that getting the stones on site was a gradual process.
andorov··on Morocco abruptly drops clock change
Reminds me of Computerphile's The Problem with Time & Timezones - https://www.youtube.com/watch?v=-5wpm-gesOY
andorov··on Lead: America's Real Criminal Element (2013)
it's likely a society that has reached the point where it has the economic means & political will to replace lead pipes is also improving schools / etc at that point
andorov··on Three areas where self-driving cars will bring new opportunities
In most cases wouldn't you send a drone instead?
andorov··on Snap values itself at nearly $24B with its IPO pricing
The oldest demographic age target for their advertising is 35+
Page 1 of 2Next →