9. Supabase ‐ Knowledge base

1. Frontend perspective

• It works pretty well with Next.js and React Server Components. We can query the database directly from server components without an API layer, which nicely separates logic and responsibility. It probably reminds some developers of the experience of writing web applications with PHP in 2003.
• We can create necessary functions and triggers directly from the Supabase dashboard when needed.
• A solid understanding of SQL is required to achieve what you need and to understand the work of others.
• Supabase has a modular system with plenty of features that can be incrementally added to a project.
• It's always helpful to have backend developers available to consult on database modeling, crafting efficient SQL queries, and solving more complex problems.

2. Backend

• Supabase realtime works quite well for db events (e.g. insert new record/update existing)
• Python client library allows to send broadcast messages that client can listen to.