hans_castorp
Joined 12 years ago
Karma
859
Submissions
323
Member since
Apr 4
Recent submissions
Comment · 6 days ago
Only corrupt politicians will prevent laws that prevent corruption.
Comment · 16 days ago
This reminds me of "Creators admit Unix, C hoax" (e.g. https://www.gnu.org/fun/jokes/unix-hoax.html)
> We stopped when we got a clean compile on the following syntax:
for(;P("\n"),R--;P("|"))for(e=C;e--;P("_"+(*u++/8)%2))P("| "+(*u/4)%2);Comment · 23 days ago
A friend of mine used to give computer courses back in the 90s (to people that had never used a computer before).
At one point he said "You need to move the mouse up" and one of the participants actually lifted the mouse physically from the desk - which was perfectly correct for someone not being used to computers.
I always remember this when I think "isn't this obvious?" with regards to usage patterns on computers.
Comment · 2 months ago
The Postgres devs rejected it, because it wasn't part of the standard back then, and apparently work was going on, to include it into the standard.
Now that it's included in the standard, there is work to implement it:
Comment · 3 months ago
I frowned over the "none of it looked planned" - the whole description sounds as if that swim was exactly that: planned from the beginning.
Comment · 3 months ago
Typically no.
In most (all?) cases the pooler manages one pool per database user, so even if there was something leaking, it would not be anything that the database user couldn't access anyway.
But if you are paranoid, you can configure the pooler to run "RESET ALL", "RESET ROLE", "RESET SESSION AUTHORIZATION" and "ROLLBACK" before handing out a connection.
Comment · 3 months ago
Their license only disallows publishing the result of a benchmark
But you were always allowed to run your own benchmarks internally.
Back then, you could have installed 10gR1 and 10gR2 and compare the sort performance on identical data sets and queries.
Comment · 3 months ago
> Maps and satnav require a web connection.
No they don't require a network at all. The only drawback if there is no network is that the initial finding of the position takes longer. And maps can be downloaded so that they are available offline.
GPS receiver have been working without a "web connection" for ages (e.g. Garmins outdoor devices).
I use my smartphone in "airplane" mode but GPS enabled when hiking. No problems whatsoever.
Comment · 6 months ago
A side note on pgBackRest: PGX created a fork and announced to maintain it under the name pgxbackup:
https://thebuild.com/blog/2026/05/01/pgxbackup-continuity-su...
Comment · 6 months ago
German citizen as well.
So with a Jolla phone and Linux laptop, I am left in the cold.
Comment · 7 months ago
> If you want something that is more like actual recursion (I.e., depth-first), Oracle has CONNECT BY which does not require the same kind of tracking. It also comes with extra features to help with cycle detection, stack depth reflection, etc.
All that is supported with CTEs as well. And both Postgres and Oracle support the SQL standard for these things.
You can't choose between breadth first/depth first using CONNECT BY in Oracle. Oracle's manual even states that CTE are more powerful than CONNECT BY
Comment · 8 months ago
Ah, didn't see the caching part.
Plans for prepared statements are cached though.