Author: matthew

We are already beginning to see reviews of VMware Cookbook, and the book has not yet been released. I’ll post more as I find them.

Thanks, Paul, for your post on your PJSquared blog.

The main Amazon site says it is in stock, and I’m hearing reports of people seeing it “in the wild,” although I haven’t yet received my copy.

This book is perfect for people who are interested, but have no idea where or how to get started with Ubuntu.

Disclosure: For this edition, I had the privilege of editing and updating chapters 1-4, 7, 11, and the appendices, and provided assistance checking the full manuscript, including the final proof, against the final release version of the software covered. I also was the lead contact during the copy edit, index, and final proof and author query stages.

If you have been around the Ubuntu Forums for a while, you are certain to have come across a person calling himself panickedthumb. Guess who we are interviewing in this edition of Ubuntu Community Interviews?

1. Tell as much as you’re willing about your “real life” like name, age, gender, location, family, religion, profession, education, hobbies, etc.

I’m Travis Newman, 27 years old, living in Radford VA. My wife, Katie, and I have two cats Max and Leo. I’m AVP of IT at a regional bank in the area. In my spare time, which I seem to have little of lately, I’m an avid gamer and internet junkie.

2. When and how did you become interested in computers? in Linux? in Ubuntu?

Ever since I first saw a PC, in first grade, I have been fascinated by them. Unfortunately I didn’t get one until my senior year, in 1998. Back in Sept. ’98 I was having trouble sending email and double-clicking on links. But my lack of knowledge didn’t slow me down. I wanted to know how things worked, what I could and couldn’t do. I ended up using the Compaq restore CD more than I would like to admit, but I learned quite a bit. One thing that I learned was, even though I thought it was all that was available, I hated Windows.  Later that year the network admin at my high school gave me my first Linux CD. Perhaps installing Linux, especially Slackware 3.5, was not the best idea having only *really* used computers for 2 or 3 months, but I did. I was lost. Could never figure out how to start XFree86. But I persisted throughout the years, trying different versions of Red Hat and Mandrake, and many others, and by 2003 I was using Gentoo pretty much full time.  In 2004 I heard about this new distribution (which would become Ubuntu) that was starting up based on Debian, and I decided to give it a shot. My experience with Debian was not a good one, but I had hoped this new distro would help with that. It was still at no-name-yet.com, before being called Ubuntu, but I was hooked. It was very rough around the edges, but I could see the diamond in the rough. Never looked back.

3. When did you become involved in the forums (or the Ubuntu community)? What’s your role there?

I joined the forums October 27th, 2004, less than a month after it started, though I had been lurking for a bit before then. I became a moderator at some point in November, and have been one ever since, with the exception of a few months a couple years ago.

4. Are you an Ubuntu member? If so, how do you contribute? If not, do you plan on becoming one?

I am an Ubuntu member. I contribute as a moderator on the forums, and I started and co-admin the Ubuntu LoCo team for Virginia. Come by #ubuntu-us-va on Freenode the first Tuesday of every month at 8 if you want to join in the fun! 🙂

5. What distros do you regularly use? What software? What’s your favorite application? Your least favorite?

I use Ubuntu, and that’s really about it. I try other distros here and there. I absolutely love what they’re doing with Arch Linux, and I’m interested to see where Moblin goes for netbooks. However, since trying Ubuntu for the first time, nothing else has felt like “home.”  My favorite software is probably Firefox, and I know that’s a bit of a cop-out since it’s so popular, but I don’t even like browsing the web without it anymore. Least favorite software? Adobe Reader. Seriously, a document reader should not be so bloated and finicky.

6. What’s your fondest memory from the forums, or from Ubuntu overall? What’s your worst?

I don’t have a single fondest memory from Ubuntu or the forums. It’s a great place and I really feel at home there, so I have many fond memories just being part of the wonderful community and contributing as I can. However, one particularly funny memory, that’s kinda hard to explain, was the :porc::inca::dito::love: mystery. Someone in the #ubuntuforums channel started pasting what appeared to us to be random stuff, like the above. It’s still an inside joke to those who were there. I know it doesn’t sound that funny, but I guess you had to be there 🙂  Worst memory… well with a forum this size, there are some troublemakers and there are occasionally interpersonal conflicts among staff. I won’t go into any details, but those are rough to go through, and they are ultimately not good for the community. Luckily, much has been done over the years so that we have fewer and fewer problems.

