Recipe/food database OR simple front end for Chef - ehMac.ca
Facebook
Twitter
YouTube
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read Advertise


Reply
 
LinkBack Thread Tools Display Modes
Old Jul 10th, 2019, 12:40 PM   #1
Honourable Citizen
 
Moscool's Avatar
 
Join Date: Jun 2003
Location: London (UK)
Posts: 3,722
Recipe/food database OR simple front end for Chef

G'day everybody

Yes, it's now Chef Moscool or @moscoffier if you care for Instagram...

I've just completed my training at Le Cordon Bleu and I have an exponentially high number of recipes, a yearning for creation and plenty of data field requirements such as methods, allergens, flavour categories, etc.

Once upon a time I would have bought Filemaker but let's not start... I realise I asked a similar question 3-4 years ago but things have moved on. I don't particularly want to go for proprietary software as these have a habit of going under regularly. I'm not competent in DB design so would need a front end if it's based on mySQL etc.

I want both a relational DB to incorporate things like pictures and possibly short videos and the ability to generate reports (a.k.a. printed recipes)

Suggestions?

Thanks!
__________________
Bop 'til you drop

MB Pro 13 | i5 | 16 Gigs of shiny DDR RAM | 1TB SSD - we have arrived...
iMac 27 i5 16Gig 1TB
iPad Air 64Gig
Time Capsule 1TB | 4TB connected HD
iPhone 6: "Too big, but bloody fast..." & a bunch of ill fitting ear buds
Canon 7D proper camera with nice L glass and Lightroom 6
Moscool is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old Jul 10th, 2019, 12:57 PM   #2
Honourable Citizen
 
Join Date: Nov 2006
Posts: 17,036
Sadly as near as I can tell as far as Apple is concerned I don't think things have progressed at all in this area.

Will be watching carefully to see if someone has a solid suggestion or two.

Good luck and pleasant journey on your new career path!
__________________
Ad links appearing in my posts were not placed there by me. I do not endorse any products which may be linked to my posts. Do not click on those links.

I retain all rights to photo-images I have posted on ehMac. They were posted that other members of the community could enjoy them. They may not be used or sold in any other way without my written consent.

Bill C-51 is an act of Terrorism! It cannot be fixed and should be immediately repealed!
eMacMan is offline   Reply With Quote
Old Jul 10th, 2019, 01:01 PM   #3
Honourable Citizen
 
pm-r's Avatar
 
Join Date: May 2009
Location: Brentwood Bay BC
Posts: 14,160
Congratulations on completing your Le Cordon Bleu training!!!

I know you said you wanted to avoid "proprietary software" but you could look at some trials or screen shots of some apps amd maybe get an idea as to what you want:
https://www.macupdate.com/find/mac/recipes

Also, Delicious Recipes.app that's included in that list looks interesting and has been going and still supported for a long time:
https://www.macupdate.com/app/mac/39...icious-recipes
Or developers site:
https://juicycocktail.com/software/deliciousrecipes/

Good luck with your search and cooking.

PS: Did they not suggest anything that might be of some help during your training???

- Patrick
======
pm-r is offline   Reply With Quote
 
Old Jul 10th, 2019, 01:29 PM   #4
Honourable Citizen
 
Moscool's Avatar
 
Join Date: Jun 2003
Location: London (UK)
Posts: 3,722
Thanks Patrick!

Quote:
Originally Posted by pm-r View Post
Did they not suggest anything that might be of some help during your training???
I think they use an Australian web site but last time I looked it was down... I'll check again
__________________
Bop 'til you drop

MB Pro 13 | i5 | 16 Gigs of shiny DDR RAM | 1TB SSD - we have arrived...
iMac 27 i5 16Gig 1TB
iPad Air 64Gig
Time Capsule 1TB | 4TB connected HD
iPhone 6: "Too big, but bloody fast..." & a bunch of ill fitting ear buds
Canon 7D proper camera with nice L glass and Lightroom 6
Moscool is offline   Reply With Quote
Old Jul 10th, 2019, 02:09 PM   #5
Honourable Citizen
 
pm-r's Avatar
 
Join Date: May 2009
Location: Brentwood Bay BC
Posts: 14,160
Quote:
I think they use an Australian web site but last time I looked it was down... I'll check again
Boy, that's sure not something you want to happen when your soufflé is settling and collapsing... 😯



- Patrick
======
pm-r is offline   Reply With Quote
Old Jul 10th, 2019, 03:10 PM   #6
Honourable Citizen
 
polywog's Avatar
 
Join Date: Aug 2007
Location: Orleans, On
Posts: 1,488
I've been using paprika 3 for ages. It's fantastic, and has iDevice support/syncing as well.
polywog is offline   Reply With Quote
Old Jul 10th, 2019, 05:24 PM   #7
Honourable Citizen
 
