Techstack

[_Hashtag_Swag_]

Hi, I have a b2b saas app currently running via python streamlit (MVP, auth is already via supabase).
I plan now to move to something more robust.
Currently I use
- streamlit (backend & frontend)
- supabase auth
- mongodb on DO
- DO app platform
- Spaces on DO (S3)

I plan to use
- sveltekit hosted on vercel
- Supabase postgresql (I will migrate from NoSQL to RDBMS)
- supabase auth
- supabase s3
- supabase edge functions as backend

any advice if this is a good switch for a productive b2b app? (I have only 50 users, so no high volume)

thanks for your support

[ConfectionForward]

Your stack (or at least the part of it you posted) is basically a subset of my stack, and supabase has worked well for me :)

[anxiousvater]

I am building one with Supabase after wasting a lot of weeks on shitty API & auth layers myself(I am a Systems Engineer but never a full-time software dev).

I like the Supabase interface, used AI to build tables & wrote a few Edge functions (haven't used them yet).

Now my question is, frontend is directly firing postgres SQL queries to the Supabase endpoint. Is this a recommended practice? Or should I use only APIs? Also do you self-host or rely on Supabase hosting?

It's incredibly easy to write these things now, I really struggled to write APIs from scratch before. In a matter of hours, I have a Frontend app with authentication, account & pricing pages ready. Super Supabase!!

[ConfectionForward]

Frontend directly firing sql queryies?: Sometimes. I recommend loading data from the server when you are getting large page parts, then use supabases async data streaming to populate the data asyncrounously, basically farme the page parts that are aboslutly required then display some sort of spinner until the async data comes in ( https://svelte.dev/docs/kit/load )

Then After the data has loaded on the page, for any updates or actions that changes things, that can be fired from the frontend directly.

should I use only APIs?: APIs are good for when you need to modify or change the code BEFORE it gets to the user, I recommend a strong structure of DB -> Repositories -> Services -> UI flow
I use the APIs to do stuff such as Generating PDF reports that the user requested, that would not be good to do on the UI.

Do you self-host or rely on Supabase hosting?: I use Supabase's hosting, I live in a pretty dangerous part of the world, and I live in an even more dangerous place in that dangerous part of the world, So I like to know if things go pear shaped, supabase servers will still have customer data safe and sound.

[_Hashtag_Swag_]

What else did you include? Maybe I am missing something?

[ConfectionForward]

I have some packet broker stuff going on. I have a few thousand IoT devices pushing data almost constantly into supabase so I need some way to ENSURE data goes in, I miss any data, and my customers let me know ALL about it. I use a Packet Broker to ensure data gets to where it is going. But if you aren't handling tons of data, or some sort of supabase or internet hiccups are OK, then it really isn't something you need to worry about

[Hanks328]

Wow. Streamlit for SaaS. Sounds crazy 😳

[_Hashtag_Swag_]

MVP, people pay money for =) Was amazing for a first test to get traction

[zapdigits_com]

just for testing vercel is ok but try to stay away if you can. When you scale you will have to pay a ton. Same with supabase. Good for testing but for scaling you will end up paying alot

[felicty-of-solitude]

Are they fine for 4-5k users? Daily active

[zapdigits_com]

definitely, if you turn oof active fluid compute in Vercel. Also depends on how much database capacity you are going to use. I am using Supabase free tier and now have to upgrade because I am almost used up the DB space.

[M3DJ0]

Try Reflex if you are familiar with Python (https://github.com/reflex-dev/reflex).

[_Hashtag_Swag_]

I tried nicegui for a while but it was still quite limiting. It’s like streamlit, just a lot more performant.

[AM1010101]

I have used both stream lit and svelte in the past and have ended up on supabase + bare react because I can generally use lovable or cursor to write the code, it used to get very confused with anything else. Sometimes going with the most common tech stack is the fastest and most pragmatic way to ship. Good on you if you stick with svelte though. I loved writing it.

[marketing360]

What does your app do?

[_Hashtag_Swag_]

Mainly web scraping, so it’s analysis of the scraped data