7. What luck have you had introducing new computer users to Ubuntu?

Its a struggle sometimes, because for all its faults, Windows is pretty easy to use. Taking some people out of their comfort zone is like pulling teeth. I have had a few converts over the years, and helped get CD’s to a lot of students at a local community college. However, as I have seen over the years, getting someone to *try* Ubuntu doesn’t mean that they will stick with it. One of the most heart warming things for an Ubuntu user ever, though, was at our LoCo installfest in Galax for 9.04. A middle-aged couple had bought a netbook and hated the default Asus version of Xandros, and came by to get Ubuntu Netbook Remix installed. While that was going, Jim Tarvid (the other co-admin of the group) and I got wireless working on their Ubuntu laptop. People over 40 are frequently the hardest to try to convert, but this couple had basically done it on their own, and just needed a little help.

8. What would you like to see happen with Linux in the future? with Ubuntu?

I think it’s on a good path for the most part. I would of course like to see Bug #1 (https://bugs.launchpad.net/ubuntu/+bug/1) taken care of. It seems that every time Microsoft releases something new, we get a lot of new Ubuntu users. I think business as usual is not working as well for Microsoft anymore, and they need to change their game plan if they want to stay on top for the foreseeable future. But ultimately, I’d like to see Ubuntu (or Linux in general) get a 10% market share. I don’t mind if we never get to 50% or even 25% really, I just want enough so that businesses take us seriously and support the platform.  More than just Ubuntu or Linux, however, I would like to see Free software become the standard for software development. I really believe it’s the way of the future, and all of the best software available is Free (as in freedom, of course).

9. If there was one thing you could tell all new Ubuntu users, what would it be?

Don’t give up! I know it’s disheartening at times when you feel like you’re in over your head, but the forums, the mailing list, and the IRC channels are here to help.  Also, get involved! You feel much more a part of the community when you give back. When you become comfortable with Ubuntu, you can help others out. It’s what makes the community work.

What a fun book series this has been to read and review! I have been impressed by the book series so far and its treatment of the various topics. This may be my favorite of the series, although I will be reading The Manga Guide to Calculus later in the summer or early fall, so I won’t yet make that a definite statement.

As with the other books in the series, this book uses well drawn manga art to introduce and give a context for presenting the material–in this case, Newtonian physics.

The Manga Guide to Physics does not require knowledge of calculus for most of the book, although there are a few times in which knowledge of mathematics higher than algebra and geometry would either be useful, or in a couple of places necessary (such as during the discussions of springs and the conservation of energy).

I would not consider this book to be useful as a beginning physics textbook, but for anyone who has taken a high school course, it will be a useful way to review for a final exam and learn a bit more than would have been studied in the year long course. If you have completed a university basic course in physics that uses calculus (not the non-calculus version for non-science majors), this book will be below you. If you are reviewing for that non-science major course, you may find this book extremely useful and a fun way to help shore up and retain your studies.

Topics covered in the book include all the basics: Newton’s Three Laws of Motion, gravity, force and motion, inertia, momentum, impulse, energy, work, and so on. There is also a useful appendix titled Making Sense of Units, which helps the student do exactly that.

I haven’t taken a physics class since 1990. I’m sure I would have difficulty trying to pass the final exam for Physics 101 at the university based solely on my memory. After reading this book, paying careful attention to the examples and working through the problems in each along with the characters in the story, I believe I might be able to do it. That’s pretty good for someone so rusty. I think the book would be extremely useful to a student with less time between now and a careful study of the material in a class setting, especially someone preparing for exam time or who had or is having difficulty absorbing the topics and principles involved in basic physics.

