You can tell the LLM to optimize the Django ORM. With ORMs, large structural changes are sometimes needed for small query text changes due to how ORMs generate the SQL.
I’m a SWE and at my previous job it fell to me to optimize some queries that used EF Core ORM. I gave opus a local db with a small export of anonymized prod data, had it generate a billion rows with similar cardinality.
Then I told opus how to get the raw SQL and told it to write unit tests with various optimizations.
It got the query down from 5+ minutes to a few seconds. I verified the final SQL and ORM structure.
All it needed was to modify some indices and fix up the ORM to properly generate the lateral join.
However, to get the join working properly required a full restructure of the ORM query.
I have and have come to the conclusion it's too risky. On too many attempts it hallucinates correctness and subtly breaks edge cases
>large structural changes are sometimes needed for small query text changes due to how ORMs generate the SQL
Sometimes that's true but a lot of times you can get 90% the benefit with significantly lower risk with a much smaller targeted changes.
It can check correctness against real data but I've still hit problems where you can just look at the rewrite and identify behavior differences that don't necessarily show up in 1 off execution comparison unless you brute force your way through tons of test data.
A lot of the cases I'm running into are somewhat older code (5+ years) with poor test coverage that few people understand or remember. Some of these probably have legitimate bugs but it's risky assuming and safer to ensure an optimization is identical.
Worse, it’s “don’t worry, the next data centers will be in space, so it’s okay if the ones we are building right now destroy the environment, there won’t be anymore!”
Religion provides certain benefits in the military. If you are say a Christian, you get assigned time to go to a (hopefully) air conditioned church and relax and recover. Even if it’s short, it can be beneficial to collect yourself in a high stress situation like basic training/boot camp.
If you elect not to go to a religious service, you typically have to keep doing whatever you are doing. Atheists or other less organized religions should be treated equally under the law. If a Christian gets a 90 minute religious service, an atheist should also get 90 minutes to do whatever they want.
You also see this reflected with something like The Satanic Temple advocating for human rights under the guise of religion.
In my opinion, religious organizations should not have any more rights or privileges than businesses.
This was true 20 years ago (not sure about now). As an atheist/agnostic in basic training I used to try different church services to get away from the barracks on Sundays. If you didn’t you were definitely assigned some cleaning detail instead of having down time. At the time it didn’t come across as discrimination and felt more like a way to keep control. At various times when control was lax bad stuff happened, e.g. fighting, sex, awol, etc. In a new light this does seem like it has a disparate impact.
I am curious how the variety of faith based practices could be handled…I’m super on board with providing a universal spiritual/mental health space regardless of your affiliation. That gets very weird when you start having to account for the variety of schedules and practices.
I am pretty sure I disagree on religious orgs having no more rights than a business. I think that seriously under accounts for the degree of identity that folks get from their religious affiliations and the types of activities businesses and religious groups tend to do.
A business and religious group are pretty fundamentally different…I’d have to reflect a lot longer and harder to come up with a more stable and coherent stance on that. I can definitely think of valid arguments on either side.
> I’m super on board with providing a universal spiritual/mental health space regardless of your affiliation.
This is what was happening in the Army's Chaplain Corps[1] prior to this administration: Seeking to emphasize and credential Chaplains as mental health specialists in an organization with a consistent track record of personnel with pervasive mental health problems.
It seems that has all been scrapped and we're going to fix mental health problems with "good ol' religion".
[1]: I can't speak for the other services but probably the same.
I guess my question is does it make sense for the US government to spend money providing church services for people who just want mental health benefits, and a break? I think believing a religion is very different from creating a religion so that you can maximize government benefits.
Chipotle uses IPSoft Amelia. Amelia is quite horrible software, a place I worked did a bake off about 10 years ago and Amelia failed so miserably it was actually funny.
It’s pretty useful. We used it at a previous company. We built a custom backend, but used the spec and SDKs.
It took like 2 weeks to build a full custom backend. SDKs across languages worked flawlessly (okay, we did find one bug, reported it, and it was fixed within the day)
AWS makes ZDR promises
reply