Hacker News: jskrablin

New comment by jskrablin in "PostgreSQL is the Database Management System of the Year 2024"

jskrablin — Tue, 14 Jan 2025 16:25:05 +0000

Take a look at https://github.com/hapostgres/pg_auto_failover it's quite simple to use and manage. You can use libpq support for target_session_attrs (been there since Pg 10 - https://paquier.xyz/postgresql-2/postgres-10-libpq-read-writ... ) so you don't need active loadbalancer in front of your Pg cluster.

You can however create your own health/status check service on top of pg_autoctl show state and use HAProxy if required.

I don't think there's something easier to setup and manage than pg_auto_failover, Patroni always appeared very complicated to me.

New comment by jskrablin in "Nordic neighbours release new advice on surviving war"

jskrablin — Mon, 18 Nov 2024 18:20:43 +0000

Please stop with this nuclear nonsense. There's enough nuclear warheads in EU to make sure nothing is left of major Russian cities in case somebody got too bald. Dictators aren't suicidal maniacs, they're "just" maniacs.

New comment by jskrablin in "Why does everyone run ancient Postgres versions?"

jskrablin — Fri, 18 Oct 2024 12:00:31 +0000

Try https://pg-auto-failover.readthedocs.io/en/main/intro.html

New comment by jskrablin in "Ask HN: Why is Pave legal?"

jskrablin — Wed, 11 Sep 2024 11:30:41 +0000

ChatGPT did it!

New comment by jskrablin in "Police raids found Dior was using exploitative suppliers to produce luxury bags"

jskrablin — Sat, 06 Jul 2024 13:56:59 +0000

Gomorrah (Gomorra), book by Roberto Saviano explains fashion brands business like this in detail (among others). Highly recommend, though sometimes quite depressing read.

New comment by jskrablin in "In Colorado, an ambitious new highway policy is not building them"

jskrablin — Sun, 02 Jun 2024 03:46:45 +0000

I don't want to live in a city. It's noisy, polluted, crowded and I really like my small countryside house with plenty of land around it. Lived in a city for 20 years, got fed up with it, despite all of the alleged 'advantages' it offers. I guess I don't deserve decent infrastructure in your world view?

New comment by jskrablin in "Boeing 737 crashes during take-off in Senegal"

jskrablin — Thu, 09 May 2024 13:09:19 +0000

About that...

https://www.aerotime.aero/articles/24650-boeing-737-rudder-i...

https://en.m.wikipedia.org/wiki/Boeing_737_rudder_issues

https://www.flightglobal.com/pilots-get-guidance-on-new-737-...

And some recent rudder related issues on 737 Max

https://www.seattletimes.com/business/boeing-aerospace/ntsb-...

New comment by jskrablin in "United finds loose bolts on plug doors during 737 Max 9 inspections"

jskrablin — Mon, 08 Jan 2024 21:29:11 +0000

Or use a few drops of threadlocker...

New comment by jskrablin in "The Final Speech from The Great Dictator (1940)"

jskrablin — Sun, 17 Dec 2023 20:05:58 +0000

