F1 GraphQL

The Ultimate GraphQL API for Formula 1 Data

All F1 history and statistics at your fingertips through GraphQL

Table of Contents

• ✨ Features
• 🎬 Demo
• 🏁 Quick Start
  • Prerequisites
  • Installation
• 🌐 API Endpoints
• 📝 Example Queries
  • Get first ten Drivers
  • Find Race Results for a Specific Grand Prix
• 🛠️ Tech Stack
• 📂 Project Structure
• 🔄 CI/CD Workflows
• 📜 License
• 👨‍💻 Author
• 🏆 Acknowledgements

✨ Features

• 🚀 Dual GraphQL Engines - Choose between Apollo Server and GraphQL Yoga interfaces
• 📊 Complete F1 Database - Access comprehensive Formula 1 historical data
• 🔄 Automated Updates - Database refreshed daily with the latest F1 statistics
• ⚡ High Performance - Built on modern Node.js with TypeScript and Prisma v7 ORM (Direct TCP)
• 🧩 Rich Query Options - Filter, paginate, and explore F1 data with flexible queries

🎬 Demo

Watch F1 GraphQL in action

🏁 Quick Start

Prerequisites

• Node.js (v22.12+ or v24.0+)
• Yarn package manager
• MariaDB/MySQL database
• Lando

Installation

# Clone the repository
git clone git@github.com:FrancoStino/F1-GraphQL.git

# Navigate to the project directory
cd F1-GraphQL

# Configure your environment
cp .env.example .env
# Edit .env with your database connection string

# Start Lando
lando start

# Import from ZIP archive
lando db-import db/f1db-sql-mysql-single-inserts.zip

# Install dependencies
yarn install

# Generate Prisma client (v7 with Direct TCP)
yarn generate

# Start development server
yarn dev

Export database to ZIP file

lando db-export

🌐 API Endpoints

Once running, access your GraphQL API through:

Endpoint	URL	Description
🏠 Landing Page	http://localhost:4000/	Main welcome page with links
🧪 GraphQL Yoga	http://localhost:4000/graphql	GraphiQL interface for testing
🚀 Apollo Server	http://localhost:4000/apollo	Apollo Sandbox environment

📝 Example Queries

Get first ten Drivers

query Drivers {
  findManyDriver(take: 10) {
    id
    firstName
    lastName
    name
    fullName
    gender
    dateOfBirth
  }
}

Find Race Results for a Specific Grand Prix

query Race {
  findManyRace(take: 50) {
    year
    turns
    laps
  }
}

🛠️ Tech Stack

🔄 Updated to Prisma v7 with Direct TCP connectivity for optimal performance

GQLoom

TypeScript

GraphQL

Prisma v7

Apollo

Yoga

Lando

📂 Project Structure

f1-graphql/
├── .github/            # GitHub Actions workflows for CI/CD
├── assets/             # Static assets (images, CSS)
├── prisma/             # Database schema and generated client
├── src/
│   ├── providers/      # Database client provider
│   ├── resolvers/      # GraphQL resolvers configuration
│   ├── schema/         # GraphQL schema generation
│   ├── servers/        # Server configurations
│   │   ├── ApolloServer.ts
│   │   ├── Express.ts
│   │   ├── GraphQL-Yoga.ts
│   │   └── LandingPage.ts
│   ├── utils/          # Utility functions
│   └── index.ts        # Main entry point

🔄 CI/CD Workflows

This project uses GitHub Actions for:

• Daily Data Updates: Automatically refreshes the F1 database
• Release Management: Generates changelogs and tags
• Branch Syncing: Keeps development branches in sync

📜 License

This project is licensed under the MIT License.

👨‍💻 Author

Davide Ladisa

🏆 Acknowledgements

• F1DB - The comprehensive Formula 1 database
• GQLoom - GraphQL tooling that powers our schema

---

🏎️ Ready to race with F1 data? Star this repo and buckle up! 🏁