Moscool's Avatar
 
Join Date: Jun 2003
Location: London (UK)
Posts: 3,722
Quote:
Originally Posted by polywog View Post
I've been using paprika 3 for ages. It's fantastic, and has iDevice support/syncing as well.
At least it's supported: last update yesterday! Doesn't look like you can get a trial version though. Anyway, here's a bit of eye candy: tonight's dinner

IMG_7508.jpg

IMG_7510.jpg
__________________
Bop 'til you drop

MB Pro 13 | i5 | 16 Gigs of shiny DDR RAM | 1TB SSD - we have arrived...
iMac 27 i5 16Gig 1TB
iPad Air 64Gig
Time Capsule 1TB | 4TB connected HD
iPhone 6: "Too big, but bloody fast..." & a bunch of ill fitting ear buds
Canon 7D proper camera with nice L glass and Lightroom 6
Moscool is offline   Reply With Quote
Old Jul 20th, 2019, 02:12 PM   #8
Full Citizen
 
Randy B. Singer's Avatar
 
Join Date: Jul 2005
Location: Sacramento, California
Posts: 72
Quote:
Originally Posted by Moscool View Post

I want both a relational DB to incorporate things like pictures and possibly short videos and the ability to generate reports (a.k.a. printed recipes)
I think that I have a really great suggestion...and it's FREE!

Symphytum (free)
http://giowck.github.io/symphytum/

(Personal database software. Design custom input forms. Use text, numbers, images, files and other control fields. Put your data into the cloud for automatic synchronization between all of your computers. Excellent for keeping track of recipes.)
__________________
Randy B. Singer
Co-Author of The Macintosh Bible (4th, 5th & 6th editions)

OS X Routine Maintenance
http://www.macattorney.com/ts.html
Randy B. Singer is offline   Reply With Quote
Old Jul 20th, 2019, 02:15 PM   #9
Full Citizen
 
Randy B. Singer's Avatar
 
Join Date: Jul 2005
Location: Sacramento, California
Posts: 72
If you don't like Symphytum, check out:

Tap Forms . (US$50)
https://www.tapforms.com/
https://apps.apple.com/us/app/tap-fo...112?ls=1&mt=12

It takes over where Bento left off!
__________________
Randy B. Singer
Co-Author of The Macintosh Bible (4th, 5th & 6th editions)

OS X Routine Maintenance
http://www.macattorney.com/ts.html
Randy B. Singer is offline   Reply With Quote
Old Jul 21st, 2019, 05:24 AM   #10
Honourable Citizen
 
Moscool's Avatar
 
Join Date: Jun 2003
Location: London (UK)
Posts: 3,722
Thanks Randy

I've now done a bit more research and the recipe software suggested above is definitely not for me. I have started building a relational DB with multiple tables, the two big ones being recipes and ingredients.

My challenge is 'keywording' to use an Adobe Lightroom metaphor. I need to create sub-categories e.g. vegetable/tuber/potatoes/salad potatoes/charlotte with relevant input fields. I also need all the 'keywords' above to be populated so if I enter 'charlotte', then all the keywords above are also selected. In addition when I describe a recipe, I want to be able to specify potatoes, salad potatoes or charlotte at will.

On the recipe side, it is a bit of the same but with the ability to move 'sideways' So you may have 'meat main courses'/beef/raw beef/steak tartare but as a small portion this is often also offered as a starter. Maybe it's a case of two separate tables, one with multiple choices

Another table would be cooking methods and you could use main method + other methods. The steak tartare with fries above would be 'raw' + 'deep frying'

Ultimately I would want to enter a query such as 'starter containing spinach and involving deep frying' and it would come up with 'courgette flower stuffed with ricotta and spinach'

Ideally, it needs to be future proof i.e. exportable as an SQL database should the supplier stop updating the programme.

So far I've been testing Ninox, which is reasonably straightforward to use but is giving problems with some of the keywording described above.

Any follow-up thoughts appreciated!
__________________
Bop 'til you drop

MB Pro 13 | i5 | 16 Gigs of shiny DDR RAM | 1TB SSD - we have arrived...
iMac 27 i5 16Gig 1TB
iPad Air 64Gig
Time Capsule 1TB | 4TB connected HD
iPhone 6: "Too big, but bloody fast..." & a bunch of ill fitting ear buds
Canon 7D proper camera with nice L glass and Lightroom 6
Moscool is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 04:08 PM.



Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
Copyright © 1999 - 2012, ehMac.ca All rights reserved. ehMac is not affiliated with Apple Inc. Mac, iPod, iTunes, iPhone, Apple TV are trademarks of Apple Inc. Content Relevant URLs by vBSEO 3.6.0 RC 2

Tribe.ca: Urban living in Toronto!