There are a couple of weaknesses in the book. Some books in the series provide study questions for readers/students to answer on their own, with solutions in the back of the book. This one does not, so you have to pay careful attention and choose to work through the examples as they are discussed. The other weakness is that most basic physics courses will cover, at least in my memory, an introduction to electronics and electricity. This book does not, probably because there is a separate book in the series dedicated to that topic and because it really doesn’t fall under the precise topic of Newtonian physics, even though it is covered in those elementary physics courses. That’s it. Otherwise, I can recommend the book without reservation.

I have spent the last three or four weeks struggling through a book on relational database theory. Never content to know only the “how” of something, I wanted to learn some of the “why” behind SQL databases. This book covers that in depth, with a steep learning curve for someone like me who has a bit of experience using SQL in various applications, but who has never formally studied it. That is not a bad thing.

The book is SQL and Relational Theory: How to Write Accurate SQL Code by C. J. Date.

First, a bit of background. The author, C. J. Date, is well known in the field for his classic textbook An Introduction to Database Systems, which has gone through at least eight editions. He began working on databases in 1970 at IBM and worked with the inventor of the relational theory of database design, E. F. Codd. There is no doubt that this is a man who knows what he is talking about.

What this book sets out to do, in about 400 pages, is describe and define the relational model in greater depth and compare how SQL is currently used in many database applications like Oracle and MySQL to the theoretical ideal. As he does this, Date points out several inconsistencies with the SQL adaptation of the relational model and makes suggestions for how to adjust common usage to more closely conform to the ideal while acknowledging that at times perfect syncronization will be impossible using SQL. He also gives numerous examples of how it could be done in Tutorial D, which is an interesting study in itself.

I submit that this book is ideal for theorists, for highly qualified and experienced database administrators who want to learn at the feet of a sometimes emphatic and slightly dogmatic master who has been instrumental in the creation and spread of the relational database idea, but whose theory has not been perfectly implemented. If you merely want to know how to work within current implementation constraints without the larger picture, skip this book. If you want some fascinating, and sometimes difficult to grasp background and theory that will likely make you a better database wizard, this book is likely to help you get there.

Here are some highlights, sample questions and topics discussed in the book:

• What are the differences between the relational model and the various product implementations available today and in the past?
• Should a relational database allow duplicate entries?
• Why are null values a bad idea?
• What do relational expressions mean?
• Why must database constraint checking be immediate, at least in theory, and why is it often deferred in practice?

Seriously, that is just the beginning. There are excellent examples of SQL code throughout the book, great discussions of the mathematics behind the genesis of relational theory, and more. Beware, though, you may have to work to understand it, but it will be worthwhile for those who do.

If you have a Safari account and are interested, some of the chapters of our upcoming book, VMware Cookbook, are available in Rough Cuts. We would love to hear your comments (and corrections, if necessary).

Or at least, it is about to be. I just found out that my book Humor and Moroccan Culture is being processed to be included in the Mohammed VI Library at Al Akhawayn University in Ifrane, Morocco. I hope it is the first of many, and that they find Nowhere Else to Turn equally worthy of being added to their collection.

About four weeks ago I read a manga introduction to databases that I enjoyed thoroughly and reviewed. As I mentioned in that review, that sparked an interest in learning more. I’ve used databases for years, and my simple level of experience has served me well, but now I want to know more. I decided to start by brushing up on my knowledge of SQL. The three books discussed in this article are a good introduction. I have another book on my shelf that goes deeper into database theory and I will review that book later. Let’s start with a brief introduction to each of today’s books, which will be followed by a short comparison.

First, I read sitepoint‘s Simply SQL by Rudy Limeback.

I liked this book. It was easy to read and understand. I liked that the code focus is on using ANSI standard SQL as this gives knowledge that will work across platforms on multiple database systems from free options like MySQL to common proprietary ones like Oracle and SQL Server. The examples are clear and well written and the figures are wonderful (as is usual in sitepoint products).

This book is not intended for people who wish to learn to become database administrators. It was written for web developers who want to have a better understanding of the basics of SQL. This is an important fact. If you fit this role, this book is excellent.

