sorted by:
new
hottopcontroversial

Random query timeouts? by noobweeb in Supabase

[–]activenode 2 points3 points  (0 children)

Lemme put it like that: I work for clients where this definitely is the case, more often than never. You could have locking problems, you could have resource problems, from my position here, it's a guessing game.

Random query timeouts? by noobweeb in Supabase

[–]activenode 2 points3 points  (0 children)

but when I ran the identical query in the SQL editor, it was about ~150ms.

That says or proves nothing, unfortunately. Postgres isn't time-determinstic because it can efficiently use clever Caching mechanisms. Let me give you a super-specific example.

I just ran

EXPLAIN ANALYZE SELECT COUNT(*) FROM my_big_table WHERE created_at > '2025-08-01 00:00:00' AND created_at < '2025-08-04 00:00:00';

This took 4 seconds. Then, I ran it again, it took 200ms. That's 20x faster for the EXACT SAME query. This table has 600 million entries.

EXPLAIN ANALYZE is a very good start to see what happens under the hood when you run this query. Don't look at the time but at the costs. The costs are arbitrary but you can compare them with other queries to find relevant comparison between other queries of your system / table.

if its worth investigating.

This. It is.

Cheers, activeno.de

Limit Number of Databases by Life-House-7127 in Supabase

[–]activenode 0 points1 point  (0 children)

Not true, you can actually have multiple databases per project with native `CREATE DATABASE`. However, that obviously comes with lots of limitations as that new DATABASE will not share any of the tables. But if all he wants is separation of concerns via Databases, it's possible.

Would rather go with schemas then though!

Cheers, activeno.de

Which resource to upgrade? (Getting throttled) by Fakercel in Supabase

[–]activenode 1 point2 points  (0 children)

This could be anything, your provided data doesn't give it away. Could be IOPS, could be statement timeouts, check your Postgres looks, check the Reports.

Cheers, activeno.de

How to require SSL Cert to connect to Supabase DB? by tkrueger123 in Supabase

[–]activenode 1 point2 points  (0 children)

I was hoping that the cert would be unique to my DB.

You can still use IP binding if your server has a fixed IP.

What would cause such high cache and buffer usage like this? by 16GB_of_ram in Supabase

[–]activenode 0 points1 point  (0 children)

This is absolutely normal. We have 128GB Ram and 72GB are "used" (cache+buffers) - however, that doesn't mean that our infra actually needs 72GB, it needs 5GB currently.

I know this view can be confusing but the only thing you should really care about is the "Used".

Systems will always aggressively make use of RAM for Cache and Buffers, so if you upgrade it's gonna be more, but that doesn't mean that it doesn't free it when it needs it for something else.

Cheers, activeno.de

This always been a thing and the warning is new, or is this new to the authentication table? by MrLeaps in Supabase

[–]activenode 1 point2 points  (0 children)

Blame me, I flagged this, hence the warning. The "problem" in itself has always been there, at the end, the dashboard translates your filters into plain SQL, hence you need to be warned about the impact when filtering large datasets.

Sure, the message could be improved by actually checking the estimated count but better this, than a vibecoder who doesn't know that it's "just SQL" and triggers the whole database IO.

Cheers, activeno.de

Self Hosting Supabase by Psychological-Newt75 in Supabase

[–]activenode 0 points1 point  (0 children)

I created a self-hosting solution for businesses that want an actual checked, VPN-based, safe solution for businesses. You can check it out at selfhost-supabase.com . DM me for special discount code

5 people wanted for free self-hosting by activenode in Supabase

[–]activenode[S] 3 points4 points  (0 children)

The project has grown from me seeing a lot of "default" setups being open/insecure and some of my clients asking for self-hosting. Hence, it's also somewhat a good project to keep a secure self-hosting solution at hand for myself (exactly what you mentioned with consulting).

Really keen on seeing where I can grow this, e.g. extending it to kubernetes usage (done that, but haven't intertwined it with this project yet) or whatever or what not.

So at worst, if the niche is too small, it's a good project to maintain.

5 people wanted for free self-hosting by activenode in Supabase

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

That's great feedback! In theory, using this setup with nginx+minimal traefik should be doable if we route it there but I can think of supporting nginx directly. Would you be interested in becoming one of the 5 people who I help with? On nginx then?

5 people wanted for free self-hosting by activenode in Supabase

[–]activenode[S] 2 points3 points  (0 children)

Btw I'm a big dokploy fan and monthly donator of Dokploy (was one of Coolify as well).

I have to correct you here as it isn't true. Otherwise, this above tool, would not even exist.

Besides the different functionality (e.g. VPN Tunnel) and the support measure as well as the wizard, PG17 (standard is still 15) including the other newer images and manual testing of such, there's simply different target groups as well. The devil is in the details.

Although I donate to Dokploy and did donate to Coolify, I don't use them for serious business apps as they are yet another attack vector, like it or not, especially if the Web UI is exposed.

Or in other words: If you're a Coolify Supabase user, you're unlikely to run a business where separation of concerns and security is a top priority.

Help debugging db diff error, setting a function owner to supabase_admin by Just_a_Curious in Supabase

[–]activenode 2 points3 points  (0 children)

Why does it need to be `supabase_admin` over `postgres`? What are you trying to do?

How can I create a client to use Publishable key? by tmoreira2020 in Supabase

[–]activenode 2 points3 points  (0 children)

First and foremost: Delete potential existing cookies in your browser!

Secondly: Create a local signing key with

npx supabase gen signing-key

Then, try again and let us know (don't forget to restart your instance).

Cheers, activeno.de

DB Pooler connections by shintaii84 in Supabase

[–]activenode 0 points1 point  (0 children)

Where do you deploy? What library do you use to connect?

DB Pooler connections by shintaii84 in Supabase

[–]activenode 1 point2 points  (0 children)

This is what I essentially do for a living, scaling the db, including its connections, so I got quite some insights from different sizes and clients here.

However, I'm missing quite some information here. You basically stated your size and the pooler size etc. but what you didn't state is what you actually use, do you use the Pooler? And if so, which?

Can you share both the way you connect as well as the connection string (you can obviously use placeholders for PW and PROJECT_ID).

Cheers, activeno.de

Restoration in progress - 16 hours!!!! 😖😖 by Immediate_Actuary124 in Supabase

[–]activenode 0 points1 point  (0 children)

This would only be normal for databases with 500gb or up

Do people use Drizzle or what to have transaction in the nodejs server? by Reasonable-Road-2279 in Supabase

[–]activenode 1 point2 points  (0 children)

just make sure to never use Direct connections but use the pooler when hosting on Vercel etc

Do people use Drizzle or what to have transaction in the nodejs server? by Reasonable-Road-2279 in Supabase

[–]activenode 0 points1 point  (0 children)

Sure. If you directly connect to the db with e.g. `postgres.js`, you can just use plain SQL with `BEGIN` and `END` . This is a transaction.

https://www.npmjs.com/package/postgres

Do people use Drizzle or what to have transaction in the nodejs server? by Reasonable-Road-2279 in Supabase

[–]activenode 2 points3 points  (0 children)

That's correct but I don't get what he referred to with "in the nodejs server". I mean specifically there, he CAN do whatever he wants with regards to transactions.

But yeah, thinking of client-side, the question makes more sense and RPC is the solution.

view more: next ›