Canadian Mac Forums at ehMac banner

1 - 13 of 13 Posts

·
Premium Member
Joined
·
3,742 Posts
Discussion Starter · #1 ·
G'day everybody

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

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!
 

·
Premium Member
Joined
·
17,781 Posts
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!
 

·
Premium Member
Joined
·
15,691 Posts
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/39189/delicious-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
======
 

·
Premium Member
Joined
·
3,742 Posts
Discussion Starter · #4 ·
Thanks Patrick!

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
 

·
Premium Member
Joined
·
15,691 Posts
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
======
 

·
Premium Member
Joined
·
3,742 Posts
Discussion Starter · #7 ·
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
 

·
Registered
Joined
·
84 Posts
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.)
 

·
Premium Member
Joined
·
3,742 Posts
Discussion Starter · #10 ·
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!
 

·
Registered
Joined
·
84 Posts
Any follow-up thoughts appreciated!
Ninox and TapForms are both good replacements for FileMaker. They are cheaper and simpler than FileMaker, but vastly less customizable.
Ninox is more customizable than TapForms in configuring layouts with related fields, but its documentation is more confusing.

Another SQL-based product that you might want to check out, which might better suit you needs, is:

Navicat ($79)
http://www.navicat.com/products/navicat-for-mysql
 

·
Super Moderator
Joined
·
1,749 Posts
Ninox and TapForms are both good replacements for FileMaker. They are cheaper and simpler than FileMaker, but vastly less customizable.

Ninox is more customizable than TapForms in configuring layouts with related fields, but its documentation is more confusing.



Another SQL-based product that you might want to check out, which might better suit you needs, is:



Navicat ($79)

http://www.navicat.com/products/navicat-for-mysql


I wouldn’t waste the money on Navicat (initially.) sqlite3 is shipped with OS X and there are plenty of great free interfaces,
https://sqlitestudio.pl/index.rvt for example.

Nice thing with sqlite3 is it’s tiny, and plenty fast.


Sent from my iPad using Tapatalk
 

·
Premium Member
Joined
·
3,742 Posts
Discussion Starter · #13 ·
I wouldn’t waste the money on Navicat (initially.) sqlite3 is shipped with OS X and there are plenty of great free interfaces,
https://sqlitestudio.pl/index.rvt for example.

Nice thing with sqlite3 is it’s tiny, and plenty fast.


Sent from my iPad using Tapatalk
Downloaded it: looks straightforward but assumes a knowledge of databases which I don't possess... I'll build on Ninox and then may export to a free solution, once I've read the 'dummies' book ;)
 
1 - 13 of 13 Posts
Top