YugaRecipes

Prerequisites

• Install Python 3+
• Install Node.js 18+
• Install Ollama or obtain OpenAI API Key
• Install Docker

Set up the Database

This application can be run using a single-node PostgreSQL instance or a 3-node YugabyteDB cluster running in Docker.

Set up PostgreSQL with pgvector

docker pull pgvector/pgvector:pg16
docker run --name postgres -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=mysecretpassword -e POSTGRES_DB=postgres -p 5432:5432 -d pgvector/pgvector:pg16

Set up YugabyteDB

Start a 3-node YugabyteDB cluster in Docker (or feel free to use another deployment option):

# NOTE: if the ~/yb_docker_data already exists on your machine, delete and re-create it
mkdir ~/yb_docker_data

docker network create custom-network

docker run -d --name yugabytedb-node1 --net custom-network \
    -p 15433:15433 -p 7001:7000 -p 9001:9000 -p 5433:5433 \
    -v ~/yb_docker_data/node1:/home/yugabyte/yb_data --restart unless-stopped \
    yugabytedb/yugabyte:latest \
    bin/yugabyted start \
    --base_dir=/home/yugabyte/yb_data --background=false

docker run -d --name yugabytedb-node2 --net custom-network \
    -p 15434:15433 -p 7002:7000 -p 9002:9000 -p 5434:5433 \
    -v ~/yb_docker_data/node2:/home/yugabyte/yb_data --restart unless-stopped \
    yugabytedb/yugabyte:latest \
    bin/yugabyted start --join=yugabytedb-node1 \
    --base_dir=/home/yugabyte/yb_data --background=false

docker run -d --name yugabytedb-node3 --net custom-network \
    -p 15435:15433 -p 7003:7000 -p 9003:9000 -p 5435:5433 \
    -v ~/yb_docker_data/node3:/home/yugabyte/yb_data --restart unless-stopped \
    yugabytedb/yugabyte:latest \
    bin/yugabyted start --join=yugabytedb-node1 \
    --base_dir=/home/yugabyte/yb_data --background=false

The database connectivity settings are provided in the .env file and do not need to be changed if you started the cluster with the preceding command.

Load the schema and seed data

This application requires a database table with information about news stories. This schema includes a news_stories table.

PostgreSQL

1. Make database directory.

   docker exec -it postgres mkdir /home/database

2. Copy the schema to the first node's Docker container.

   docker cp database/schema.sql postgres:/home/database

3. Copy the seed data file to the Docker container.

   docker cp database/output_with_embeddings.csv postgres:/home/database

4. Execute the SQL files against the database.

   docker exec -it postgres bin/psql -U postgres -f /home/database/schema.sql
   docker exec -it postgres bin/psql -U postgres -c "\COPY recipes(name,image_url,description,cuisine,course,diet,prep_time,ingredients,instructions,embeddings) from '/home/database/output_with_embeddings.csv' DELIMITER ',' CSV HEADER;"

YugabyteDB

1. Make database directory.

   docker exec -it yugabytedb-node1 mkdir /home/database

2. Copy the schema to the first node's Docker container.

   docker cp database/schema.sql yugabytedb-node1:/home/database/

3. Copy the seed data file to the Docker container.

   docker cp database/output_with_embeddings.csv yugabytedb-node1:/home/database/

4. Execute the SQL files against the database.

   docker exec -it yugabytedb-node1 bin/ysqlsh -h yugabytedb-node1 -f /home/database/schema.sql
   docker exec -it yugabytedb-node1 bin/ysqlsh -h yugabytedb-node1 -c "\COPY recipes(name,image_url,description,cuisine,course,diet,prep_time,ingredients,instructions,embeddings) from '/home/database/output_with_embeddings.csv' DELIMITER ',' CSV HEADER;"

Starting the Application

This application is comprised of a Flask API Server and a React Frontend.

Backend

1. Install backend dependencies.

   python -m venv venv
   source venv/bin/activate
   pip install -r ../requirements.txt
   

2. Start the server.

   python server.py
   

Frontend

1. Install frontend dependencies.

   npm install
   

2. Start frontend.

   npm run dev
   

Sample multipart form CURL request

curl -X POST http://127.0.0.1:5000/api/search -H "Content-Type: multipart/form-data" -F 'data={"query": "tomato"}' -F "image=@/Users/bhoyer/Projects/indian-recipes/backend/static/images/1.Thayir_Curd_Semiya_recipe_Yogurt_Vermicelli_South_indian_Lunch_recipe-4.jpg"