The coding style was easy to read, but there were some odd quirks that I didn’t like. For example, as noted by the author himself, he likes to put commas at the beginning of lines when making lists. This is the only place I have ever seen that done. Now, this isn’t technically wrong, but it is unusual. I would have preferred to see code examples written with strict adherence to commonly accepted standards as this makes the task of reading other people’s code or writing good and readable code easier. However, I guess doing it this way can also be seen as a benefit as it will remind the reader that there is more than one way to do things, and that in the real world he will be sure to encounter non-standard methods and have to adapt. Honestly, that is my only big complaint about the book, and it isn’t a deal breaker.

Next, I read the new second edition of O’Reilly‘s Learning SQL by Alan Beaulieu.

If a person is looking to become a database administrator, or just needs to get up to speed on the basics with some understanding of what they are doing and why, this is an excellent place to start. However, this book does require that you have some experience with computers, especially a base knowledge of what a database is and how or why programs might want to interact with one. This isn’t a book for someone who is a complete novice to the realm of data storage and interaction, but rather intended for people who know what they want to do and why and need an in depth manual for how to accomplish the task of storing, retrieving, and using data but who may be a complete novice at doing so using SQL.

I love that the book is written by a very experienced Oracle administrator, but uses MySQL (version 6.0! –the only book I have seen so far to do so since this release is so new) as the base for all examples and instruction. The book itself focuses on teaching the ANSI standard clearly and well, but gives great examples using one free and open source product that is available for any reader to download and install on their system, with instructions on how to do so. Then, the author discusses some of the differences that may be discovered by readers as they move into the real world and begin to interact with other database systems from other vendors.

The book uses examples that are well formed, clear, and which adhere well to standards. I especially appreciate that the examples use good coding technique that is easy to read and would be a joy to maintain in the wild if it were discovered by a person taking over responsibility for a database they did not create.

Finally, I picked up a copy of another O’Reilly book, SQL in a Nutshell by Kevin Kline with Daniel Kline and Brand Hunt, which just released a third edition that is greatly expanded

This book is intended as a reference, not an instructional text. It serves this purpose well with pages and pages of great examples. The book is not focused on databases and SQL from a specific vendor, but gives great data and comparisons of commands and queries using ANSI SQL (SQL2003, aka SQL3) and then adjusting as needed for MySQL 5.1, Oracle 11g, PostgreSQL 8.2.1, and Microsoft SQL Server 2008. If you are responsible for moving data from one vendor’s product to another, or if you are responsible for databases from multiple vendors, this book could be a Godsend. Really, if you only use one of these products, the book is still a great value.

Keep in mind, this is not an instruction manual. This is a compilation of commands with examples. The goal is not to lead gently, but to get directly to the meat of using SQL, to give clear and detailed information about each command, its syntax and options, and several examples of usage. If that is what you are looking for, and especially a book with comparisons across platforms, this book will serve you very well.

Conclusion/Comparison

Each of these books does a good job of fulfilling its goal of communicating to a specific audience. They all cover the basics, and the first two do a great job of teaching them in a logical and clear order, but in varying depth. If you are interested in learning SQL, hopefully this will help you determine if one of these offerings would be useful to you.

For people focused on web design and who only want to learn some of the basics, I feel quite good recommending Simply SQL. As with most of their offerings, this sitepoint book is dedicated to helping web developers improve their craft and they do a great job of serving that specific population. I was disappointed with the author’s decision to use his preferred coding style rather than the standard format, but the difference isn’t really so great as to be a huge problem.

I would imagine most people reading my blog would end up sharing my preference for Learning SQL. This second edition is clear, very well written, uses beautiful code examples, and has wonderful exercises at the end of each chapter (with solutions in the back of the book) to assist you in learning. I love how the book uses MySQL to teach, but doesn’t ultimately limit itself to only one database product and that the author has a wealth of real world experience using many products and takes time to discuss some of the differences without getting bogged down or too distracted from teaching good, portable ANSI SQL basics.

Finally, I don’t think the average person will have much use for SQL in a Nutshell, but for those who work with databases regularly, the book is sure to find a place of importance on the reference shelf. As I read through the examples, I appreciated how clearly and completely the different implementations of ANSI standards were delineated for each of the products covered and how differences from the standard were clearly noted and defined for each.

