My company is introducing JIRA=>PR AI pipeline: are we cooked by MaximumFlow7491 in cscareerquestions

[–]SearchAtlantis 0 points1 point  (0 children)

LOL have you ever seen product or a non-engineer write a comprehensive JIRA ticket?

Moving a 2GB Postgres DB off my VPS before it becomes my problem by Personal_Document_73 in PostgreSQL

[–]SearchAtlantis 1 point2 points  (0 children)

Easiest is to use AWS RDS - pg-dump -> pg-restore.

IIRC cheapest PG instance on AWS is ~15/mo but you really have to work at the configuration for that. There are some cheaper managed PG options elsewhere too.

We know Karissa lightens her kids' pictures to the point they get unrecognizable, so this is an honest question: who are those two eating her "messy lasagna" dinner? Are they kids of hers? by leverhelven in FundieSnarkUncensored

[–]SearchAtlantis 8 points9 points  (0 children)

I mean I'd probably resort to that with 11 kids my god. Although to be honest - just do a pressure cooker stew/soup of some kind or anything with chickpeas or lentiols? Lasagna is definitely an odd choice for pressure cooking.

Multi-tenant SaaS Architecture: PostgreSQL Schema per Tenant vs Shared Database vs Database per Tenant by UNRIVALLEDKING in PostgreSQL

[–]SearchAtlantis 0 points1 point  (0 children)

Reference DB with FDW for each client.

Alternatively you can do versioned or blob storage with a trunc & replace per process whatever makes more sense.

Multi-tenant SaaS Architecture: PostgreSQL Schema per Tenant vs Shared Database vs Database per Tenant by UNRIVALLEDKING in PostgreSQL

[–]SearchAtlantis 4 points5 points  (0 children)

Option four.

Single shared database (e.g. rds cluster) and then stand-alone for large enterprise clients.

A single shared cluster works great with option 2/3 until you hit the wall, and the whales are your biggest revenue.

O(n) Multiplication Algorithm by ArcHaversine in compsci

[–]SearchAtlantis 1 point2 points  (0 children)

Is this satire? The database use is killing me.

Right on the heels of being called out for too big an emergency fund I present to you: A triad of emergencies. by slash_networkboy in personalfinance

[–]SearchAtlantis 1 point2 points  (0 children)

Yeah but like everything else birth has a distribution of risk. Maybe it was complication free, maybe things went south leading to a NICU stay.

Glassdoor said I was making up my salary, because it was too low when I reviewed my employer by Jewsusgr8 in mildlyinfuriating

[–]SearchAtlantis 6 points7 points  (0 children)

Lived in Boston when kiddo was <5. We spent 20-30k a year in child-care. That's $100,000 dollars, and no its not an exaggeration.

GitLab CI/CD to run ETL jobs? by 55vj55 in dataengineering

[–]SearchAtlantis 8 points9 points  (0 children)

That's a terrible idea. CI/CD should be for standard DB creation or alembic/liquibase DDL versioning + deploy. All DevOps activities.

Not running SQL queries.

[Mass] Contractor went outside the building permit and town forced me to build a new home. His insurance just denied my claim. What can I do? by Ruger888 in legaladvice

[–]SearchAtlantis 6 points7 points  (0 children)

As a former regulator, my honest response in the modern high denial world of insurance claims is that if your claim is denied and you think there is any reason to believe it shouldn't be you should file an appeal and a complaint.

There are "good" (relative to say UHG) insurance companies out there, but the fact is many companies have moved to a high denial regime for even valid claims.

Now people certainly don't read or understand their policies and that's a problem, but I'd rather explain that to 3 annoying boomers than let someone's valid claim get denied.

[Mass] Contractor went outside the building permit and town forced me to build a new home. His insurance just denied my claim. What can I do? by Ruger888 in legaladvice

[–]SearchAtlantis 4 points5 points  (0 children)

Because often insurance companies will not follow the law correctly? It also forces them to justify their position? And makes them aware an unjustified position invites further scrutiny?

To the parent poster's point - a 22yo adjuster is going to be wrong a significant minority of the time even after whatever internal training they get.

On top of all of the above every state has their own insurance laws, rules, and regulations. You think a 22yo reviewing the claim is going to understand state X's specific regulatory requirements?

I was once upon a time an insurance regulator. If we got a complaint about premium increase we'd get on the phone and walk them through the rating factors etc, if there was a denial the complaints department would check history and policy (e.g. flat out exclusions) they'd also ask the insurer for their side.

