Audio Library

Backend Development 2025

Audio Library (FastAPI + pCloud)

A backend system that allows uploading, storing, and streaming sermons seamlessly using FastAPI and pCloud API, with PostgreSQL for metadata.

FastAPI pCloud PostgreSQL REST API

Backend Development (FastAPI)

I was responsible for the backend architecture of the Audio Sermon Platform. My main role included building secure and scalable APIs, handling file uploads, and designing the database schema to store sermon metadata efficiently.

After researching file storage solutions, we used PostgreSQL for metadata storage and Cloudinary for audio and thumbnail hosting. I also implemented structured APIs for uploading, retrieving, searching, and streaming sermons.

It was my first time working with FastAPI so I did a project-based learning, just to get the basic Idea of what I wanna build and the basics of FastAPI.

This ensured that the frontend team could easily consume data while maintaining performance and scalability.

Database

PostgreSQL

Cloud Storage

Cloudinary

APIs Built

Upload, Search, List All, Stream

Metadata Schema

Title, Author, Series, Tags, Date, Duration, Audio URL, Thumbnail URL, Top Played

GitHub Repo

🔗 Github Repo

FastAPI Mini projects GitHub Repo

🔗 FastAPI Mini Projects

Backend Development Process

Research & Tools

I researched affordable cloud storage solutions and explored how to integrate them with the app. This included comparing services and finally working with pCloud for audio storage and PostgreSQL for metadata.

Learning FastAPI

This was my first time working with FastAPI. I learned how to create scalable APIs through project-based learning, starting with small practice projects that focused on request handling and routing.

Database Practice

I built a mini project using PostgreSQL to understand relational database design and queries. This helped me structure the sermon metadata model effectively before integrating it into the real app.

pCloud Integration

Since pCloud had closed their app creation system, I contacted their support team for solutions. Meanwhile, I experimented with smaller projects to connect FastAPI with pCloud’s API for file uploads and retrievals.

Final Integration

I combined PostgreSQL and pCloud into the main project, ensuring that sermons could be uploaded, stored, and retrieved smoothly. This was the foundation of the APIs delivered for Mr. Timothy’s project.

Tools & Technologies

These are the core tools and technologies I used while building the backend for the Church Audio Library. Each tool played a critical role in handling uploads, database management, and delivering APIs for the platform.

Backend Framework

FastAPI Uvicorn

Database

PostgreSQL SQLAlchemy

Cloud Storage

pCloud API Cloudinary (images)

Version Control & Deployment

Git GitHub Docker (planned)

Project Impact

The Audio Library project was built to serve the entire church community of COT Global. By making sermons easily accessible, it improves spiritual growth, reduces technical workload for the media team, and ensures no member misses out on the Word.

100%

Church-wide Access

24/7

Availability of Sermons

500+

Members Reached

∞

Replay & Spiritual Growth

← Previous Church Attendance System

All Projects

Next → Google Drive API Project