We have a musician to interview in this edition of our Ubuntu Community Interviews. Unsurprisingly, tinivole is also a pretty good guy and a wonderful addition to our forum staff. I think you will enjoy this conversation.

1. Tell as much as you’re willing about your “real” life – name, age, gender, location, family, religion, profession, education, hobbies, etc.

My real name is Iain Buclaw. I was born in Surrey, 1989, and am currently living in the West Midlands, UK. I have a European bound family with heritage roots from Italy and Poland, to which I’ve picked up enough of the Polish language to survive if I were ever to visit the country. My strengths are in Studio Engineering/Production and IT Support/Analyst roles; I am yet to decide which one to take on as a full-time career. I have vendor IT qualifications in CompTIA A+, Network+; Microsoft Certified DST; and Linux LPIC1. In my spare time I am a hobbyist programmer of the C and Perl languages, and spend whenever I can thrashing out Jazz/Rock on guitars.

2. When and how did you become interested in computers? in Linux? in Ubuntu?

I was a Music Recordist before I was a Computer Enthusiast, ever since the age of 12 using Cool Edit Pro2, and later Adobe Audition to record, track, layer and mix my own songs. That was until one day I had a sudden epiphany which motivated myself to learn programming. Of course, this sort of change didn’t happen over night, but after hours of playing with, and enjoying a software I bought called QuantumFX; which in a nutshell is a 5th Generation Programming IDE for making custom audio VST effect plugins, ranging from simple delays, to complex amp simulators.

At 16, I joined a Music Technology and an A Level Computing course at my local college. The practical elements of Computing were great, despite the course language of choice, VB6. That with added theory work in networking, programming paradigms and operating systems led me to stumble upon debian.org for the first time in my life, although it was to take another year before I initially installed my first Debian system. In the meantime, however, the course eventually because monotonous, so I ended up dropping out later during the second year, but continued on to get a BTEC Diploma in Music Technology.

By the time I had switch completely 100% Debian, Ubuntu Hardy Alpha1 was released, which just so happened to be the first time Ubuntu worked completely out of the box on my desktop system. The rest is history.

3. When did you become involved in the forums (or the Ubuntu community)? What’s your role there?

Almost immediately as I had installed Hardy Alpha1. Initially, I had a few questions to ask here and there about the operating system, and in the time waiting for replies, idolised by reading other support threads, occasionally answering to some of them. Over time as the number of solved posts increased, so did my enthusiasm to help/teach people.

After about 5 months of answering support threads, and some bumps into forum conversation with vor (aka sdennie) later, I received a private message from Joeb inviting me to join the Beginners Team. Since joining, I have seen the team grow and evolve from around a dozen active members to what now must be 40-50 active members. I now give support on both IRC and Forums, and have gotten involved in the Beginners-Dev and IRC Focus Groups within the BT team. Also, I would have been a key player in the Stalkers FG too, if such a FG existed, which it doesn’t.

4. Are you an Ubuntu member? If so, how do you contribute? If not, do you plan on becoming one?

I’m not currently a member, but I suppose, like many, it is something that I would like to apply for in the interim future. I haven’t really gotten involved in any LoCo group yet due to geographic constraints, but it’s something that may begin to happen as I relocate to better suited areas of Britain.

5. What distros do you regularly use? What software? What’s your favourite application? Your least favourite?

I run Debian 5.0 and Ubuntu 9.04, both installed from a Net boot disk, both of which are running 2.6.29 kernels with patches for real-time computing. Something I’ve slowly been adding to is to make a small recording studio setup in Linux without the bloat that other Studio distributions seem to be included with.

My favourite programs are vim and perl, if I were to naturally follow in the path of sdennie. I also have a liking to my own adapted version of an old abandoned pseudo C interpreter. kvm is another one for the good books, especially when used as a machine to test fixes/solutions before posting them. And ardour is a another brilliant application that deserves merit too. I don’t generally have a least favourite.

6. What’s your fondest memory from the forums, or from Ubuntu overall? What’s your worst?