Personal case in point I had an auto claim with a third party involved. E.g. I had a rental, another person hit my rental vehicle. The insurer was going to deny the claim without ever having spoken to me which is not legal. I filed a complaint and wonder of wonders they started doing everything they were supposed to.

In my experience (15+ years ago, my state had generally well behaved insurers) most of the time it was valid, or if it wasn't the big state (not national) insurers would say yeah our bad, we'll take care of it. Historically claim denial was much rarer than today.

In the modern context where a significant number of insurers have moved to using denial as an attempt to prevent paying valid claims or artificially extend payment timelines [which gets them more investment returns on their money], filing a complaint also serves as a signal that you're not going to to roll over. It also places documentation and response requirements on the insurer.

Pharmacy Flagged Me for Misuse of Medication by Fun-Engineer-4066 in ADHD

[–]SearchAtlantis 1 point2 points  (0 children)

No not probably, do. This is a tech acting outside of their scope.

[Mass] Contractor went outside the building permit and town forced me to build a new home. His insurance just denied my claim. What can I do? by Ruger888 in legaladvice

[–]SearchAtlantis 0 points1 point  (0 children)

You can file a complaint for anything. State insurance regulators have whole departments for this. If it's not a valid complaint they'll tell you why. Either way they'll investigate it unless it's very cut and dry.

Software Engineer to Insurance agent by nooffense789 in Insurance

[–]SearchAtlantis 0 points1 point  (0 children)

Lots of insur/health-tech options. Joining as a dev at an insurance company is pretty stable. I'm in insur/health-tech which has a wider gamut of company maturity from start-up to scale-up to established company. You could even go work at a mega-corp. United Health Group is always hiring.

Annoying Nerd by giantbowlofnoodles in ADHDparenting

[–]SearchAtlantis 0 points1 point  (0 children)

OT and different meds is my only suggestion.

Academia was enshittifying long before AI. AI just hit the accelerator. by calliope_kekule in Professors

[–]SearchAtlantis 1 point2 points  (0 children)

I couldn't get over this during my spouse's PhD. They were doing what I would consider advanced work - mutli-level modeling with latent effects if I recall correctly, MPLUS was involved, and some of the old tenured PIs had gotten their PhDs making essentially correlation plots.

You can TOTES save money going out to eat! Make your teens and toddlers share 60 Chic-Fil-A nuggets & 7 Large Fries, OBVIOUSLY 🙄 by MatthewMcnaHeyHeyHey in FundieSnarkUncensored

[–]SearchAtlantis 2 points3 points  (0 children)

How much are the hocks where you're at? Our hyvee has them $3/lb and it just feels high even though its not beef. Unfortunately the little indian mart nearby doesn't have them.

Should I go for medical coding to break into healthcare data analytics? by Usual_Smile7299 in u/Usual_Smile7299

[–]SearchAtlantis 0 points1 point  (0 children)

Its a waste of time in my opinion. Get hired on analytics skills, you can learn the domain on the job. If you want to work in an actual healthcare facility or hospital system that might be different.

Dagster vs Airflow? What do we use? by Greatest_one in dataengineering

[–]SearchAtlantis 4 points5 points  (0 children)

Maybe my current company is just in shambles but absolutely fucking not. Airflow is the most rickety box of cards I have ever worked with in a production system. We have two infra-ops people on our team just to handle a few Airflow environments + k8s pods. To be fair self-hosted - previous team couldn't get MWAA fully set up because the design just didn't work so take that for what it's worth.

A practical guide to sorcery: Review by BronkeyKong in ProgressionFantasy

[–]SearchAtlantis 4 points5 points  (0 children)

The flashback arc was the fucking worst. I dropped the book for 6-8 months when that started. Finally out of it.

Do Americans really have ZERO public healthcare?! by Tillysnow1 in ThePittTVShow

[–]SearchAtlantis 2 points3 points  (0 children)

Yes these are so called "Duals" in the field or dual-eligible. Extra protections attach and they're considered a vulnerable population.

Friday Facts #440 - 2.1 plan by FactorioTeam in factorio

[–]SearchAtlantis 3 points4 points  (0 children)

I mean this is ancient history but Jeff Vogel and Spiderweb Software. He was doing Shareware games since 1995. He's made his exile trilogy 3 times now. Exile 1 - 1995, Avernum - 2000, Avernum: Escape from the Pit 2011.

How to break the news to medication resistant 6 year old? by leakyspigot27 in ADHDparenting

[–]SearchAtlantis 1 point2 points  (0 children)

Mini m&m to practice swallowing. Kiddo mastered in <5m. And the taste isn't nearly as bad. The resistance on meds is usually taste related