Since I'm into tequilas and wanted to learn more about databases, I decided it would be fun to try build a database about tequila and represent it on my website.
Learn MoreIt's safe to say I've tried a few different tequilas over the past few years and I was always wondering how I could really document which ones I've tried, which ones I've liked, and which I would recommend. I've also been wondering lately if I could build a database from scratch, represent it on my website, and build out an interface for me to add to it and show the data. That's exactly what this is. I'm still working on adding in the data and fine tuning things, but I think you get the idea now.
You might be saying to yourself -- it's not that hard to create a table in HTML and add rows, data and some style to it. And you're right, it's not. While that may be what this looks like at face value, I spent a lot of time learning enough SQL and PHP to securely connect into my database, select, order, and represent data all from the comfort of this very page. While not groundbreaking, it was a lot of fun to figure it out and brush up on some rusty skills in the process. But enough about this project, on to the data.
I know this list is pretty long, but just know that this is an experiment in building and representing a database more than anything else. Think of all the work that went into adding in all of the content (and all the sips I suffered through to get to where this list is at today).
| Tequila Name | Tequila Type | Price | Flavor Profile | Buy Again | Stars |
|---|---|---|---|---|---|
| 818 | Reposado | $049.99 | Spice, Pepper, Light, Smooth, Mixing | No | 6 |
| Amor Mio | Anejo | $074.99 | Vanilla, Caramel, Sweet, Extremely Smooth, Light Spice | Yes | 10 |
| Amor y Guerra | Blanco | $069.99 | Sweet, Smooth, Lime, Light | Yes | 8 |
| Amor y Guerra | Reposado | $069.99 | Spice, Cinnamon, Smooth, Clean, Aged | Yes | 7 |
| Avion | Blanco | $034.99 | Citrus | Yes | 8 |
| Avion | Extra Anejo | $119.99 | Vanilla | Yes | 9 |
| Avion | Cristalino | $119.99 | Vanilla, Light Citrus, Extremely Smooth, Light Smoke | Yes | 9 |
| CaliFino | Extra Anejo | $099.99 | Spicy, Pepper, Agave, Lime, Honey, Smoke | Yes | 8 |
| Casa Dragones | Anejo | $119.99 | Very Sweet, Very Smokey, Very Floral | Yes | 7 |
| Casamigos | Blanco | $042.99 | Spice, Citrus, Sweet, Light | Yes | 7 |
| Cava De Oro | Reposado | $049.99 | Sweet, Vanilla, Light, Clean, Smooth | Yes | 7 |
| Cava De Oro | Extra Anejo | $099.99 | Vanilla | Yes | 10 |
| Cava De Oro | Cristalino | $109.99 | Sweet, Vanilla | Yes | 8 |
| Cazadores | Extra Anejo | $038.99 | Light, Alcoholic Burn, Little Sweetness, Floral | Maybe | 7 |
| Cazadores | Cristalino | $039.99 | Sweet, Smokey, Smooth, Light, Limon | Yes | 7 |
| Cazcanes | Reposado | $099.99 | Heavy Spice, Citrus, Light Sweetness, Agave, Floral | Yes | 8 |
| Chamucos | Anejo | $065.00 | Light, clean, super floral | Yes | 7 |
| Chinaco | Anejo | $065.00 | Sweet, light vanilla, smooth, little citrus, caramel | Yes | 8 |
| Cincoro | Anejo | $119.99 | Sweet, Vanilla | Yes | 10 |
| Clase Azul | Reposado | $149.99 | Clean, Light, Vanilla, Spice | Yes | 9 |
| Codigo | Blanco | $049.99 | Lime,Smooth,Light | Yes | 9 |
| Código 1530 | Reposado | $074.99 | Light Pepper, Smoke, Floral Start, Clean | Yes | 9 |
| Corcel | Anejo | $059.99 | Sweet, Vanilla | Maybe | 6 |
| Corralejo | Reposado | $034.99 | Pepper, Spicy, Smokey, Clean, Light, Smooth | Yes | 9 |
| Corralejo | Extra Anejo | $064.99 | Smooth, Honey, Spicy Finish | Yes | 7 |
| Dame Mas Reserva | Extra Anejo | $159.99 | Very Smooth, Light Honey, Oak, 5 Years Aged | Yes | 10 |
| Deleon | Anejo | $049.99 | Harsh, Spice, Light Smoke | No | 5 |
| Dobel | Blend | $034.99 | Citrus | Yes | 9 |
| Dobel | Anejo | $049.99 | Cinnamon, Smokey | Yes | 7 |
| Dobel | Cristalino | $199.99 | Citrus, Sweet, Honey, Smoke, Strong, Smooth | Yes | 10 |
| Don Fulano | Reposado | $050.00 | Light Pepper, Extra Clean, Extremely Light | Yes | 10 |
| Don Julio 1942 | Anejo | $049.99 | Caramel, Vanilla, Smokey, Spice | Yes | 9 |
| Don Julio 1942 | Extra Anejo | $124.99 | Vanilla, Spicey | Yes | 9 |
| Don Julio Primavera | Reposado | $129.99 | Orange, Sweet, Smokey | Maybe | 6 |
| Don Julio Real | Extra Anejo | $369.99 | Light Smoke, Sweet, Very Smooth, Light | No | 8 |
| El Destilador | Anejo | $059.99 | Honey, Pepper, Sweet, Smooth Burn, Light Smoke | Yes | 8 |
| El Tequileño | Blanco | $025.99 | Sweet Front, Citrus, Lime, Very Clean, Little Bite, Light Smoke | Yes | 9 |
| El Tesoro | Anejo | $039.99 | Sweet, Slightly Smokey, Light, Clean, Smooth | Yes | 8 |
| Fortaleza | Blanco | $049.99 | Clean, Citrus, Smooth, Light Smoke | Yes | 9 |
| Fortaleza | Anejo | $139.99 | Light, Clean, Smokey, Agave, Oak, Vanilla, Pepper | Yes | 9 |
| G4 | Anejo | $079.99 | Heavy Citrus, Spicey Finish, Mildly Smokey, Smooth, Light | Yes | 9 |
| Gran Centenario 40 | Blanco | $025.99 | Smooth, Agave, Pepper, Light Citrus, Vanilla, Caramel | Yes | 7 |
| Gran Centenario Leyenda | Extra Anejo | $129.99 | Light smoke, light sweetness, very smooth, honey | Yes | 9 |
| Gran Corralejo | Anejo | $089.99 | Smoke, Caramel, Vanilla, Spicy, Light Burn | Yes | 8 |
| Herradura | Reposado | $054.99 | Reposado | Yes | 7 |
| Herradura | Cristalino | $059.99 | Clean, Citrus, Smoke | Yes | 8 |
| Herradura Legend | Anejo | $129.99 | Very Smokey, Sweet | Yes | 7 |
| Hornitos | Cristalino | $025.99 | Clean, Big Burn, Light Spice | No | 5 |
| JaJa | Blanco | $027.99 | Smooth, Clean, Peppery, Lime | Yes | 8 |
| Jose Cuervo | Reposado | $019.99 | Smokey | No | 1 |
| Jose Cuervo Reserva De La Familia | Blanco | $058.99 | Smooth, Citrus, Light, Clean | Yes | 9 |
| Lalo | Blanco | $049.99 | Citrus, Light Spice, Warm, Clean | No | 6 |
| Lobos 1707 | Extra Anejo | $099.97 | Very Light, Very Spicy, Light Sweetness, Little Burn | No | 6 |
| Loma Azul | Anejo | $059.99 | Smokey, Spice, Smooth, Vanilla, Maple | Yes | 8 |
| Los Rijos | Anejo | $049.99 | Light, Smoke | Maybe | 6 |
| Lote Maestro | Extra Anejo | $099.99 | Smokey, Honey, Maple, Syrup, Sweet, Oak, Smooth | Yes | 9 |
| Mandala | Anejo | $069.99 | Very Smokey, Sweet, Smooth, Honey, Little Spice | Yes | 7 |
| Mandala | Extra Anejo | $229.99 | Smooth, Light, Cinnamon, Apple, Light Oak, Maple, Honey | Yes | 10 |
| Milagro Barrel Select | Anejo | $059.99 | Citrus, Vanilla, Light, Spice | Maybe | 6 |
| Mis Aguacates | Anejo | $059.99 | Sweet,Spicy,Smooth,Light,Cinnamon | Yes | 6 |
| Nosotros | Reposado | $036.99 | Light Smoke, Vanilla, Sweet End, Caramel, Spice | Yes | 7 |
| Senor De Los Cielos | Cristalino | $047.99 | Smooth, Citrus, Sour, Light, Sweet | Yes | 6 |
| Siempre | Anejo | $043.99 | Light Smoke, Smooth, Well Aged, Caramel, Spicy FInish | Yes | 9 |
| Sin Rival | Extra Anejo | $249.99 | Sweet, Honey, Smokey, Smooth, Light Spice, Vanilla, Light | Yes | 10 |
| Tears of Llorona | Extra Anejo | $219.95 | Bold, Smokey, Sweet, Spicy | Yes | 10 |
| Tequila Ocho | Anejo | $064.99 | Smooth, Smokey, Light, Refreshing | Yes | 7 |
| Teremana | Blanco | $029.99 | Citrus | Yes | 8 |
| Teremana | Reposado | $032.99 | Reposado | Yes | 7 |
| Teremana | Anejo | $039.99 | Light, Smooth, Vanilla, Light Spice | Yes | 7 |
| Tierra Sagrada | Extra Anejo | $089.99 | Sweet, Smooth, Honey, Warmth, Vanilla | Yes | 10 |
| Tres Generaciones | Anejo | $049.99 | Light, Smoke | Maybe | 6 |