Online Glaze Recipe Database Project is Now Under Way - Electric Mid&Hi Fired Ceramics2024-03-29T12:45:52Zhttps://cone6pots.ning.com/forum/topics/online-glaze-database-project-put-up-for-bid?commentId=2103784%3AComment%3A49523&feed=yes&xn_auth=noGeorge, the results sheet I u…tag:cone6pots.ning.com,2013-01-20:2103784:Comment:738862013-01-20T19:28:39.915ZJune Perryhttps://cone6pots.ning.com/profile/JunePerry
<p>George, the results sheet I use for assessing tests has some of the following information:</p>
<p>Basic recipe #. Name, type, cone, atmosphere, recipe, color additions and being specific about ingredients, not just say ball clay, or kaolin etc, water used can also be important since mineral content of water from place to place can affect the end result. I always used whatever water was coming from my tap which at times was well water or city water. Late friends Otto and Viveka Heino always…</p>
<p>George, the results sheet I use for assessing tests has some of the following information:</p>
<p>Basic recipe #. Name, type, cone, atmosphere, recipe, color additions and being specific about ingredients, not just say ball clay, or kaolin etc, water used can also be important since mineral content of water from place to place can affect the end result. I always used whatever water was coming from my tap which at times was well water or city water. Late friends Otto and Viveka Heino always used distilled water for their glazes. The old adage that glazes don't travel well can be due to water or what ball clay or kaolin used, clay body choice, or other specific choices made in ingredients like talc, spodumene, firing schedule, weather that day in the case of reduction firings. Even things like what mesh screen was used to mix the glazes can affect the outcome somewhat. Also, the specific gravity of the glaze or a hydrometer reading,what mesh silica was used, kiln placement,etc. as well as information on how long the dip was on the pot, since some glazes exhibit different colors when applied thinly or thickly. All these things affect the outcome. Since most of my years in clay entailed reduction firing, I also have a spot on the sheet to enter a kiln log number and the kiln log had the date, weather conditions of the day, as well as a graph on the firing.</p>
<p>Since there are hundreds of free cone 6 and other temperature glaze recipes available, to make something financially viable and appealing to the prospective paid subscriber of a database site, I would think that all the information supplied along with the picture would have to be extensive enough to give the user the highest chance of success. Just my thoughts on this.</p>
<p>June</p>
<p></p> I think that five to ten a ye…tag:cone6pots.ning.com,2011-12-30:2103784:Comment:512822011-12-30T02:34:54.942ZKabe Burlesonhttps://cone6pots.ning.com/profile/KabeBurleson
<p>I think that five to ten a year would be cheap for the information. I do tile work and am trying to let"s say build my own "crayon box" for mural glazing. To be able to go to a data base "The big crayon box" to get a huge choice in colors, would be great. Thank you for the effort you are putting forth toward this project. Kabe</p>
<p>I think that five to ten a year would be cheap for the information. I do tile work and am trying to let"s say build my own "crayon box" for mural glazing. To be able to go to a data base "The big crayon box" to get a huge choice in colors, would be great. Thank you for the effort you are putting forth toward this project. Kabe</p> We, too, would be happy to pa…tag:cone6pots.ning.com,2011-12-29:2103784:Comment:512742011-12-29T22:54:57.689ZSharon Canfieldhttps://cone6pots.ning.com/profile/SharonCanfield
<p>We, too, would be happy to pay a fee for membership. We did not join this site because it was free. We joined because of what it offered and have not been disappointed. </p>
<p>We, too, would be happy to pay a fee for membership. We did not join this site because it was free. We joined because of what it offered and have not been disappointed. </p> The Glaze Recipe Database Sur…tag:cone6pots.ning.com,2011-12-29:2103784:Comment:512042011-12-29T03:01:12.099ZGeorge Lewterhttps://cone6pots.ning.com/profile/GeorgeLewter
<p>The Glaze Recipe Database Survey has one written response that I want to share with all.</p>
<p>"It would be important to have pertinent details like the firing schedule, and the clay used for testing included, in order to enhance the usefulness of the website."</p>
<p>Insight-Live Recipe database has space for both of these as well as associating multiple pictures and notes on how different people got different results. We will be able to see more of the range that a single glaze is capable…</p>
<p>The Glaze Recipe Database Survey has one written response that I want to share with all.</p>
<p>"It would be important to have pertinent details like the firing schedule, and the clay used for testing included, in order to enhance the usefulness of the website."</p>
<p>Insight-Live Recipe database has space for both of these as well as associating multiple pictures and notes on how different people got different results. We will be able to see more of the range that a single glaze is capable of producing.</p> As a newer member to this for…tag:cone6pots.ning.com,2011-12-11:2103784:Comment:498572011-12-11T22:42:17.470ZAnne Cunninghamhttps://cone6pots.ning.com/profile/AnneCunningham
<p>As a newer member to this forum, I appreciate all the thought George and Zoo have put into the discussion - I would be happy to pay $5-10 per year to support this effort. Not really experienced in programming itself but the victim(?) of double work, it would be sensible to structure the multiphases theoretically from the beginning with code set up so expansion doesn't require reworking the framework. Manually consolidating duplicates can be a pain. But if there isn't the funding then…</p>
<p>As a newer member to this forum, I appreciate all the thought George and Zoo have put into the discussion - I would be happy to pay $5-10 per year to support this effort. Not really experienced in programming itself but the victim(?) of double work, it would be sensible to structure the multiphases theoretically from the beginning with code set up so expansion doesn't require reworking the framework. Manually consolidating duplicates can be a pain. But if there isn't the funding then perhaps there could be a mechanism for resolving duplicates, and including all names in the title so someone who remembers one of the names used can refind it. I prefer normalized recipes but if people also have another format (e.g., teaspoons) maybe there can be a comment section for that). This is a wonderful project!</p> I didn't come to this site be…tag:cone6pots.ning.com,2011-12-11:2103784:Comment:498462011-12-11T14:21:58.477Zcp dunbarhttps://cone6pots.ning.com/profile/cpdunbar
<p>I didn't come to this site because it has been free. Would be more than happy to donate and pay ongoing costs. Far as i can tell, giving some money to make something i already like better is no loss. </p>
<p>Reminder, sites either grow or die. So sign me up and tell me what to do. </p>
<p>cp</p>
<p>I didn't come to this site because it has been free. Would be more than happy to donate and pay ongoing costs. Far as i can tell, giving some money to make something i already like better is no loss. </p>
<p>Reminder, sites either grow or die. So sign me up and tell me what to do. </p>
<p>cp</p> I appreciate your thoughts, Z…tag:cone6pots.ning.com,2011-12-11:2103784:Comment:495432011-12-11T04:41:49.300ZGeorge Lewterhttps://cone6pots.ning.com/profile/GeorgeLewter
<p>I appreciate your thoughts, Zoo, and am prepared to go as basic or as sophisticated as member interest and willingness to invest in the project will allow. I was actually thinking of a multi-phased project that would start very basic and be upgraded as usage, demand, and finances allow. </p>
<p>I'm thinking for Phase 1 the glaze entry form will be the only recipe entry mechanism for our members. In the actual ingredient entry portion of the form the material field for each ingredient would…</p>
<p>I appreciate your thoughts, Zoo, and am prepared to go as basic or as sophisticated as member interest and willingness to invest in the project will allow. I was actually thinking of a multi-phased project that would start very basic and be upgraded as usage, demand, and finances allow. </p>
<p>I'm thinking for Phase 1 the glaze entry form will be the only recipe entry mechanism for our members. In the actual ingredient entry portion of the form the material field for each ingredient would have an auto-fill-in dropdown list of about 120 of the most commonly used raw materials. The user will select one rather than typing in their offbeat personal abbreviation. If a material is not on the list, then they could type in a material. </p>
<p>I would think that a database of up to 10,000 recipes would fall in the realm of being quite small as databases go. If each new recipe being entered is assigned a primary key glazeID, then it shouldn't be too critical that the database recognize that the recipe might pre-exist under a different name. Nor should it matter if a number of different recipes have the same name, as long as a search query will select all of them for a user to compare.</p>
<p>Attached is an excel list of materials I was thinking of using to populate the drop-downs and a PDF form I was working on to explore how the form might be structured.</p> Thinking about this some more…tag:cone6pots.ning.com,2011-12-11:2103784:Comment:497032011-12-11T01:45:20.015ZZoophagoushttps://cone6pots.ning.com/profile/Zoophagous
<p>Thinking about this some more and have some more input.</p>
<p></p>
<p>Another thing to think about is the hosting. Most of the freelance developers I know will unless instructed otherwise host the web app themselves (usually through their hosting service and they receive a commission). This is a totally legit way for the developer to make more money from the project.</p>
<p></p>
<p>If we plan on keeping this up we should think about where it is hosted. There are a lot of options. And…</p>
<p>Thinking about this some more and have some more input.</p>
<p></p>
<p>Another thing to think about is the hosting. Most of the freelance developers I know will unless instructed otherwise host the web app themselves (usually through their hosting service and they receive a commission). This is a totally legit way for the developer to make more money from the project.</p>
<p></p>
<p>If we plan on keeping this up we should think about where it is hosted. There are a lot of options. And whoever bids on the project may have a host in mind. But we should have a hosting plan before we put our money on the table.</p>
<p></p>
<p>Lastly, thanks George! Great idea!</p> I have some feedback on this.…tag:cone6pots.ning.com,2011-12-11:2103784:Comment:495232011-12-11T01:00:43.285ZZoophagoushttps://cone6pots.ning.com/profile/Zoophagous
<p>I have some feedback on this.</p>
<p></p>
<p>I have built an online glaze db and found some of the quirks. </p>
<p></p>
<p>When discussing this with the developer I recommend you're very clear about how to handle two types of duplicates, duplicate names and duplicate recipes. </p>
<p></p>
<p>Any glaze db will have many different glazes named "Clear" or "White" or "Crackle". Be sure to make the developer aware of this. Someone not familiar with glazes *may* assume names are unique. They are…</p>
<p>I have some feedback on this.</p>
<p></p>
<p>I have built an online glaze db and found some of the quirks. </p>
<p></p>
<p>When discussing this with the developer I recommend you're very clear about how to handle two types of duplicates, duplicate names and duplicate recipes. </p>
<p></p>
<p>Any glaze db will have many different glazes named "Clear" or "White" or "Crackle". Be sure to make the developer aware of this. Someone not familiar with glazes *may* assume names are unique. They are not. If the code assumes unique names the db will only allow one clear, one white, etc. </p>
<p></p>
<p>Additionally a single recipe may have more than one name. There is an iron red I use that I have seen called 3 distinct names. A good db design will display one recipe but three different names. </p>
<p></p>
<p>In addition to handling duplicates the db will need to be able to handle ingredients. How many different ways are there to spell Neph Syn? Ny db had about 2,000 recipes and I saw about 20 different ways to spell Neph Syn. Same with EPK. Or should I say E. P. K., or Edgars Plastic Kaolin. You get my point. If no mapping is done for ingredients the ingredient table will contain many hundreds of ingredients. </p>
<p></p>
<p>How will recipes be added to the db? Manually? Will a batch upload function be built in? Lots of folks have glaze software that allows exporting of recipes. It would be nice if the db accepted those files. </p>
<p></p>
<p>One last design consideration - should the db normalize the recipe? We're all used to normalized recipes and I know I prefer working with them. But should that be enforced in the code? If so - how?</p>
<p></p>
<p>As a software guy I can tell you the clearer we are with the requirements the better the final product will be. </p> Count me in for paying a fee…tag:cone6pots.ning.com,2011-12-10:2103784:Comment:496982011-12-10T22:39:31.263ZSharon Ivyhttps://cone6pots.ning.com/profile/SharonIvy
<p>Count me in for paying a fee for such a service!</p>
<p>Count me in for paying a fee for such a service!</p>