---
title: "My Portfolio in Django integrated with Database"
url: "https://ridwaanhall.com/projects/my-portfolio-in-django-integrated-with-database"
markdown: "https://ridwaanhall.com/projects/my-portfolio-in-django-integrated-with-database.md"
summary: "A personal portfolio in Django, backed by a database and connected to the GitHub API."
---

# My Portfolio in Django integrated with Database

> A personal portfolio in Django, backed by a database and connected to the GitHub API.

- Category: web-development
- Status: Completed
- Started: November 26, 2023
- Built with: Replit, Python, Django, Bootstrap, SQLite, GitHub, HTML5
- Source: https://github.com/ridwaanhall/my-portfolio

## About

### The problem

A portfolio written in static HTML has to be edited by hand for every change, which is why most stop being updated.

### The approach

I built a Django 3.2 portfolio where every section is data: projects, education, skills, career and credentials are stored in SQLite through the Django ORM and edited in the admin.

- Full CRUD for every section through the Django admin.
- A live GitHub contribution heatmap from the GraphQL API.
- Authentication, a contact form, a certificate showcase and JSON export for backups.

### The result

The site was deployed on Replit and showed that a portfolio is easier to keep current when content is data, an idea every later version of this site builds on.

## Features

- **Database-Driven Content**: All portfolio data including projects, education, skills, career history, and credentials are stored in and served from a SQLite database via Django ORM.
- **GitHub API Integration**: Fetches live contribution calendar and activity data from GitHub GraphQL API to display an interactive heatmap on the portfolio.
- **Admin Dashboard**: Full Django admin interface for CRUD operations across all models: Project, Career, Education, Skill, Credential, Certificate, Quote, and more.
- **Authentication &amp; Contact**: User login/logout, superuser management, and a contact form with message storage in the database.
- **Dynamic Templates**: Responsive HTML templates using Bootstrap with modular components for navbar, footer, sidebar, and content sections.
- **Career &amp; Credentials**: Dedicated sections for work experience with responsibilities, employment type, location type, and duration calculation, plus credential/certificate listings.
- **Data Export**: Management command to export all database records to JSON fixture files for backup and migration.

## Tags

Portfolio Website, V1

## Elsewhere

- This page for people: https://ridwaanhall.com/projects/my-portfolio-in-django-integrated-with-database
- Index of every page as Markdown: [llms.txt](https://ridwaanhall.com/llms.txt)
