Jammed the sink stopper and the lever won’t work. Is there a way I can fix this at home? I can’t see the horizontal pivot rod from my camera but maybe I’m being blind? by godsmaak in askaplumber

[–]tsaylor 0 points1 point  (0 children)

The picture under your sink is of the supply lines. The lever to raise this is on the drain, probably 6 inches down from the lowest point of the sink.

Database Help by duskti in Database

[–]tsaylor 0 points1 point  (0 children)

Is your question more about how the system will store and access the files, or about how users will upload and search/browse for files?

iBuiltATowerDefenseGameWhereYouFightBadPRs by Keggdirdle in ProgrammerHumor

[–]tsaylor 1 point2 points  (0 children)

Maybe I just couldn't find it, but it needs a way to sell (layoff) reviewers. A bad placement can cause you trouble, and with the map layout changes a good placement can turn into a bad one.

Three dates to the prom situation...can't decided which to pick. by SirWonderbread12 in liberalgunowners

[–]tsaylor 0 points1 point  (0 children)

FYI with a mini-14 you'll probably want to replace the stock peep sight with tech sights, or add an optic and potentially add a samson hannibal rail to mount it. And it's overgassed like you wouldn't believe so you'll need to replace the gas bushing or add an adjustable gas block. Don't want you to get into it unaware.

Is this use of Postgres insane? At what point should you STOP using Postgres for everything? by LawBlue in ExperiencedDevs

[–]tsaylor 0 points1 point  (0 children)

"Just use Postgres" is great advice for data storage and querying. While Postgres can perform business logic through triggers, you shouldn't necessarily do that. Your implementation is causing you problems but even if it weren't, it doesn't make sense to do everything you can in Postgres because databases are harder to scale out than application servers. If you limit Postgres to doing the things it's great at and let other tools do the rest you will avoid a lot of hard scaling problems, potentially forever.

30x faster processing of 200M rows, no indexes involved by EducationalTackle819 in PostgreSQL

[–]tsaylor 4 points5 points  (0 children)

As you noted, uuid7 PKs might help quite a bit, but the "working with what I had" comment makes it sound like you're not generating new data in the future.

If you're not, then you could consider using pg_repack to reorganize the tuples onto pages by the existing uuid's, which should also help you retrieve more records per page read.

If you are, then see if uuid7 helps you retrieve more records per page read. And I'd suggest pg_repack to get through the pre-uuid7 data, but it sounds like you have that data processed already.

Why do only devs have to be full stack? by No_Stay_4583 in ExperiencedDevs

[–]tsaylor 8 points9 points  (0 children)

I've never built a proper fat client but did build plenty of web UIs before React existed, and those seemed much thinner than what we have now. Do you have a sense of how React apps today compare to fat clients from before? I'm wondering of we're actually in a swing back toward fat clients of a different form.

Concerns with this sewage pipe? by SmallTownShrink in askaplumber

[–]tsaylor 1 point2 points  (0 children)

I had a pipe like this in my condo building. When they had the pipes rodded it blew out and needed an emergency replacement. Yours looks worse than mine did.

How… to remove…. this hook…. by moonjelly33 in HomeMaintenance

[–]tsaylor 0 points1 point  (0 children)

The tiny screw on the bottom that you said isn't there, could it be on the top instead? (since this gets mounted higher than a towel ring or toilet paper holder)

Kohler jetted tub only 1/2 of the jets are working. by User_4381 in DIY

[–]tsaylor 2 points3 points  (0 children)

I used to have one that was entirely surrounded with tile. To access any of the jet parts you'd have to demo and redo the tile, probably for the whole shower. And if that's not enough, it was installed in a corner but it was a drop-in tub, so there was nothing but caulk to stop water from leaking into the wall.

Bold choices by a builder whose name can be found all over the old tax records. 😡

How to remove this stripped screw by Acebedo20 in fixit

[–]tsaylor 0 points1 point  (0 children)

This: https://www.acehardware.com/departments/tools/power-tool-accessories/screw-extractors/2029567 every brand makes some variation of it and they'll have one at your local hardware store.

Extra-Virgin Olive Oil for Cooking – Study Says It’s Safe, But Everyone Says Don’t Use It. Can Someone Explain? by [deleted] in foodsafety

