This past weekend I had the privilege of attending Ortus Solution's Coldbox 101 training class in Grapevine, Texas. It is true that I did pay for the opportunity, but the price was obscured and more than justified by the quantity, quality, and cohesiveness of the knowledge that was shared. Coldbox's master architect himself, Luis Majano, was the instructor, and it was with the same level of zeal and attention to detail that he puts into his framework that he also enlightened and empowered his students on Coldbox. In this case, the "no student left behind" policy was absolutely successful. With a student body composed of everyone from absolute CF beginner to CF expert, and from designer to "design-blind", Luis ensured that the content was both palatable and applicable to one and all.

I came to the class being what I would best describe as semi-proficient in Coldbox. I've written a large Coldbox app, done a few Coldbox presentations, blogged about some aspects of Coldbox, and was even hired recently to present a full day instructional course on Coldbox to a local group of San Antonio developers. But, as with any subject that one teaches themselves, there are always gaps in the knowledge you glean from reading docs and your own experiences. It was these gaps I came to the training hoping to fill, and fill them I did. I was given solid insight into how the framework itself is architected, allowing me to fully visualize the request lifecycle and the framework components that interact with and manipulate it; I honed my knowledge of ALL of Coldbox's core concepts, such as interceptors, views,layouts, viewlets, and plugins; I gained insight into the workflow and approaches that Luis himself uses on a daily basis; and my mind was opened up to a whole new facet of the development lifecycle that I personally have always avoided: unit testing.

Coldbox is SO keen on the idea of unit/integration testing that it has the built in ability to simulate itself! In a nutshell, Coldbox makes it VERY simple and easy to test entire events (the equivalent of fuseactions, if that's a more relevant term for you) without the need for the developer to write any additional code. It was truly beautiful to see integration and unit tests run, and just as easy to write them.

I also had an opportunity to flip through the pre-copy of the official Coldbox book, and I must say I had a hard time handing it off to the next student. The Table of Contents was lengthy and robust, and the associated content was clear, concise, and easy to read. Oh, and it is in color! The plethora of code snippets really jump out at you, and  highlighted items are truly highlighted. I would say that the book is definitely one that you will want to have on your desk as a reference. If I understood correctly, we should be seeing it released into the wild in short order. :)

The excitement that new knowledge brings is great to those of us who love it and derive our livelihood from it, and I could easily spend a day sharing all of the very useful information and understandings I received from attending this class. I wasn't asked not to, nor was I asked to sign any NDAs; but for the sake of honoring the information that Luis earns some of his sustenance from, I'll refrain from divulging any more details of the class. I will, however, leave you with this thought...

If you are doing Coldbox development and you have not attended Luis' Coldbox 101 training class, I guarantee you that what you are writing is not all that it could be. It won't be architected as well as it could be, it won't be leveraging all of the shortcuts and features that it could be, and it won't be top of the line. That isn't to say that you aren't capable of writing a good Coldbox app, but without the in-depth understandings that this class offers, your app will very likely not be a great Coldbox app.

It's challenging to get department heads to budget in training sometimes, but my fellow developers, if your shop is or is considering being a Coldbox shop, then it is worth the effort to justify this training to them. I typically ask myself the question, "if it was my  money, would I spend it on this?", and regarding this class the answer is an unequivocable YES! If you would like any additional input to help justify the training, I and I'm sure anybody else who attended this training class would be more than happy to provide our own personal feedback and testimonial.

If you are serious about writing solid, load-bearing apps in Coldbox, do this for yourself: attend Coldbox 101 training.

Doug out.

I found myself needing to update a MySQL table today with a calculated date, so thought I'd blog the sql in case it saves someone else some time later.

The Scenario

You have a table that contains a date field, but you need to know the date of the Thursday following that date. In this query, the number 5 represents the 5th day of the week (sunday=1, Monday=2, etc.), so if your scenario is looking for a different day of the week, just substitute your day's number everywhere you see the number 5 occurring in mine. The number 12 in the query below is really 7+5, so again, substitute your day's number for 5 in the equation 7+5 and plug in the result where you see 12. If you're looking for Saturday (day 7), you would put a 14 in place of my 12.

The Query 

To update an existing field in the table with the calculated date of the following Thursday, I used a modified version of the above query that looks like this:

For the past four years I've had the privilege of caring for and learning about several tarantulas and a scorpion. Today I donated them to a local Montessori school so that other people can benefit from them as much as me and my kiddos have. To help the teachers, I created a short document on the care of these guys and some of the fun facts that we have learned about them. It is no way intended to be comprehensive, but will definitely give you things to research.

 Following is that document. May you and yours also discover the joys and wonder of our fellow Earthlings! :)

Tarantulas and Scorpions

Care and Feeding

Environment

Tarantulas and Scorpions are somewhat shy, despite their appearances, and in order for them to thrive they require the ability to seclude themselves when desired. Therefore, their environment should always include some form of shelter in which they can hide when desired. Also, since life in a small plastic cube can become monotonous, always try and incorporate items to keep their lives ‘interesting’; rocks, wood, and other natural items for them to explore and manipulate.

Never allow direct sunlight to shine into their cages, as the temperature will rise to the point of threatening their lives. Myself, I have always kept them near a window that gets indirect sunlight, but have never used a heat lamp or let the sun hit them directly.

