25
Mac Mixing Database
submitted over 9 years ago by HowieDIY

I've been mixing DIY for about 8 months now, but I've found that I do not like to use ECR or AllTheFlavors. First, they're not extremely user friendly. And secondly, I want my recipes to be completely private until I'm satisfied with the flavor. SO, I decided to build a database of my own.

I have a basic database built utilizing Filemaker on Mac, but I'm wondering if I can get some assistance and comments/recommendations to further this database for the community. I intend to release to anyone who would like to use it.

Right now, it is based on volume measurements only, but as my scale and pipettes are on the way, I will work to convert it to weight for easier mixing.

If you are interested in trying it out and giving some ideas, please feel free to PM me. If I've posted this to the wrong place, please don't kill me /u/abdada...

image link

Comments
Sort
4 points
 
by jordan917over 9 years ago

I'd love a Mac compatible calculator and database. I use ELR but having something local would be so much better for keeping my flavor notes, recipes and such. Also a flavor base calculator addition would be great, basically a Mac clone of the Recipe Calculator on the sidebar.

3 points
 
by HowieDIYover 9 years ago

I'd like to go above just recipes and a calculator. I use it more as a journal/notebook for keeping all mixing notes, multiple variations on each recipe, dates or mixes, etc...

1 points
 
by cooperCollinsover 9 years ago

I've been looking for a Mac-based "recipe book" for ages. I am also with you on keeping it local. I would really like to test out your application, once you get weights sorted out.

Will this come with or synchronize with an ingredient database? ELR is great for this, would love to have this available locally.

Feel free to PM me for beta after adding weights! Looking good

3 points
 
by queuetueover 9 years agoAllTheFlavors Creator/Admin

What's not private about ATF? :)

2 points
 
by HowieDIYover 9 years ago

:). Let's just say the only place I can assure my data is safe is on my encrypted drives. Besides, putting single flavor tasting notes on someone else's site seems foolish, and time consuming.

4 points
 
by namelesstedover 9 years ago

Are you actually worried about somebody hacking ATF and stealing your recipes? You also mention "user friendly" in your original post, having to maintain a privately encrypted database on a local hard drive sounds like the completely opposite of user friendly.

1 points
 
by HowieDIYover 9 years ago

I'm trying to keep out of the technical side, and keep more to the DIY side of this. But basically, full disk encryption is easy. No work at all. Second: A local computer program doesn't require any form of internet access. I can take it anywhere, (I'm active duty military, so mobility is key)

1 points
 
by vaparagnoover 9 years ago

Never trust storing data on a server you don't own. They can just unplug it one day and then you are SOL unless you stored copies elsewhere

1 points
 
by queuetueover 9 years agoAllTheFlavors Creator/Admin

(Or ELR for that matter)

1 points
 
by goldfish18over 9 years ago

is ATF down right now? I keep getting this on my desktop and mobile device as well. Not the mobile app since I have an iPhone :(

4 points
 
by queuetueover 9 years agoAllTheFlavors Creator/Admin

OK, back up now, I'll be monitoring, but looks like something was really hammering me for a while there.

There's one argument in favor of local apps like the one this post is about! :)

2 points
 
by goldfish18over 9 years ago

Heyyyy it's working now! I was trying to hammer you with all my recipes. Sorry

1 points
 
by queuetueover 9 years agoAllTheFlavors Creator/Admin

Looks like my first denial of service attack. :)

Restarting now.

2 points
 
by ljab26over 9 years ago

Your apache access.log always tells the correct tale. Let the calculator wars begin?

3 points
 
by loldatheover 9 years ago

Tell me how I can have this. I've been using a mac since I started mixing and would like to keep my recipes local and not on the internet.

2 points
 
by abdadaover 9 years agoI will rip you a new one if you don't use the sidebar & search.

I thought Evolv made a vape law that said no macs allowed in vaping!

3 points
 
by HowieDIYover 9 years ago

LOL. But to avoid the Mac/windoze argument, I only build on reliable computers.

1 points
 
by namelesstedover 9 years ago

What?

5 points
 
by CantHearYouBotover 9 years agoIn a good mood for now - don't piss me off.

#LOL. BUT TO AVOID THE MAC/WINDOZE ARGUMENT, I ONLY BUILD ON RELIABLE COMPUTERS.


##^^^I ^^^am ^^^a ^^^bot, ^^^and ^^^I ^^^don't ^^^respond ^^^to ^^^myself.

1 points
 
by HowieDIYover 9 years ago

I hate Microsoft products totally. But everyone has their own preferences.

0 points
 
by ljab26over 9 years ago

I totally agree that reliability is important, but can you agree that you don't have the slightest clue as to what you're saying?

1 points
 
by Inutopianover 9 years ago

Nah what he said seemed pretty spot on to me.

2 points
 
by jusfuccin10over 9 years ago

This looks great - way better than what I've been using. The only addition would be to add something to also calculate weight - but looks like you're already on that path.

1 points
 
by ID10-Tover 9 years ago

Interesting.

Your screenshot has nicotine 0 mg. What happens when you change that to 3 mg? What I'm asking is, does it perform that calculation for you or do you have to do it yourself? And can you use it for a variety of nicotine bases, from 48mg/mL in 50/50 VG/PG or whatever people use to to 100mg/mL in 100% VG or PG?

2 points
 
by HowieDIYover 9 years ago

At this point, it is just for my reference when mixing. It doesn't perform any actual calculation (yet). I mix with 100mg/ml nic, so I know that 30ml calls for .9ml of nic for 3mg. It will be more functional when I switch to weight mixing, and if someone else used a different nic concentration.

1 points
 
by swagmau5over 9 years ago

How about a way to keep track of orders? That would be extremely helpful. This way I can use the same program for everything that I need instead of ELR for this and google docs for something else

1 points
 
by HowieDIYover 9 years ago

That's a great idea! I was working on a wish list function... But putting those two together would be awesome.

1 points
 
by swagmau5over 9 years ago

additionally, is there a max vg option similar to that of ELR?

2 points
 
by HowieDIYover 9 years ago

I can select the pg/vg ratio I want by drop downs and it'll spit out the volume or each. It'd take some research and work, but there's also the idea to add the pg/vg ratio of flavors too.. It'd make for a more accurate ratio. Right now, I unilaterally assume my flavors are 100% pg.

Edit: as I retread this, I realized this would be more helpful in nic bases.

1 points
 
by FriendlyDaeguover 9 years ago

>…I will work to convert it to weight for easier mixing.

I made FMP solution for this a few years ago. But ended up not needing it as I settled on a couple recipes over a year ago. Let me know if you want to collaborate on yours and I’ll dig mine out and dust it off.

1 points
 
by jersey_emtover 9 years ago

I use a Numbers spreadsheet as a recipe calculator and database; it works for both mixing by weight and mixing by volume. It automatically calculates the volume and weight of each ingredient, and still works if you add or delete rows to add or remove ingredients. Right now, it's only set for my own use (mixing at max VG at 3 mg/mL using 60 mg/mL PG-base nicotine), but I'm working on getting full functionality allowing user-selectable mix preferences added so it will work for everyone.

Site copyright © 2025 DIY Compendium. Data courtesy of Reddit.