Know who else has access to tax payer records, every IRS employee. Stop trying to make this like “oh my gosh I can’t believe anyone should have such access “. I trust Elon more than any IRS employee.
Consistency. Small discrepancies between environments.
Abstraction. Not assuming too much that you code yourself in a corner, but also not abstracting away so much that the code is difficult to work with.
Industry standard tools that have strongly opinionated built in paradigms (I would include terraform, ansible, etc.). I feel like the tools of future ought to be general purpose programming language frameworks just to avoid this, too many times I either can’t do something, or have to hack together something utterly convoluted, that could have easily been done if the tool was a framework and I could have just thrown in some Go or Python.
The best way I have found is to setup keepalived -> pgbouncer -> Postgres. Use repmgr to manage replication and barman for backups. Setup a VIP with keepalived with a small script that checks if the server is primary. You loose about 7-9 pings during a failover, have keepalived check about every 2 seconds and flip after 3 consecutive failures.
No, ISP’s are common carriers. You don’t go after the telephone company because someone coordinated a murder over the phone line. Why the hell would an ISP have any responsibility of what their users do?
Then repmgr for managing replication and barman for backups.
The stack is nice because keepalived gives you a virtual ip that you point your apps to, then you can promote a standby to primary (or have one auto promote on a failure) and the VIP will flip to the new primary. All in all you get like 5-10 seconds of “down” time when it flips (depending on how aggressive or conservative you want to be with the rise and fall settings).
Edit: caveat you won’t get keepalived to work if you are using AWS and spread your Postgres servers across AZ’s, they would have to be in the same AZ.
Edit 2: You can simplify the setup if you don’t need connection pooling, in that case skip pgbouncer.
We need to stop applying terms like “think” to AI and computers. Computers don’t “think”, they process, that is all. Comparing, or calling, a CPU to the “brain” is also extremely problematic, CPUs in reality are nothing like a biological brain.
That said, it’s impressive that a computer can process enough data to output an any sort of engine.
I have noticed this too. I suspect as HN grew, it caught the attention of bad actors that want to drive a particular narrative and they actively run campaigns that utilize both paid shills and bots.