Building Dynamic Web Apps: A Step-by-Step Guide to Supabase and Django Integration

In today’s fast-paced digital landscape, building and scaling web applications efficiently and cost-effectively is paramount. One emerging solution that’s been gaining significant attention is Supabase — a dynamic platform that combines the robustness of PostgreSQL databases with the ease of use and scalability of a serverless architecture. Whether you’re a seasoned developer or just starting your journey, Supabase offers a compelling entry point into the world of database management, starting with a free tier and scaling to meet the needs of your growing application.

Install dependencies

pip install psycopg2-binary

Create database

Copy credentials

Setup credentials in Django

Go to settings.py and update your credentials.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'HOST': 'db.fckfkkmbqviwtndzupys.supabase.co',
        'NAME': 'postgres',
        'USER': 'postgres',
        'PORT': '5432',
        'PASSWORD': 'zwhLYqECWiHcqcYd',
    }
}

Custom model (optional)

If you want to your setup in models.py your own model.

from django.db import models

# Create your models here.


class Todo(models.Model):
    label = models.CharField(max_length=255)
    description = models.CharField(max_length=255)

    def __str__(self):
        return f"{self.label}"

Run migrations

To create our table with a Django-prepared tables, we need to run migrations.

python manage.py makemigrations [your-app]
python manage.py migrate

You should see this output in the console.

Now in the database we have newly created tables.

Good job! That's it. Now the database is ready.

Thanks for reading my article!

If you enjoyed the read and want to be part of our growing community, hit the follow button, and let’s embark on a knowledge journey together.