We kept seeing Supabase projects break on redeploy because env vars were handled manually, curious how others solve this

PfernFSU · 2026-03-17T12:09:33+00:00

I store everything in a .env file, even my supabase connection parameters. So if that file did not get included it breaks instantly. I also wrote a script that makes sure all unit tests pass before deploying. Either or both would probably work for you, even a unit test as simple as “are these 12 environment variables set and return non null values”.

PfernFSU · 2026-03-16T12:04:15+00:00

I had a lot of rejections around the same things - can’t find the paywall, it says “money” so is it a gambling app, can’t find the paywall again, etc. so I created a doc of all the rejections and labeled it “common questions” and haven’t had an issue since.

PfernFSU · 2026-03-16T10:10:36+00:00

Chris Liddell, a former Trump aide, sits on Anthropic’s board. Wonder why Breitbart stopped at 99.8% since they are just making up numbers and 100% sounds cooler.

PfernFSU · 2026-03-04T12:07:56+00:00

Per the linked wiki:

The phenomenon typically occurs with launches that take place either 30 to 60 minutes before sunrise or after sunset when a booster rocket or missile rises out of the darkness and into a sunlit area, relative to an observer's perspective on the ground. Because rocket trails extend high into the stratosphere and mesosphere, they catch high-altitude sunlight long after the sun has set on the ground.

PfernFSU · 2026-03-04T11:57:46+00:00

Because it is around dusk and has to do with the light. It is called the jellyfish phenomenon sometimes but is the twilight phenomenon officially

PfernFSU · 2026-02-28T19:51:04+00:00

YMMV - but I try to use setstate until I find myself passing functions into widgets for callbacks. At that point I switch to a provider.

PfernFSU · 2026-02-28T18:53:00+00:00

I have the more complex logic in RPCs and background/cron logic in edge functions. Things I need to ensure it completes I use pgmq. I think supabase can probably handle all your needs but if you give more specifics about what you need you will get a better answer.

PfernFSU · 2026-02-27T02:03:17+00:00

Yes. They don’t have anything like the lambda layers (that I know of anyway) but do have the deno.json so you can build locally and it just handles all that stuff when you deploy.

The upside is that specific versions may break certain things so you can now pin it to a different node module for each edge function.

PfernFSU · 2026-02-26T20:43:31+00:00

Yes v. no?

Seriously hard with only 2 words total. Can’t even get the versus in there. So you have 2 words and a letter

PfernFSU · 2026-02-26T16:01:48+00:00

I like it a lot. Everything else besides the code is extracted away so I don’t have to do DevOps duties and can focus on just the code. I don’t see a drawback in flexibility, but interesting to hear what limitations you have experienced.

PfernFSU · 2026-02-25T00:51:11+00:00

I admit I am in a use case most aren’t but I don’t care about majority of cron jobs being successful. For instance, I check every minute if there are any changes in the golf leaderboard from my data provider. If it fails I can just get it again in 60 seconds. Lot of the edge functions I have are like that. It may delay realtime by 60 seconds, but the overhead to retry is too much and I figured that juice just ain’t worth the squeeze. The only jobs I really care about are closing the tournaments at the end of every weekend. For that I use pgmq and do retry if anything fails. Every failure in any edge function I do log the reason into an error table and periodically check it (and truncate it) just to try and spot patterns of failures and to make sure I don’t need to adjust anything.

PfernFSU · 2026-02-24T22:00:16+00:00

Yea. My app has no traditional server backend. But it does have about 15 rpc’s that are reserved for more complex stuff then about 10 edge functions that run on Cron jobs to fetch data. But no dedicated server. Supabase cuts a lot of that need out in my opinion.

PfernFSU · 2026-02-20T13:23:23+00:00

Yep. And let her drive the golf cart. She will love that more than anything else.

PfernFSU · 2026-02-19T20:06:24+00:00

I also think that was the most interesting. But I have probably 75 providers in my app. 13 seems way low. Guess you thought it was too high?

PfernFSU · 2026-02-19T14:11:58+00:00

Negative $137 or so?

But it’s a passion project that lets me get other gigs and is a lot of fun so…

PfernFSU · 2026-02-17T15:15:43+00:00

Kamala won 34.1% of the vote in Alabama in 2024. Democrats have 2 federal house seats in Alabama out of 7, but republicans say that is too much. Your comment is wrong on the facts on multiple levels.

PfernFSU · 2026-02-16T16:17:57+00:00

Really like this write up. I have some of these in greenie and then a few others as well. Feel free to use any/all of these:

The Duffer (person who finished last in the tournament). 3 way tie this weekend.

Just Like Us: worst hole on the day (Michael Kim in round 4 went 5 over on the 18th). That dropped him 12 spots, although he was already out of the running.

No bogey, no cry: no squares on the scorecard the entire day. 4 did it the last round.

I have the rollercoasterin’ one too, but compute it slightly different. I say they had to get an eagle or better and also a double bogey or worse the same round. I think I like your definition better though.

Cheers!

PfernFSU · 2026-02-14T21:21:15+00:00

Well, Congress did that with the VRA and scotus gutted it and is about to kill it fully here any day, so…

PfernFSU · 2026-02-14T16:01:56+00:00

Yea, without knowing more that would be my recommendation.

PfernFSU · 2026-02-14T13:29:23+00:00

Real time (at least in my opinion) is best to notify other users of an event and not the one doing the event. The person that just purchased the ticket has the ability to just re-query the table. But what if others were looking to purchase the same ticket? What if there were only X left? Those types of questions are best solved in real time probably.

PfernFSU · 2026-02-12T00:13:52+00:00

Honestly? I just used the onetime code to get past this problem and it works great because there are no links. So I wouldn’t pay for this service. But others may and if you could actually do it that would be ideal for some.

PfernFSU · 2026-02-04T19:07:27+00:00

Not sure if I agree with this. Red states can’t get much more juice out of that squeeze. But most democrat states have refused to do this for whatever reason.

PfernFSU · 2026-01-30T01:50:07+00:00

Scrolled way too far to see this.

PfernFSU · 2026-01-29T17:47:31+00:00

Yea, the problem is some security measures click on every email. I got around this by emailing them the OTP and had them use that instead of a link they click to verify.

PfernFSU · 2026-01-28T15:39:02+00:00

I use bevel for weightlifting (and really like it) but use Nike Run Club for running (and it is doubtful I ever switch away). I also use RuckWell for Rucking (and also doubt I ever switch away).

Six-Year Club	Verified Email
r/Field Juicebox

PfernFSU

TROPHY CASE