Observation

One can’t help but be intrigued by these creatures, and rightly so; but in order to learn the most from the time spent observing, it is imperative that they not be disturbed when doing so (no forcing them out of their shelters, making them move around, etc.). The goal should be for them to not be aware of your presence when they are being observed.

Tarantulas and scorpions have eyes, but their site is not very good at all. Therefore they connect to the world mostly via the sense of touch. They are extremely sensitive to even the smallest vibrations (sound is a vibration), and that is how they hunt and find their prey. Therefore, it is very important that when observing these animals that their cages (and the table or shelf they sit on) are not touched, bumped, or disturbed. An excellent rule of thumb to drill into everyone’s mind is “FOR YOUR EYES ONLY”.

Observation is also GREATLY benefited by the use of a hand held magnifying glass. Many of the more intriguing features can be better seen when magnified, such as their eyes, their spinnerets, the pads on their feet, and their fangs!

Feeding

What

Tarantulas and Scorpions eat only live food. They’re not very discriminatory and will probably eat “anything that moves”, but for the maintenance of their health it is best to only feed them live crickets purchased from a pet store.

When

Like us, each individual has their own appetite. One of them will eat once every two weeks while others will eat as often and as much as given to them. A good rule of thumb is to ensure that they have fresh, living food in their cage at least twice a week. If feeding day rolls around and the tarantula or scorpion still has food, do not add more.

How Much

As I mentioned, some tarantulas are gluttons and will literally cram their fangs as full as possible, while others will take one cricket and be completely satisfied. I recommend putting no more than two crickets into the cage at a time. For those gluttonous, it will limit their gluttony; for those who are picky eaters, it will improve their odds of finding and catching at least one.

Watering

Tarantulas and scorpions require constant access to fresh water, so do check this daily. Due to the nature of the tarantula’s “mouth”, they require that a sponge be placed in their water dish so that they can suck water out of it as needed. The scorpion’s mouth on the other hand is such that it does not require a sponge but only a shallow dish of water present. It will dip its head into the water to drink when it is thirsty.

Crickets

Crickets are people too (even if they are food)! Since the arachnid may not eat all of the food given it in one sitting, it is important to ensure that the crickets in the cage with the tarantulas, and those extras in their own cage, are provided with the basic necessities so that they can survive until they are eaten. Make sure that they have access to water (in the arachnid’s cage they can use the water dish there, in their own cage put a shallow dish with water and a sponge) and food (I put in a few pieces of dry cat food that they can nibble on).

Fun Facts and Research Items

My family and I have learned a LOT about tarantulas and scorpions, and I wanted to pass along some of the more interesting items for the students to learn and/or research.

Tarantulas are not true spiders!

There are several differences between true, modern spiders and tarantulas...things that make them interesting and unique among arachnids. What are those differences? The way they breathe, the number of eyes they have...what else?

How do tarantulas eat? How do scorpions eat?

We tend to think that tarantulas “suck the blood” from their prey through their fangs; not so! And scorpions...the process is something you have to see to appreciate. The scorpion doesn’t tend to eat all that often, and prefers to do so hidden away, but careful and frequent observation may result in an opportunity to observe the process! Oh, and pay particular attention to the tarantulas right after they catch a cricket. I like to call it “the happy dance”, for they will turn in circles while dipping their spinnerets to the ground, forming a “blanket” on which they will lay the digesting cricket. They will then place more web over the cricket and pick it up again to finish eating it. Very interesting!

Shedding of Skin

Tarantulas shed their skin in order to grow. These particular tarantulas are fairly old, and so will probably only shed once or twice a year, max. When they get ready to shed, however, they do an odd thing that at first glance will cause you to think that they have died! So, if you come in one morning and find the tarantula lying flat on his back with his legs in the air, do not disturb it; it is in the very delicate process of taking off its old skin. Once it is finished, it will lie in that position until its new skin is dry and hard, then very often it will take the time to move its old skin to another part of the cage. You may use tongs or some other instrument to gently and slowly remove the old skin from the cage for closer observation.

The scorpion doesn’t shed its skin, at least at this stage in its life. It has a body that is more elastic and expandable.

Urticating Hairs

One of the tarantulas (the one with the long, red hair) is the type that protects itself with urticating hairs. You should have your students research this to find out more about it. When provoked or frightened, this tarantula will turn itself around and, using its back legs, kick or throw the hairs from its abdomen at its attacker. So, if you see one tarantula that appears to be going bald on its abdomen, it probably just threw some hairs.

Reproduction

Tarantulas and Scorpions are very mysterious in this regard, and even being able to discern a male from a female takes a trained eye. All of the tarantulas in this collection are female, but the only way to truly tell is to examine their shed skin under a magnifying glass. Also, male tarantulas when mature will develop a special set of hooks at the knee of their front legs which they use during mating to pin the female’s fangs with so she can’t bite him.

Other than the very brief time when they mate, tarantulas must be kept separated because otherwise they simply see each other as a potential meal. Scorpions, on the other hand, are very much at ease with one another and can be kept in groups.

Colors

Observe the tarantulas under different kinds of light and at different angles. One will glow a beautiful purple in certain light and angles; the other appears a nice shade of pink and grey. Scorpions, under a black light, glow.