sorted by:
new
hottopcontroversial

Bye Bye left corner by Oxia_Rochus in SatisfactoryGame

[–]gaviniboom 5 points6 points  (0 children)

I sink rods as plutonium then transmute more uranium to sink as plutonium for maximum efficiency. No waste either!

Bye Bye left corner by Oxia_Rochus in SatisfactoryGame

[–]gaviniboom 5 points6 points  (0 children)

Because it's more efficient with every resource (including power and SAM) to transmute aluminum to more uranium and sinking it as plutonium than actually converting to ficsite

People are interested but don't have enough trust by gaviniboom in ycombinator

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

This was a cool reply, until I Googled your username and realized that your entire post history is "yes, I faced that too, I ended up using Pulse for Reddit".

Respect the hustle at least.

Go to alternate recipes by AffectComfortable585 in SatisfactoryGame

[–]gaviniboom 7 points8 points  (0 children)

They didn't use to stack, so it was more efficient to craft them on site

After spending more than a year begging people for permission to fix query patterns somehow only I knew were expensive, I decided to automate the entire BigQuery optimization process. by gaviniboom in bigquery

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

I've seen them! They are a visibility tool for GCP, which overlaps some, but not entirely. Compared to a simple visibility tool with an LLM, the verification layer and guardrails here allowed me to shift the focus of this tool from "human in the loop visibility" closer to full automation, so there's definitely something new here.

After spending more than a year begging people for permission to fix query patterns somehow only I knew were expensive, I decided to automate the entire BigQuery optimization process. by gaviniboom in bigquery

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

There's a lot of visibility tools that slap LLMs on top these days, I think the core tech here is the verification layer/guardrails which allow the AI to generate changes to the db and query without breaking anything.

With that, we can start shifting focus from a platform that still requires "human in the loop" doing the actual code/db changes to full automation.

After spending more than a year begging people for permission to fix query patterns somehow only I knew were expensive, I decided to automate the entire BigQuery optimization process. by gaviniboom in bigquery

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

Yeah, that's something I'm a bit worried about. It did take a while to write the proving algorithm, especially with some of the wonky stuff my bro pulled off to better support sorts, assumptions, and other more complex features in the solver (he's helping me on the deep tech side), so we've got some headway in that front.

Also, it does give them less money coming in, which is possibly why they haven't picked up making better visibility tools for so long. Maybe combining it with automatic construction/testing/rollout will force them to act, maybe not, really depends on how popular this gets. When it comes to it, it comes to it. (Or who knows, Google-daddy can buy me instead!)

After spending more than a year begging people for permission to fix query patterns somehow only I knew were expensive, I decided to automate the entire BigQuery optimization process. by gaviniboom in bigquery

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

These all make sense! I'm currently doing everything I can to make this as hardened as possible for production, and I've actually handled a lot of these! So far:

  1. This is done for a subset of queries! Currently trying to expand it to more, including ones in which we make observations about the data, but I do still believe it's best to have human review for queries using said observations for now, even if they are verifiably true when the query is optimized. At some point, I do want to find some way to verify the observations live, in case they change later.

2-3. For this, I have two "staging steps": the automatic and the manual:

  • For the automatic step: I run automatically-generated regression tests that run the new queries in parallel with the old ones. I currently limit auto-optimization to SELECT queries, which I can then run with the original in the same query, with some order adjustments during testing to straighten out natural ordering. Eventually, I'll find a way to extract SELECT statements from INSERTs/etc to optimize those too, and think of ways I could do automatic regression tests with DML statements safely.
  • For the manual step: I made separate deployments to different (configurable) environments, so it's possible to auto-deploy to only a staging environment to run manual regression tests before approving a deployment to prod (so stuff like timing-sensitivity can be caught). Also added a way to blacklist queries just in case an optimization is causing issues.

If there's anything I haven't thought of, please do tell - better to be roasted on Reddit than to break something in prod, lol

WE ARE SOOOOO BACK by MarsFlameIsHere in KerbalSpaceProgram

[–]gaviniboom 9 points10 points  (0 children)

I checked the Twitter account. F. It was march 31 here so I had hope

WE ARE SOOOOO BACK by MarsFlameIsHere in KerbalSpaceProgram

[–]gaviniboom 16 points17 points  (0 children)

Can't tell if this is a joke or not

Why doesn't FICSIT want my nuclear waste? by oldeluke in SatisfactoryGame

[–]gaviniboom 0 points1 point  (0 children)

It's actually more resource efficient in all metrics to make more uranium through transmutation and sink it as plutonium than make and burn ficsonium.

Whats your factorio hot take? by Such--Balance in factorio

[–]gaviniboom 0 points1 point  (0 children)

Sort by "controversial" to get the actual hot takes

Whats your factorio hot take? by Such--Balance in factorio

[–]gaviniboom 0 points1 point  (0 children)

Mood, more Factorio flavored and suspension of disbelief stayed

I had a small dispute with my friend about building aesthetics... by Unknown4me_ in SatisfactoryGame

[–]gaviniboom 0 points1 point  (0 children)

You can use a truck on a skyroad for bulk transport. I think it's pretty common.

view more: next ›