Skip to content

nomclawson/SQL-Databases

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Overview

This program, recipe_request.py, is a recipe app. This program allows the user to search recipes using the Edamam Recipe Search API. The user is then able to save recipes via their URI (recipe ID) in a .db file. Once saved, the user can then retrieve recipes from their saved recipes or using the search feature.

This program has served me in 3 ways. First, it was a great introduction to the Request module in Python. Second, I was able to learn how to interact with relational databases using SQL commands. And lastly, but most importantly, I am now able to search and save recipes without treading the ad-invested recipe-blogisphere.

This project pushed me out of my comfort zone but with some time, research, and lots of practice I am very proud of what I have accomplished so far.

Recipe Database Demo - YouTube

Relational Database

The database queries were done using the SQLite3 package for Python.

This program currently uses 1 table with columns for:

  • ID
  • URI (recipe ID from Edamam)
  • Label (recipe name)

Development Environment

This program was developed in Python3 with Visual Studio Code and uses the following libraries:

  • SQLite3
  • Random
  • Requests
  • UrlLib

And the following API:

Useful Websites

{Make a list of websites that you found helpful in this project}

Future Work

Future additions include:

  • Making GUI (Web App?/TKinter?) especially for my wife
  • Edit/remove saved recipes
  • Recipe rating
  • Add cooking directions in place of link to website

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages