Supabase — Overview
What Supabase is, the five things it gives you in one service, and why it is the right backend for everything you are about to build.
Every app you build needs somewhere to live — a home for user accounts, data, files, and business logic. For most of the history of web development, setting this up required renting a server, installing a database, writing authentication code, and maintaining everything yourself. A week of work before you wrote a single line of your actual app.
Supabase removes all of that. You sign up, create a project, and in two minutes you have a fully managed, production-grade backend.
The Excel Analogy
Think of the different parts of a professional CA firm's file infrastructure:
| What the firm uses | What Supabase gives you |
|---|---|
| The centralised client database (client names, PAN, GSTIN, contact) | Database — Postgres, the most powerful open-source database in the world |
| The login system (each staff member has a username + password to access the system) | Authentication — user accounts, login, sessions, password reset, all handled |
| The document storage server (scanned contracts, signed letters, PDFs) | File Storage — photos, PDFs, documents, any file type |
| The macros and automation scripts that run nightly (GST reconciliation, auto-filing) | Edge Functions — server-side code that runs securely on Supabase's servers |
| The email notification when a client's ITR is processed | Realtime — live updates pushed to your app the moment data changes |
All five in one service. One account. One dashboard. Free to start.
The Five Things Supabase Gives You
1. Database (Postgres)
Postgres is the database that powers Instagram, Reddit, Apple's App Store, and thousands of serious applications worldwide. It has been in continuous development for over 30 years. It is not a trendy startup product — it is infrastructure that has been proven at global scale.
Supabase gives you a real, fully functional Postgres database with a generous free tier. You can create tables, write queries, set permissions, and store millions of rows — all through a clean dashboard interface or by writing SQL directly.
2. Authentication
Building login systems from scratch is one of the most security-sensitive and time-consuming parts of any app. Get it wrong and your users' accounts are at risk. Supabase Authentication handles this entirely:
- Email + password sign-up and login
- Google, GitHub, and other OAuth providers (sign in with Google)
- Magic links (click a link in your email to log in — no password)
- OTP via phone
- Session management, token refresh, and logout
You never store passwords yourself. Supabase does it securely.
3. File Storage
Every app eventually needs to store files — a user's profile photo, a document they uploaded, a PDF they generated. Supabase Storage gives you a managed file system with:
- Public buckets (for logos and assets) and private buckets (for user documents)
- Access control — only the right user can access their own files
- Signed URLs — temporary, expiring links to private files
- Direct integration with your database and authentication
4. Edge Functions
Some logic must never run in the browser. Verifying a payment. Sending an email. Calling a third-party API with a secret key. Edge Functions are small pieces of server-side code that run securely on Supabase's global infrastructure, close to your users, and with access to your database. You write them in TypeScript. Supabase runs them.
5. Realtime
When a new order comes in, you want your admin dashboard to update immediately — without refreshing the page. When a chat message is sent, you want it to appear in the recipient's app within a second. Supabase Realtime makes this possible: it streams database changes to your app as they happen, using WebSockets under the hood.
Why Supabase Over Other Options
This question comes up. Here is the honest answer.
Why not Firebase? Firebase is built by Google and is excellent. The difference is the database technology underneath. Firebase uses a proprietary NoSQL document store. Supabase uses Postgres, which is SQL-based, open source, and the language used by every major institution — banks, accounting firms, government systems, enterprise software. Learning Postgres means you speak the language of data that the entire industry speaks. Firebase is a great tool, but it teaches you a proprietary dialect.
Why not building it yourself? Because you are building an app, not infrastructure. Your value is in the product you build, not in the authentication code you write. Supabase means you start building your actual app on day one.
Why free? The free tier is genuinely generous — it covers everything you need during training and through your first client projects. Supabase's business is the paid tier for high-traffic production apps. You pay when you grow, not before.
What You Will Build on Top of Supabase
In this module, you will:
- Create a Supabase account and your first project
- Create your first database table using the visual Table Editor
- Write your first SQL queries in the SQL Editor
- Configure authentication for email + password login
By the end, you will have a real, cloud-hosted backend that your React apps can connect to.
You will use Supabase on every project you build in this training. The school management app in Phase 2, the full-stack personal site in Project 2, and all of EduTrack run on Supabase. The time you invest learning this dashboard pays back immediately and on every future project.