NBA 2016 Finals Game 7 Analysis

An AI-powered app to generate comments and statistics about the NBA 2016 Finals Game 7 using Drizzle ORM and SingleStore.

Architecture

Features

• Generate insightful comments on the game using an AI agent
• Provide detailed statistics and analysis based on the video clip
• Utilize Drizzle ORM for database interactions
• Powered by SingleStore for efficient data handling

Installation

1. Clone the repository:

   git clone [email protected]:singlestore-labs/nba-AI-drizzle-app-demo.git

2. Navigate to the project directory:

   cd nba-AI-drizzle-app-demo

3. Install NodeJS

   sudo apt install nodejs

4. Install dependencies:

   pnpm install

   1. Install pnpm

      If you get pnpm not found when running the previous command, install pnpm using npm

      sudo npm i -g pnpm

Setup

1. Copy the default.env file and name it .env:

   cp default.env .env

2. Get the DATABASE_URL from SingleStore Portal and add it to your .env file:

   DATABASE__URL=your_singlestore_db_url

3. Create the commentary_table in the SingleStore database using Drizzle

   pnpm migrate

4. Get the Gemini API key from Google Gemini API Documentation and add it to your .env file:

   GEMINI_API_KEY=your_gemini_api_key

Usage

1. Start the application:

   pnpm dev

2. Open your browser and navigate to http://localhost:3001