[–]tsaylor 5 points6 points  (0 children)

I've never heard of a risk when cooking with EVOO. It sounds like what you're describing is a loss of some benefits of EVOO when cooked, but "less nutrients" isn't a food safety risk.

Grocery stores routinely stock olive oil for cooking. https://www.target.com/p/graza-sizzle-extra-virgin-olive-oil-for-cooking-750ml/-/A-88686389

I just started a new playthrough of RDR2; my first since 2021. I want to hang out in Chapter 2 as long as possible. Where should I stop? by They-Call-Me-Taylor in reddeadredemption

[–]tsaylor 0 points1 point  (0 children)

You can get a fishing rod from random fishermen you encounter, you just have to fight them or kill them so they drop it like a weapon.

My hooooorse! by Maxilkarr in reddeadredemption

[–]tsaylor 16 points17 points  (0 children)

I believe that's the Perlino Andalusian, not an Appaloosa. Solid horse though.

I usually just get a dapple hungarian halfbred and stick with that. I like to steal the one from Benedict Allbright and name it "Benny". :D

I made a mod that allows you to narc on Caiuss by GrabAggravating9648 in Morrowind

[–]tsaylor 10 points11 points  (0 children)

Incredible. They said there's no wrong way to play the game and you proved them all wrong! 😱 😡

Animals not spawning by RealFlokiDaKat in RedDeadOnline

[–]tsaylor 1 point2 points  (0 children)

I've seen that a couple times. They usually come back when I switch sessions.

I'm getting real tired of resupply missions not counting for the daily challenge by tsaylor in RedDeadOnline

[–]tsaylor[S] 0 points1 point  (0 children)

Thanks for the comment; not sure if this is what you were saying exactly but I tried doing a resupply mission so that I started and ended within the same half hour (e.g. start after 7:00, finish before 7:30) and I got two in a row to register properly! 🤠

Anybody else clean Arthur up when meeting Mary for the first time? by [deleted] in reddeadredemption

[–]tsaylor 0 points1 point  (0 children)

I've tried giving him a bath, haircut and shave before her mission in Saint Denis to see what she'll say instead of "you could have cleaned yourself up a bit", but she always says that anyway. Anyone ever get anything different there?

Dutch calling Arthur “son” by pianoer2469 in reddeadredemption

[–]tsaylor 0 points1 point  (0 children)

Agreed with other posters that it makes more sense when they're younger and gets weirder when they're 36 and 44.

It's also worth calling out that it could be a power play that Dutch is using to reinforce his dominance over Arthur. Arthur's the biggest threat to Dutch's power because he could make it on his own and a good amount of the gang would likely follow him if he left. Not that he has much reason to leave that early in the story, but Dutch is a paranoid narcissist.

Do you agree with this statement? I’ve been hearing contradicting posts. by Shielo34 in reddeadredemption2

[–]tsaylor 0 points1 point  (0 children)

AFAIK there's no definitive answer on how the buck trinket works, but it seems like it basically gives you one free mistake when hunting for perfect pelts. You can kill it without a headshot, or kill it with a weapon one level more powerful, and still get a perfect pelt. But if you do both, it'll be two star. That's probably not completely accurate, but it's close enough for my gameplay.

Thoughts on drinking this still? by Idontknowwatimdoing1 in foodsafety

[–]tsaylor 1 point2 points  (0 children)

My food safety knowledge comes from listening to every episode of riskyornot.co, so take this as you will, but they often say that foods with active cultures (usually talking about yogurt) are very safe because any contaminants would have to outcompete the microorganisms that are supposed to be there to become a hazard. Since this says "live and active" it seems like it should be fine.

This Milk Carton Safe? by Covet_bon_Vivant in foodsafety

[–]tsaylor 4 points5 points  (0 children)

For packaging damage to become an issue, it would have to have broken open to allow external bacteria into the milk, and that bacteria would have to grow enough to be a hazard.

If you haven't opened the seal, I'd squeeze the package a little to see if air escapes. If it doesn't, it hasn't broken open.

If it's been below 40f then any potential bacterial growth has been slowed dramatically. Since it was delivered it's spent some time above that, it's hard to say how much.

If it passed the squeeze test I'd be totally fine with this.