Every political system clouds the reason and appeals to emotion. There are very few policies anywhere that are grounded in science. They may be, initially, until they get massacred by politicians to get them aligned with currently dominant ideology (which by definition is a belief system, grounded mostly in fairy tales about who's better than everyone else).

Just take a look at the current state of democracy... and let me know where the science is hiding.

New comment by jskrablin in "HN website is/was down. I'm curious why?"

jskrablin — Tue, 12 Dec 2023 11:59:13 +0000

No.

New comment by jskrablin in "Croatia could be Europe's hidden tech haven in 2024"

jskrablin — Sun, 10 Dec 2023 16:35:30 +0000

The only real concern for remote workers is decent Internet connectivity. And that's a basically solved problem with 4G and/or Starlink. You can live anywhere you want... so why limit yourself to overcrowded capital with bad infrastructure? It's similar in Slovenia, everyone complaining about how bad prices in Ljubljana are but still fixated on living there.

It's been a while since I've been in touch with tech sector in Zagreb, but even then there were a lot of options ... Wouldn't say not much has changes in a decade or two.

New comment by jskrablin in "Ultra-white ceramic cools buildings with high reflectivity"

jskrablin — Tue, 14 Nov 2023 19:10:10 +0000

Big trees very close to a house? Not the best idea, you're always a storm away from serious damage to the house. Tree roots will also eventually damage any kind of surface around the house or house foundation. And trees with shallow roots are really probe to get knocked over in heavy wind.

New comment by jskrablin in "Do you make over 20k a month?"

jskrablin — Tue, 10 Oct 2023 10:47:38 +0000

You can't buy time. And a demanding job that'll get you that 20k/month will start to degrade your health at some point, rather sooner than later. And in most of the world even 'only' 1/4 of that will make sure you're living a quality life, esp if you can earn it with part time work while spending extra free time exactly how you want to.

But hey, people finding happiness in owning more than they can spend or use are free to work as much as they possibly can.

New comment by jskrablin in "Indoor wood burning raises women’s lung cancer risk by 43%"

jskrablin — Sun, 08 Oct 2023 15:00:05 +0000

I heat my house with a wood burning enclosed fireplace connected to an external air supply. Any other heating solution is kind of the less optimal choice when you own wood supply chain (forest and some tools to prepare wood for heating).

But yeah all those planet saving heat pumps need some advertising anyway.

New comment by jskrablin in "Database Performance at Scale – A free book"

jskrablin — Thu, 05 Oct 2023 21:24:31 +0000

Because SQL and relational data. They're (MySQL and Pg) a lot more familiar to setup and maintain. There's a lot of managed services offering for the usual SQL databases.

Cassandra/Scylla come with a lot of limitations when compared to typical SQL DB. They were developed for specific use cases and aren't at all comparable to SQL DBs. Both are completely different beast compared to standard SQL DBs.

New comment by jskrablin in "F-35A has flown from a highway for the first time"

jskrablin — Tue, 26 Sep 2023 09:29:38 +0000

Jet engine intake is basically a giant vacuum cleaner... and the jet engine itself can be destroyed by a small debris like small stones etc which is plentiful around any kind of a road. And a damaged jet engine is kinda bad news on takeoff, especially if there's only one to begin with.

A-10's high mounted jet engines are up there for a reason. It can operate from almost anything resembling a runway.

New comment by jskrablin in "PostgreSQL 16"

jskrablin — Thu, 14 Sep 2023 18:49:23 +0000

Maybe try pg_repack?

New comment by jskrablin in "Death by a Thousand Microservices"

jskrablin — Tue, 12 Sep 2023 07:07:50 +0000

Take a look at the OTEL (Open Telemetry) tooling and libraries. Or Grafana stack/offering with Prometheus, Tempo and Loki. Centralized logging and service calls/code execution tracing is not exactly new. It is often an afterthought.. and then you get yourself is this kinds of unpleasant situations.

And since you didn't implement correct tooling from the start, your team is even smaller and more limited... because you have little to zero idea on what your services are up to.

As per db instances... you upgrade them one by one. Unless there's some really bad bugs present (security or otherwise) there's no rush in upgrading stuff just because.

New comment by jskrablin in "Lithium discovery in US volcano could be biggest deposit ever found"

jskrablin — Sun, 10 Sep 2023 06:32:48 +0000

Glass melting furnace never stops after it's started. If it cools down it's basically destroyed so yeah, they run uninterrupted for years. Any maintenance or fixes need to account for that.

New comment by jskrablin in "Newly discovered comet Nishimura could be visible to naked eye this weekend"

jskrablin — Sat, 09 Sep 2023 11:14:27 +0000

I'd say that the Cold War had a far bigger potential to end the humanity than climate change currently has. It's a well known fact that we were on a brink of nuclear confrontation more than once during that period.