son of SQL

Who knew that I prefer the world in 2-D? Relational databases are a labyrinth I can't seem to navigate my way out of. It's not that I don't know whether to turn right or left. I don't know if I'm upside down, which exit I'm supposed to be heading for, and I forgot how I got into the maze in the first place!

I think part of it is because I'm new to it. If I spent some time with it, I'd probably feel more comfortable with it. But, SQL (and relational databases) are in many ways non-verbal-- which is my strength. And my weakness is spatial orientation. I can remember, quite vividly, driving back from California on a Sunday night, sitting in the passenger seat, insisting to my friend that we were driving parallel to I-10. It was Phoenix, it was one o'clock in the morning, and no one was out except us. I was almost frantic; I wanted to get home so badly and I was so sure that we were never going to make it back to the freeway because we were running parallel to it.

And then we got to the on ramp. I felt internally disoriented now. Like a slap in the face, I was reminded once again that spatial orientation-- not my strong suit.

This is what relational databases look like to me:

Only maybe insert a few more going in at different directions.

So using MySQL under these conditions is just a wee bit difficult. Mostafa says, we can be precise with our MySQL queries. Sure, if you know what the heck you're doing!

The written examples in our Assignment packet helped me tremendously, especially because I chose to use the database provided, and I could use the examples as a template. I'm verbal: I saw the words, could see the pattern in the words, and could eke out a few queries that way. And there's nothing like seeing the query results table come scrolling up the screen instead of, "Error. You are a dummy and I can't understand what you are trying to tell me."

So, yay for the scrolling results, a small feeling of victory, and one step closer to wrapping my mind around MySQL.

We last left our intrepid heroine on the brink of disaster, lost in Linux's Labyrinth, a sinister lair riddled with rabid daemons, ports to nowhere, and sockets with jaws of steel. In search of her companion, Apache Web Server, our plucky heroine must battle the evil forces that threaten sudo shutdown at every turn...





If our heroine had directions, written in HTML, to help her navigate the treacherous labyrinth, it might look like this -->

She wouldn't make it past port 22 with that bit of unhelpful information. Our heroine would have to make her best guess as to which port is that port, where is there and what thing is that thing. The HTML jacks up her adrenaline with all the bold and the italics and the large font, but that's about it.



Our heroine would do much better with directions written in XML, because metadata is included within the document itself. Should she want to know which port to avoid, well, it's

Luckily for her, our heroine had previously taken two courses which helped prepare her to understand XML: Organization of Information followed by Cataloging. Her cataloging instructor spent a couple weeks exposing the class to XML and working with it a bit. She was able to reread those sections in Lois Chan's Cataloging and Classification in order to remind herself what she had previously learned.

This is not to say our heroine remembered everything from the cataloging course. As a visual learner, and one who usually learns better through a person than an inanimate object such as text, she used Mark Long's lecture series in UA CBT almost exclusively. Mark Long's lecture is pretty good, because he explains what he's talking about as opposed to merely reading the slides.

As an adventurer, and one who is fond of derring-do, our heroine attempted to learn more about XSLT through w3schools. After perusing through that, and HTTP Request, and XPath, our heroine determined that the best use of her time was to prepare for her work with Apache Server. (Never fear! Our heroine has not been defeated by XSLT, much like the Swamp Fox of the American Revolution, she's run away to fight again!)

And so, our heroine reviewed the basics of what she had learned last semester, and solidified her understanding of what XML can be used for, and dabbled a bit in more advanced XML-- mostly via video, with a dash of w3schools thrown in. 

She felt confident in her basic understanding of XML, ready to tackle the dangers of Linux's Labryinth! Stay tuned for the thrilling conclusion to our story: "XML Marks the Node;" or "XARGS: Revenge of the Gnomes."

Torpedoed!

So, this week one of our assignments for class was to design and post a basic web page. I've been dabbling in HTML for a few years-- took a community college web design class and tweaked the web page I used for my class when I taught school. Last year, for 504, I created a simple web page and was able to not only revisit some of what I already knew, but also dabble a little bit more with CSS. What nearly killed me then tried it again this time.




Float.


I suck at float and one of the reasons is that I don't do much with HTML or CSS on a regular basis. I have to retrain myself to a degree each time I tackle a web page. For this assignment, I looked at what I had done last summer and revised it. I had used div to float my picture and caption then and it when I looked at it again this summer, it looked ugly. Not to mention that apparently I had another div class for a second image that was not in my html (and a background image property that I didn't have either). So besides editing and changing the content and some of the style, I deleted some of the extraneous stuff.

