-
Greatest…Book…Ever!
Nope. I’m not talking about Twilight: New Moon. (My vampire obsession goes a long way back, and doesn’t involve a single, boring, pasty-faced Cullen :) Beck got me an original printing of Snoopy: A New Peanuts Book, which was published in 1958! The Owsley County Public Library was cleaning out old books and Beck, knowing that I love all things Charlie Brown picked it up for me. Too bad for them!
Reading the hundred or so simple 4 pane strips, I’m reminded why I love Charles Shulz: He combines frustration with humor in a way that makes life’s problems seem not so bad. For example, how often have we all wanted to be somebody else? Snoopy imitates numerous people and animals in many of the strips, and he always figures out that the grass isn’t actually greener on the other side. What better way to be reminded of the truth of this idiom than in the form of a lovable white beagle!
-
Diagrams, diagrams, diagrams
I’ve been sitting here for the last couple hours contemplating a program design in my head. (Actually, I’ve been contemplating this design for a month or so, but I really was putting some brain power into it for the last couple hours. Anyway…back to my point…) I have decided to start putting the ideas into some codified form in an effort to start documenting my code and designs better. In trying to figure out which diagrams to draw, I realized that it has been so long since I have done a formal diagram to formal standards that I have actually forgotten a lot of the minor notations. I’ve decided to go with UML, but I have forgotten the rules for using a filled in shape vs. an empty shape, not to mention all the line styles needed to convey relationships…GASP! Looks like tomorrow that I’m going to have to dust off the UML Distilled book laying around here somewhere.
It’s no wonder that I’ve forgotten a lot of these diagramming tools: Many of the clients I work for don’t have a clue what they’re looking at. For the last 4 years, I’ve been relying on text-based use cases because everybody, regardless of technical skill, can communicate with them. Frankly, I’ve gotten use to and comfortable with this format. There are some serious drawbacks to this though, namely the difficulty in seeing interactions between more than a couple modules at once. I seriously need some activity diagrams so I can start writing better test cases. I need to quit being such a Duct Tape Programmer. It’s quick, but it makes maintainability much harder than it has to be.
The best news is that free, open source diagramming tools are exponetially better now than they were just 4 years ago, so as soon as I acquaint myself with some of the formalities, I should be able to have my diagrams cranked out in no time.
-
To All the Veterans Out There…
Thank you. Being an American wouldn’t be possible without your willingness to risk life and limb to stand for the ideals of Democracy. God bless you!
-
Introducing Phind, a simple PHP script for finding foreign keys in MySQL tables
For years, I have wanted a way to programatically find foreign keys in MySQL tables using PHP. After a lot of thought, I have written Phind. Phind basically consists of one function getForeignKeys() whose only parameter is the table name. If that table has foreign keys, Phind returns a multidimensional array containing an index for the key as the first index, and the part of the key as the second index.
My ultimate goal is to use Phind to create a PHP CRUD generator written entirely in PHP. That’ll probably be a long way off, though. I just don’t have time to sit down and finish something like that right now.
The source code for phind is here: Simply rename the file from phind.txt to phind.php when you save it. You can also go here to see Phind in action on a table in a database on my server named ‘contacts.’ Eventually, I will add more examples to the documentation included with the phind.php file, but for now, it’s sparse. However, I’m sure there are enough PHP guys who have been looking for a way to make sense of what foreign keys are in a table and where exactly they are pointing to.
I hope this helps somebody.
Categories
- Adobe (1)
- Illustrator (1)
- Android (6)
- Apple (4)
- iPhone (1)
- Cell Phone Tricks (1)
- DSLR/Camera (1)
- Gadgets (3)
- Games (1)
- Google (2)
- Helpful Stuff for Teachers (1)
- Intro to Computer Programming (1)
- Kindle Fire (5)
- Linux (3)
- Microsoft Office (1)
- Excel (1)
- Microsoft Windows (33)
- Windows 10 (5)
- Windows 11 (8)
- Windows 8 (2)
- Windows Technical Preview (1)
- Mike Bryant for State Representative (5)
- OS X (7)
- Personal Failure (1)
- Personal Updates (241)
- Physical Fitness Challenge (2)
- Political Commentary (6)
- Raspberry Pi (1)
- RaspBMC (1)
- Recommended Products and Vendors (4)
- Social Commentary (5)
- Sustainability in Eastern Kentucky (2)
- Tech Tips (73)
- Getting Nerdy (1)
- Windows 10 (3)
- Windows 11 (6)
- Web Development/Programming (14)
- Visual Basic (1)
Archives