Every time sdennie kicks me from a channel would be my fondest moment, more-so now as I can kick him back. Compiledkernel is another fond memory too, I always enjoy it when he is around IRC talking to new users. I can’t think of any notable things that happened on the forums, although nowadays I find myself digging up more and more old threads I posted solutions in. Be that a good thing or bad thing.

The first week of being a moderator on the forums and all the anxiousness that came with it was perhaps one of the worst weeks. There is a lot to take in, and quite steep amount of adjusting to do. The first time I confused Edit and Quote was a notable experience to elevate that, although perhaps quite humorous now I look back on it. My time on the forums since has only gotten better as my confidence grows in making important decisions, I now have a deep respect for the staff, and understand their sometimes undervalued role.

7. What luck have you had introducing new computer users to Ubuntu?

Haven’t really introduced Ubuntu to any new users as of yet, although I’ve had plenty of conversations with people who are either aware of Ubuntu, own a CD, or have tried it out in a VM, but haven’t yet taken the leap onto trying it out on a real partition yet. Have even had an interview where the interviewer was an Ubuntu user, which was fun. Since joining the BT and Forum staff, I have always included my voluntary work on my CV, and interviewers always pick it out first. I feel it is important for them to understand just what it takes to be in such a role.

8. What would you like to see happen with Linux in the future? with Ubuntu?

Further adoption and growth. Perhaps not on the Desktop for the time being, but in every other nook and corner of the Computer world.

9. If there was one thing you could tell all new Ubuntu users, what would it be?

Although we have collaborative works such as Ubuntu nowadays, it is always important to consider your own learning ability before trying out a new operating system. The Study Skills Handbook by Stella Cottrell is one such book I’d recommend to people looking to optimise their own learning abilities, as it has, at the very least, played a vital part in my education.

I have used relational databases for years. I’ve used them to store mailing lists, email account data for postfix, blog and forum data, and more. They are convenient and powerful time savers. Most of what I have learned has been indirectly learned while studying something else; documentation for a computer programming language like PHP or Python, a book on website design for commerce, or documentation and code for an open source project like WordPress or Drupal. As a result, my knowledge is adequate for simple tasks and queries, but I’m nowhere near ready to be a database admin. What I know is incomplete, adequate for my actual needs, but with gaping holes in my knowledge.

Until this week, I was comfortable with this fact.

Since I read and enjoyed the other manga guides in this series that I have read, I picked up a copy of The Manga Guide to Databases. I wanted to see whether the book made the subject interesting and whether it taught the subject well.

The short answer is that I found the systematic and foundational introduction to database design clear, interesting, and enjoyable–so much so that I have ordered a few more books on database theory and design and SQL for further study (stay tuned, I may review them later). Contrast that with the indirect introductions I have previously encountered that made me want to ignore the topic, except for the aspects vital to my task(s) at hand.

The Manga Guide to Databases uses a somewhat silly, but pleasant story with well drawn artwork to ease the reader into a complicated subject that requires paying a bit of attention to for comprehension. It begins with the assumption that the reader knows nothing about the topic, so it would be perfect as a base level introductory text, especially for high school aged readers (or those of us who are a bit older, but who still enjoy a bit of whimsy).

We start with the question “What is a database?” and a great description of how and why they are useful. We move into a basic definition of relational databases with a very brief mention of other types of databases that exist. The fun continues with a chance to design a database around the model of entities and relationships.

Once the foundation is laid with a conceptual understanding of databases and their design, structured query language (SQL) is introduced. I was thrilled to discover this wasn’t product specific language, but rather standard ANSI, at least as far as I can tell (okay, I know a little more than I let on earlier, but I still consider myself a database/SQL novice). That is great, because it means that whatever is learned here should apply anywhere, whether using MySQL, PostgreSQL, Oracle, Access, Microsoft SQL Server, or whatever, so long as the product conforms to the standard. This certainly isn’t a complete SQL introductory text, but it is enough to get a person started understanding the basic concepts and how to operate a database.

Ultimately, the book was a success. I wouldn’t kid anyone into thinking that reading and understanding this book would make a person capable of real database administration, but it does give a clear and solid foundation for further study, and in my case has whet my appetite for going back to fill in some personal knowledge gaps that I have been content to let exist for a very long time.