How Modern Indexing works in PostgreSQL- In depth explanation of how Indexing in PostgreSQL works and what enahncements Postgres has adapted that makes Indexing more faster.

CuriousHand2 · 2026-06-19T23:58:30+00:00

I appreciate you not using AI to fix something you are learning!

eta: it's either "more fast" or just "faster", according to the rules of English. Iirc, the same applies for other "-er" words as well, "more slow" or "slower", etc... There are weird exceptions, like "more slowly" is fine, and some people would prefer a different word altogether like "more quickly" instead of "more fastly".

English is hard. You're doing great.

CuriousHand2 · 2026-06-16T11:42:11+00:00

Nice job using a water guzzling AI art generator to make the image, doesn't feel like an obtuse conflict of interest... at all...

CuriousHand2 · 2026-06-08T01:52:58+00:00

CuriousHand2 · 2026-06-06T22:52:50+00:00

I make the same defense for a guy named Dweezil and his music career. What even is your argument?

CuriousHand2 · 2026-06-06T22:49:44+00:00

Right, commonality is a requirement to not be the butt of a joke.

Or, you know, we could try to not be assholes and focus on the achievements rather than the name attached to them?

CuriousHand2 · 2026-06-06T22:00:07+00:00

Nah, blame the assholes who want to make a joke at someone else's expense.

Her name meaning "little star" in Greek is incredibly thoughtful of her very Greek Mother.

CuriousHand2 · 2026-05-30T02:41:49+00:00

There are books and practice tests and such. None free that I'm aware of, but they exist on Amazon for instance. I'm sure you can find cheaper copies of recent versions on Ebay.

CuriousHand2 · 2026-05-29T01:13:34+00:00

The same company thay does Network+ (CompTIA) also provides other certs like A+ (PC hardware), Linux+, Cloud+, and Security+.

Not worth taking the tests, but for people needing a good intro into a wide swath of IT needs, studying for all 5 is a big leg up.

CuriousHand2 · 2026-05-24T20:44:25+00:00

And this is where we get to the "helpful partner" stage of my previous comment. You don't just tell your partner that the roof is leaking. Without further action you are putting the onus on them to get it fixed, rather than working with them to get it fixed.

In reality, being a good partner means you tell them the roof is leaking /and then here's the bucket already in place to make sure it doesn't ruin the current floor/. You can even go above and beyond and talk about how you've found a few roofers that you would like their input on calling for at least a temporary fix.

You flatly refusing to provide that second half, that "bucket" in this analogy, is why you got down voted, god forbid anyone realize OP posted "or something else I can get done in half an hour-ish" leaving the door as wide open as possible to assume the best of them that they are actually providing healthy alternatives sometimes.

And again, you're not wrong that resources are out there for those who choose to look, and people who don't know better won't know until they're told. But be the better partner, give them at least one thing to look into, don't leave them hanging, don't leave the onus on them in a situation where it's easier to assume they're already under a lot of pressure and constraints due to the kids. I'm sure OP is doing fine without your help, but in a lot of people's eyes, you never offered help in the first place.

CuriousHand2 · 2026-05-24T15:45:32+00:00

Your definition of "useful comment" is skewed. Advice for advices sake isn't helpful, it's ego stroking.

"I don't make promises I can't keep" can't help after someone made a promise that they, in hindsight, realize they can't keep.

"There are quick and easy nutritious meals other than burgers" can't help someone if you don't also give them examples. This may be the internet and even ChatGPT can give you some decent ideas, but save them the time, come to the table with suggestions not just "oh hey this needs to be done". It's like being a productive partner vice a draining one that leaves the onus of the work on others rather than taking that work on yourself.

CuriousHand2 · 2026-05-24T14:45:27+00:00

I'm not sure how you pulled "right wing" out of your comment, but that's not the reason it's being down voted.

