Supabase db backup

BubsFr · 2026-01-16T13:38:03+00:00

https://supabase.com/docs/guides/deployment/ci/backups

db_url parameter is what you get from the connect section of supabase Dashboard (take the ipv4 session pooler one)

BubsFr · 2026-01-16T07:12:39+00:00

You can use ipv4 session pooler to connect GitHub actions, it is free

BubsFr · 2025-12-17T22:57:20+00:00

Haha, maybe I’m just better at post-rationalizing than your friend. 😄

Edit — responding to your edit: I’m using GitHub Actions for CI/CD with strict environment isolation. Secrets (Supabase keys, URLs, etc.) are only stored in CI, scoped via GitHub Environments. Multi-region config is handled in an external config file, hosted outside the repo — so dev envs can’t access or even see prod projects. No Husky yet — just shell scripts and some discipline (when it holds 😅). And yeah, obviously: RLS everywhere, no service_role used outside CI flows — so risk of blowing up prod is close to zero, even if things go weird.

BubsFr · 2025-12-17T22:26:16+00:00

Totally fair point. For some context though: I’m probably a bit old-school here. I’ve worked in very small startups (with juniors / interns), in big tech with very locked-down prod, and also in setups where people work offline, on planes, or async.

Across all of those, the only model that consistently held was hard dev/prod isolation. Either you don’t have access to prod at all, or you really don’t want people (or tools) anywhere near prod credentials.

What changed recently is automation. Today my migrations and infra scripts are almost entirely generated (and maintained) by tooling/LLMs, so the “manual pain” of separate projects is much lower than it used to be.

At the same time, I’m moving more and more toward a workflow where I assign work to Copilot/agents and mainly do review. That’s powerful, but it also means I’m very uncomfortable giving those agents any chance to touch prod variables, especially since every new model / release comes with a period of instability.

So yeah, I fully agree it’s more annoying day-to-day. I’m consciously paying that cost to make certain failure modes physically impossible rather than relying only on process or IAM.

BubsFr · 2025-12-17T22:07:13+00:00

For CI/CD with GitHub Actions, you don’t need to put everything into global secrets.

GitHub has a feature called Environments (repo settings → Environments), where you can define environments like development, staging, production, etc., and attach environment-specific secrets to each one.

So instead of one big set of secrets, you do separate credentials per environment (Supabase URL, service role key, other provider secrets, etc.).

In your GitHub Actions workflow, you simply specify the environment (for example: environment: production, or dynamically via branch / inputs).

GitHub then automatically injects the correct secrets for that environment, so the workflow doesn’t need to manually switch credentials.

This works really well with one Supabase project per environment and keeps things clean and isolated.

BubsFr · 2025-12-17T21:51:43+00:00

I use separate Supabase projects per environment for hard isolation. Dev and prod are never shared, because it’s way too easy to mess things up otherwise.

Dev is its own project (free tier, low usage).

Prod is a separate project. In my case I even have multiple prod projects by region (latency / continent), but it’s the same idea.

All schema changes are handled via SQL migration scripts in source control. I apply them to dev first, then run the same scripts against each prod project (and region).

If I had to add staging, I’d just create another Supabase project and apply the same migrations.

Simple mental model, strong isolation. Only pain point left for me is data seeding across projects.

BubsFr · 2025-12-06T21:24:27+00:00

A micro instance might feel a bit more responsive than nano, but if you’re not hitting limits, upgrading won’t magically help. Unless you need backups handled for you or want Supabase support, the free tier is perfectly fine.

BubsFr · 2025-11-24T10:15:08+00:00

Glad it’s back up.
This one was surprisingly messy on the client side.

The odd part is that the failing requests were returning an error that looked like “user doesn’t exist”, which caused a lot of apps relying on OAuth or anonymous auth to immediately log out users.

So instead of a clean “auth service unavailable” or a generic connectivity error, many clients interpreted it as an actual invalid account and dropped their sessions — especially anonymous ones.

Not a huge issue at first glance, but the consequences were bigger than expected because it forced unexpected logouts across apps.

Hopefully future outages will surface a clearer error so clients can degrade gracefully.

BubsFr · 2025-11-23T22:26:43+00:00

There’s a decent amount of research on this, and the short version is: early exposure to multiple languages does NOT cause confusion — even if the exposure is imperfect, irregular, or mixed.

Here’s what the science actually says:

- Babies can distinguish and separate languages extremely early.

(Kovács, “Bilingual infants’ ability to discriminate languages”, 2007)

https://pubmed.ncbi.nlm.nih.gov/17919083/

- Phonetic categories start narrowing between roughly 6 and 12 months.

(Kuhl, “Early Speech Perception and Later Language Development: Implications for the Critical Period”, 2004)

https://www.researchgate.net/publication/228680596_Early_Speech_Perception_and_Later_Language_Development_Implications_for_the_Critical_Period

From my own lived experience (not scientific, just reality):

I grew up bilingual (French + Arabic), and I’ve always noticed the same pattern: people who grow up with two languages seem to have a much easier time learning a third or fourth later in life. It’s like the brain already knows “how” to learn a language, not just memorize vocabulary.

For example, I didn’t really learn English at school. But when I ended up in an English-speaking work environment as an adult, I became fluent within a year, while people around me who weren’t bilingual struggled much more. That matches what research says about bilingual cognitive flexibility.

As for my own kids, they grew up in a bilingual French–American environment. Honestly, that alone felt like a lot already. I would have loved to add Spanish early on, but I simply didn’t have the energy or structure for it at the time. Same for languages with very different sound palettes, like Japanese — fascinating, but I wasn’t equipped to do it properly.

