I educated myself a little bit on external backends. Keep in mind i´m meathead when it comes to coding.
Found supabase and very suprised with functionality and the table editor. Currently testing and experimenting. Wouldnßt have the challenge with product variantes and option sets etc. because i would only display the data temporarly like @NigelG said.
Again working mainly with product, order and customer data from platforms like shopify.
Basic CRUD operations. Using bubble for frontend and supabase for the backend. If i think it trough, the general user experience could be a tiny bit slower in general, but when it comes to scale the db will handle it way better and i don´t need worry about limits and changing backends in the future.
There is one concept i can´t really grasp right now.
Would you guys use the sql connector plugin (direct connection) or the api connector (REST), connecting to the db? (Postgres)
Whats faster? and do i limit myself in functionality when using one?