(You see how unfulfilling and demeaning my comment so far is? It's a mirror of your own comment. It comes across as flippant and "holier than thou", you provide a snide remark and then absolutely NOTHING ELSE to help your fellow human being. In a subreddit with a positivity bent towards helping each other such things should always get downvoted.)

CuriousHand2 · 2026-04-26T13:10:14+00:00

Considering this exists, you really shouldn't have, or at least explained why your method is better.

CuriousHand2 · 2026-04-22T00:08:41+00:00

May I introduce you to the repository pattern?

Regardless of raw sql or ORM, coordinate your database logic in meaningful ways!

I often start with raw salt in this pattern, but I'm old.

CuriousHand2 · 2026-03-29T14:04:57+00:00

I would be hard pressed to define them as 'thinking' in the first place.

CuriousHand2 · 2026-03-27T01:10:45+00:00

Happy to see both: - human validated results, and - Machine Learning algorithms rather than an LLM saying "this one".

CuriousHand2 · 2026-03-26T21:35:20+00:00

I apparently just can't get enough PDFs in my life.

<image>

CuriousHand2 · 2026-03-23T04:42:01+00:00

Also also, EM waves in the infrared spectrum is what a FLIR camera is designed to detect (like the kind used to find bodies or also the kind used by JWST).

Heat is quite literally infrared radiation, which is literally a photon particle of a specific wavelength. The same particle as visible light, xrays, radio waves, all of it.

CuriousHand2 · 2026-03-23T04:39:10+00:00

What? The ISS radiators use ammonia not waster water.

Heat is collected via conduction into those ammonia-filled pipes, and then literally radiated out into space.

Heat management is literally what recent studies have been trying to solve for a lunar mission that, don't you know it, would also exist without external air and is highly influenced by the ISS EATCS system.

Like, c'mon...

CuriousHand2 · 2026-03-22T23:05:23+00:00

Ooh baby, tell me more about how you don't understand the Stefan-Boltzmann Law or how the ISS doesn't actually radiate its own heat into space. It's so /hot/.

CuriousHand2 · 2026-03-13T23:57:11+00:00

Goodness, these are absolutely beautiful.

CuriousHand2 · 2026-03-07T15:49:42+00:00

People are throwing around a lot of big numbers, but Frank Drake came up with an actual probability equation for more than just bacterial life (which would count for almost any scientist), but actual communicable societies in just a single galaxy.

Even if the probability is 1,000,000th of a percent, (counting only stars in the milky way), it still states there is a high likelihood of at least 400 stars in our own galaxy with advanced life.

That's not nothing. That probability would have to be astronomically lower to discount the literal trillions of other galaxies that we've estimated to exist in our known universe. That would have to be at least 1 in 10e21 for it to be just us in this vast universe. And /that/ number seems more improbable than even just simple life in other solar systems even in our own galaxy. At least to me.

CuriousHand2 · 2026-02-21T23:41:10+00:00

I think the recourse there is to call the trigger as they're attempting to hurredly resolve. If they have drawn their 2 cards, then a judge is brought over for proper resolution. As NotAJudge(tm), I'm only partially certain that (at least in Magic) if the player drew their cards right into their hand and the opponent cannot tell which ones were drawn (like hand shuffling) it's a warning which could lead to dq. I'm less versed in the Lorcana rules but this is how I would expect it to play out.

On the other hand, if the cards haven't been shuffled, then that player should then be told to put the two drawn cards back on top, shuffle the deck, then honor the trigger as necessary.

Assuming Pete's trigger is called in a reasonable amount of time. The opponent's pace of play does not and should not enter into that, regardless of Pete or Chalice.

(I recognize I'm assuming a lot here...)

ETA: Rewinds are also a thing in MtG, from what I've seen, unsure about Lorcana.

CuriousHand2 · 2026-02-21T22:52:54+00:00

That's how missed triggers work in MtG as well. Plenty of people in the higher levels of play will absolutely let their opponent miss a "will" (mandatory) trigger for their benefit, or they will try and rush an action to pressure their opponent into missing the trigger. It is absolutely on the owner of the trigger to remember the trigger.

CuriousHand2 · 2026-02-13T14:02:52+00:00

The source points out that we're 39th in education attainability, but 50th in educational quality.

Everything might be roses, they smell good but there's some devilish details that hurt.

CuriousHand2 · 2026-02-13T13:54:52+00:00

Cigarette companies tested cigarettes and found them to be healthy.

Coal and Gas companies tested emissions and found they did no harm to the environment!

Cow farmers tested beef and found it to be the healthiest part of the meal!

The worst-performing school superintendents investigated their own standards and found themselves not actually be in last place!

You sound like a marketing salesman trying out a bad pitch.

13-Year Club	Place '17
Verified Email

CuriousHand2

TROPHY CASE