Supabase + Neon + Neon branching + full postgresql compatiblity. is it possible?
I really want this tech stack, willing to pay and do it on neon cloud. is this possible? the MAIN feature i need is easily to branch in postgresql, also have neon scale-capabilities and serverless sdk, also would like the postgresql FDW feature to work.
want to base my entire backend on it so can one advise?
Thanks!
6 Replies
dependent-tan•7mo ago
Hi @yairtheyair,
Can you explain more about what setup are you thinking?
fascinating-indigoOP•7mo ago
I want a neon database.
I want it to be distributed + I can use serverless sdk.
I want it postgresql compatible especially the FDW feature.
When I have that I want to connect a supabase instance to that database.
That's it
also i want to know the max threshold of scale, for example neon will work up to 100 million rows in db.
just an example i want to know the max scale amount
dependent-tan•7mo ago
@yairtheyair can you explain the flow of data in Supabase and Neon? How are you imagining that?
Once everything is set up in Neon you want to replicate to Supabase? or you have your Supabase and you want to set up Neon to sync the data from Supabase and then create a branch in Neon?
fascinating-indigoOP•7mo ago
Supabase is just some docker containers which connect to a postgresql
If neon is truly 100% postgres compatible it should work
I want a neon db as main, supabase will probably be self hosted
The branches is feature i want to give to my customers
dependent-tan•7mo ago
Yes, Neon is just Postgres + some powerful stuff on top sprinkled for you (like branching).
postgres_fdw does work with Neon.
We have a collection of examples that will help you get started with our SDK in your relevant tech stack.
I see that you're thinking of spinning up Neon for your customers, do take a look at our partners guide.
Does the above information address all your queries?
fascinating-indigoOP•7mo ago
Yes thanks
Yes thanks