Integrating PodPeopleDB Into Your App

API Documentation

Available Endpoints

Get Podcast Host Information

GET /api/podcast/{id}

Returns host information for a specific podcast using the Podcast Index Feed ID.

Get Host Details

GET /api/hosts/{id}

Returns detailed information about hosts associated with a podcast.

Download Database

GET /api/download-database

Downloads the entire SQLite database for offline use.

Database Schema

The SQLite database includes the following tables:

CREATE TABLE hosts (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT,
    role TEXT,
    description TEXT,
    link TEXT,
    img TEXT,
    podcast_id INTEGER,
    podcast_title TEXT,
    status TEXT,
    created_at DATETIME
);

Example Integration

// Example JavaScript code
async function getPodcastHosts(podcastId) {
    const response = await fetch(`https://api.podpeople.db/podcast/${podcastId}`);
    const data = await response.json();
    return data.hosts;
}

Rate Limits

Currently, there are no rate limits in place, but please be considerate with your API usage.

Next: Self-Host PodPeopleDB →