This is a basic web-interface to a simple sqlite3 database to provide searchable index for magazine recipes.
Over many years, our subscription has generated a heap of magazines that contain recipes -- only some of which we use. The Post-It-Note-As-Bookmark system only works so well, and we often find ourselves yearning for a card catalog when there are nearly 100 magazines to search for a simple recipe. That's what this attempts to solve.
Sort the magazines in chronological order on the shelf. Enter desired recipes into this database. Search the database when you want a recipe, and it will tell you exactly which magazine to pull off the shelf.
For fun, this project has a few features that make it a bit more usable.
- Recipes are listed in a sort-capable table.
- You can search for recipes by name or tag (use the search box)
- Many recipe fields can be edited easily right in the display table
- Adding a recipe has a pretty blur-the-background overlay UI.
- The nerdy author used this as an excuse to learn a bit about Promises and WebComponents.
You'll need a web server with PHP and sqlite3 capabilities (which should be default in modern PHP installs).
Clone this repo where you want to use it, then copy recipes_blank.sqlite3 to recipes.sqlite3. Then access index.php in a web browser (via your PHP/apache/nginx/whatever server) and start adding things.
Adding a recipe:
Editing a recipe:
