Skip to content

Category: General

The Official Ubuntu Book, Fourth Edition — first review and more

The new edition of The Official Ubuntu Book has hit the shelves in some places. I just received my copy. I mentioned earlier the Kindle version was available. Today, I’m pleased to mention another format: Adobe PDF. Also, a free sample chapter is available from InformIT, who are also selling the aforementioned PDF.

As the title mentions, the first review I have seen is up at A Million Chimpanzees. Enjoy!

The Official Ubuntu Book, Fourth Edition is available

Ubuntu Book cover

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.

An interview with Travis Newman

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.

The Manga Guide to Physics

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.

SQL and Relational Theory

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.

VMware Cookbook in Safari

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).

Reading up on SQL

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.