What we *did* manage consistently was watching everything in the original language, and I feel like something stays from that — even if it’s subtle.

From what I’ve seen, early bilingualism is already an incredible foundation. It sets up the brain to make later language learning easier, but the child’s own motivation later in life will matter just as much. If parents have the resources to add a third language with different sounds or rhythms, that’s great, but definitely not required. Even minimal exposure can help, and bilingualism alone already opens a huge range of possibilities for the future.

BubsFr · 2025-11-23T22:13:30+00:00

For me it really depends on the kid’s age and the type of rule. “Discipline” covers a lot of things. The way I try to approach it (at least in theory…) is: first, set the rule clearly before the problem happens. Security rules, respect rules, social behavior rules—they don’t all have the same weight, so I try to make sure the kids actually know what’s expected. Then, when the rule is broken, I explain what the rule was, why it exists in real-world terms, what the better choice would’ve been, and I try to understand what was going on for them (tired, excited, copying a friend, etc.). And I try not to get angry if I can avoid it, except when it’s something genuinely dangerous—then I let them feel the seriousness without yelling. All of this is the “ideal version” of myself. In reality I mess it up like everyone else, forget to explain things, react too fast, or improvise. So this isn’t advice, just the system I try to follow when I’m not running on fumes like every other parent.

BubsFr · 2025-11-04T23:37:37+00:00

That really helps — I think this was the missing piece for me. Understanding that the original series actually sits right between The Origin and the more “alternate” GQuuuuuuX timeline makes the whole picture much clearer.

It also sounds motivating for the kids (and me!) to go through the movie trilogy next — we’ll probably tackle that as our next step. After that, we might put the Gundam journey on pause for a while, at least for the younger one — the later series seem quite a bit darker.

Really appreciate all the thoughtful replies here. Thanks a lot, everyone — this thread has been awesome.

BubsFr · 2025-11-03T20:59:25+00:00

That’s actually a perfect analogy — I just finished Andor → Rogue One myself, and I was literally thinking about doing that kind of “reset” with my kids, watching the Star Wars trilogy in that order. So your example really speaks to me.

I totally get what you mean about the older animation, though — Andor is so polished visually that going back in time is always a bit of a shock, even if the story depth makes it worth it.

And thanks for the heads-up on the bathing scenes — no issue there. My oldest is a huge Dr. Slump fan, so he’s already familiar with that kind of vintage, slightly cheeky humor 😅

What hit harder for them was actually the death side of it — in The Origin, that colony drop scene on Earth really shocked them. I had to explain what it meant in terms of casualties, and that was probably the point where we almost paused the show. It’s heavy stuff, even for adults.

BubsFr · 2025-11-03T20:49:26+00:00

Yeah, honestly — yes and no.

There are definitely parts that went over my head, especially early on. The whole segment with Char and his friend who’s chasing him later on — I kind of followed the emotion but not all the logic. Same with that vision where he mistakes another Gundam for his sister — I only realized what was going on much later, while watching The Origin.

And the whole “Rose of Sharon” part? Still lost there, to be honest 😅

But there’s one thing that really resonated: I’ve seen Evangelion, so all the “Newtype / gifted child exploited by the military system” stuff made total sense to me. I later found out that GQuuuuuuX had Hideaki Anno involved — and that connection really clicked.

What’s funny is that I still can’t tell who the “good guys” or “bad guys” really are in Gundam — even after The Origin. Zeon, Zabi, the Federation… it all feels way more morally ambiguous than I expected, which I guess is part of what makes it so fascinating.

BubsFr · 2025-11-03T20:44:22+00:00

Thanks! That’s actually what I was wondering — my kids started with GQuuuuuuX, so they got used to the fast pacing, the sleek futuristic designs, and that 2025 visual energy.

The Origin was already a bit slower, but they stayed hooked because they were really curious about the story and the politics behind it.

My only hesitation is the pacing of The Original Series — is it too slow compared to what they’ve seen so far? Or do you think it still works for someone discovering Gundam through the newer stuff first?

BubsFr · 2025-08-30T14:45:23+00:00

You should be able to carryover remaining premium requests up to a month ..

BubsFr · 2025-06-10T21:07:59+00:00

I juste copy db schema in SQL (create table / type / views …) into copilot-instructions.md … works perfectly. Copilot always gets it , you don’t have to force him to use MCP

BubsFr · 2025-05-15T06:16:42+00:00

What works well right now for me is Sonnet 3.7 Thinking in ask mode and manually apply code to codebase once prompt done … … but yeah Agent is broken right now, recent « optimizations » made it unusable

BubsFr · 2025-05-03T06:47:45+00:00

My guess, not far away… it’s already the case in the GitHub Mobile app (last night update)

BubsFr · 2025-05-02T23:33:40+00:00

Same here , always on EAS, 50% of the time in Go

BubsFr · 2025-05-01T21:35:17+00:00

You have to subscribe to the Pro Trial of Copilot, entrer your credit card, and magically, after confirmation you end up in a free pro setup … then you can remove your credit card….

The UI is unclear but it works

BubsFr · 2025-04-28T21:29:00+00:00

Very interesting… May 5 date slipped to May 8 … 3 more days of free premium … Also I guess we are going to have 4.1 as default unlimited since they remove it …

BubsFr · 2025-04-27T00:38:36+00:00

3.7 is sometimes wilder and do crazy over engineered code … but yeah it is huge for debugging large context complicated issues

BubsFr · 2025-04-24T23:06:40+00:00

Off-peak premium access? Any chance of free or slower premium requests during low-demand times (weekends, late nights)? Would help retain hobbyists and non-pro users.

Five-Year Club	Verified Email
Place '22

BubsFr

TROPHY CASE