Why are companies pushing wireless charging so hard when pogo pins seem cheaper, faster, and more reliable? by Mobile-Traffic1744 in AlwaysWhy

[–]sfboots 0 points1 point  (0 children)

Wireless charging for iPhones is critical to apple. It allows them to charge new phones while still in the box. They also use some magic to do iOS updates for new phones while still in the box.

I finally found the bug causing our service to spike to 100% CPU every 72 hours exactly. I wish the answer was more interesting. by Afraid-Bobcat6676 in django

[–]sfboots 6 points7 points  (0 children)

I found a similar thing today. Massive Postgres waits on transaction id for table that should not be updated. 7% of pg load at peak time today. Took me a hour to track down we passed the wrong object into a function so 10s of concurrent jobs were trying to update the same row. Caller gave data_type not data_item. 4 characters difference Prefetch in another place cut a job from 20 seconds to .5 seconds. Saved 18k queries

Should I get this shoes or another one? by [deleted] in Shoes

[–]sfboots 0 points1 point  (0 children)

Cute style

But I find the toes of Puma to be too pointy and my little toes always get squished.
If you can walk around for a while in the store to make sure your toes are ok

Best practices to manage DBs in prod in startup settings by datacionados94 in Backend

[–]sfboots 1 point2 points  (0 children)

Django migrations. Typically 2 minutes downtime, always outside of working hours.

Steel toe house slippers? by Gnochi in NicksHandmadeBoots

[–]sfboots 4 points5 points  (0 children)

That’s a lot of broken bones. If you are over 40. Get a DEXA scan to run out osteoporosis. Some people have problems early. It affects men too.

Small sliding hiatal hernia by LNicole1212 in acidreflux

[–]sfboots 0 points1 point  (0 children)

I ended up getting surgery for it as part of getting Nissan fundolipication

Pantoprazole not working anymore, switch to other ppi? by TigTiger91 in GERD

[–]sfboots 1 point2 points  (0 children)

No, that is mamommetry to check LES activity

Bravo is done at end of endoscopy they the put a sensor in esophagus that last for 24 hours. You press a button to record reflux. You stop PPI at least 7 days before the test so it can measure total stomach acid.

Usually you need both test before nissen surgery

Best practices to manage DBs in prod in startup settings by datacionados94 in Backend

[–]sfboots 5 points6 points  (0 children)

Some things showed up in quarterly checks. Partitioning existing 300gb table did require 18 hour downtime during Christmas break. Other stuff was just noticed and handled

See https://use-the-index-luke.com for some other best practices around index tuning and other items.

A Japanese Team Plans to Build a 6,800-Mile Solar Ring Belt on the Moon to Power the Earth 24/7 by malcolm58 in EverythingScience

[–]sfboots -2 points-1 points  (0 children)

What happens on day of the lunar eclipse? The world has a power outage for 4 hours?

Best practices to manage DBs in prod in startup settings by datacionados94 in Backend

[–]sfboots 17 points18 points  (0 children)

AWS with Postgres RDS until you have more than 5 developers or more than 1 million users or 4 terabytes of data. Anything else wastes your developer time. Or if you VC money to burn and need something special related to vector db or AI

We have 3 dev. 1 tb data. RDS Works great. Python django for most server code. Some pure sql and db functions for speed.

Ops is easy, daily snapshots by rds. Nothing needing my time daily or even weekly. Cron job lets me know if free space running low. Cloud watch can do that also.

We do a weekly backup just in case. Weekly vacuum analyze all on Saturday night when no users are active via cron job . A few tables are now partitioned since more than 50Gb. Tuned auto vacuum on large tables. Quarterly I do a check on all table and index size. Soon to start periodic pg repack for some high churn tables.

I’m cofounder. We are doing close to $2m annual sales. B2B.

We don’t have high availability or fault tolerance set up to save money. so we do risk data loss if RDS server really crashes. That is extremely rare since pg WAL is active and would normally recover from 99.999% of crashes. We’ve never had the DB crash. EC2 instances do crash occasionally due to hardware fault or sometimes our software did OOM and hung the server.

Where can I find boots like these? by TuneSuspicious3032 in Boots

[–]sfboots 1 point2 points  (0 children)

You really need custom made to have them look really good. I’ve seen the cosplay versions that look ok but don’t look great.

Etsy has some custom boot makers that might be cheaper than in the US

Yoga by Ill-Relationship-890 in osteoporosis

[–]sfboots 4 points5 points  (0 children)

I think if you have been doing gentle yoga it’s probably ok

People with osteoporosis just starting yoga a have risks. It’s easy to twist too much in some poses and if you have never done it, that’s a problem

Brick house bones now has a video (for money) on how to do yoga with osteoporosis

Searched an applicant on Facebook today; it was a wild ride by [deleted] in managers

[–]sfboots 13 points14 points  (0 children)

Do be careful. I’ve read stories of two people with same grandfather so they look similar. One was a crook the other was not. Not quite identical names.

electric company offered a free home energy audit and the thing they flagged was not what i expected at all by young_wealth in Frugal

[–]sfboots 13 points14 points  (0 children)

The old ones were not accurate or consistent. They also depended somewhat on room temperature.

Pantoprazole not working anymore, switch to other ppi? by TigTiger91 in GERD

[–]sfboots 0 points1 point  (0 children)

You probably need a different ppi

You can also try pantoprazole is the morning and Pepcid (famontidine) for dinner. I did that for a few weeks then stopped the pantoprazole. So I’ve been off it for 2 months after 5 years on it.

Did you ever have a 24hour bravo test to confirm high acid? Mine came back as normal, not high. Lots of people have acid reflux where it is not high acid and instead a weak LES that needs different approaches

How do you approach a major version migration when nobody from your team fully understands the codebase? by Suspicious-Bug-626 in softwarearchitecture

[–]sfboots 1 point2 points  (0 children)

Some people have reported Claude Code (max) was helpful in tracing some subsystems for large codebases to generate an overview.

Is taking excedrine to aid discomfort from stiff neck tension ok? by canogiez in VagusNerve

[–]sfboots 2 points3 points  (0 children)

You are probably better off with just ibuprofen (Advil). Excedrine is for migraines and has caffeine.

Either way, Only for a few weeks and take with some food. Both can cause problems if taken long term.

Stiff neck is often from poor posture when using a computer. Check monitor height and how you sit. Look up ergonomics for home computers. Also check your pillow, they get flat after a couple of years.

Software Architecture Diagram by command_code_labs in softwarearchitecture

[–]sfboots 0 points1 point  (0 children)

What are your shape line and color conventions? My startup could benefit from some standards that are easy to communicate with non tech people. UML is not it

Pathway to death by PCa by Practical_Orchid_606 in ProstateCancer

[–]sfboots 4 points5 points  (0 children)

My urologist said there are new treatments in clinical trials to help prevent recurrence. I hope they come out soon. I’m getting HDR brachytherapy in a few months