Oops.

When I refreshed the page, my picture slammed back over to the left side of the page. The caption went from red italic to blue roman (matching the rest of the text). Any and all edits I made in CSS were not recognized by the HTML page. Just to make sure I had the right page open, I changed content in HTML. It showed up in my web browser; I knew the CSS was the problem.

For almost an hour I researched and looked at examples of floating, and everybody's got a different way of doing it. Some use one class, some use several. I tried everything. Finally I decided that since I only had one picture, I didn't want to use a class anyway. I wanted to use an ID. As I was doing that, I noticed something very peculiar... and it was the hideous

 

curly bracket of death.

What I had been researching, in a macro-analysis of the problem, was what I had done wrong with the code. I'm not brilliant with CSS or any aspect of web design. I make hideous mistakes all the time. I knew I had made one this time, too. What I should have been doing was reading what I had typed-- or rather what I hadn't typed-- a little more closely. Open curly bracket: yes. Closed curly bracket: oops.

I closed the #dm section of my css with a curly bracket, refreshed, and... We have a floater.

I can't tell you the sense of satisfaction of seeing a doofy little picture move from left to right. It's embarrassing in the grand scheme of things, but boy did I feel like I accomplished something.

Oh, I also cleaned up the caption's style and learned how to place margins in the body of the web page. So, in the end it was OK, I guess, that I spent so much time looking for something I didn't need to know.

The VI editor, in the directory, with the pipe

Do you remember playing Clue? Of course you do, and so do I. Do you remember announcing to your competitors, "I suggest that..." with a smug look on your face, then opening the envelope and discovering that you were dead wrong? And then feeling inadequate to the challenge of the game, and realizing that maybe you're not as good as you thought, and deciding that everything you thought you knew about the world was in fact, a horrible lie?

Me, neither.

But I felt a little bit like that this week! I, the person my family and friends turn to with computer problems, know now, with firm conviction, that I am an absolute idiot! Or, at least, that I've got a ways to go in learning about Linux.

This week I used the VIM editor, and wheeeeeeee! Not really sure what I was doing in there, haha, but I did go through the tutorial step by step and did very well at the exercises. My favorite little personal triumph was using a number followed by "GG" to get me back to where I was when I exited. "Oh, I think I was at around 600," I'd muse to myself, typing in 600 GG!! I still do not know if I believe the tutor when it assured me that I would eventually LOVE the H, J, K, and L directionals. Hmph, if you say so. I shall trust in the process.

I felt pretty proud of myself, hitting "i" to insert and "a" to append. I followed all the directions and felt pretty good about understanding until I took a step back and thought... Where am I in the computer? What am I doing? When I make a file in VIM, where is it? What is the difference between : and ! ??  I can do what the tutor wants me to but I can't understand why! I need my dunce cap now. Hopefully, I can take it off in a few weeks, as it all starts to make sense. (Trust the process, trust the process.)

Still, I must claim a small victory. Back in the shell, I decided to try using the pipe in a command. Nothing fancy, something simple.

cd lib | ls -l

And what happened? In one fell swoop, I changed the directory to lib AND listed the contents with their permissions.

VICTORY IS MINE! 

IN YOUR FACE, COL. MUSTARD!