Learning PostgreSQL at the Big Nerd Ranch
I spent last week learning about PostgreSQL at the Big Nerd Ranch, held at Historic Banning Mills, a remote but majestic location less than an hour's drive west of the Atlanta airport. The organizers of the event provided transportation from the airport on Sunday afternoon as well as for the trip back after lunch the following Friday.
The setting was perfect for this type of training. It was peaceful and relaxing, not at all like the training conferences I've been to (in big cities) in the past. The food was fantastic. I can't emphasize this enough. If you go, you'd better go on a diet beforehand, because you're going to gain at least five pounds eating their terrific food. I felt like I was eating at a five-star restaurant all week. The area has cell coverage, but it's not too great. Verizon was the best, but you had to be outside and preferably on the third-floor balcony to get a decent signal. A phone card, on the other hand, proved to be quite handy for me. The lack of cellular service probably was a good thing, however, because no one received distracting cell phone calls during class. The Internet service was by satellite, so it was a bit slow. The organizers y plan to install a T1 line soon though, so this may not be a problem in the near future.
We started each day with breakfast at 8:30. Lunch was at 12:30 and dinner at 6:30. Each day, around 2pm, we took a break from training and took about a 45-minute walk through the woods, exploring the different sites and scenic trails around Historic Banning Mills. This was a good thing, because it helped stave off the afternoon food coma that ordinarily would have set in. It's not quite long enough to burn off the lunch calories, but it's invigorating nonetheless. After dinner, some would go back downstairs to the classroom to work on individual projects with assistance. Others would check e-mail or simply hang around and chit-chat. Others would play pool or watch a movie on the large-screen television upstairs. One night a few of us built a camp fire in the fire pit of an open-air pavilion just up the hill from the lodge. On Tuesday night, we watched the vice-presidential debate on TV and talked politics for a bit.
The training was structured to teach as much about PostgreSQL administration as possible in five days. It even says so on my diploma. There is room for 12 in the class, but only 11 participated in this class. The organizers provided two manuals so we could follow their lesson plans and walk through the related exercises. On the last day of the class, we received a CD with the course materials, slides, documentation and even some photos we had taken during the week. Thanks to the generous (free) licensing of PostgreSQL, the lessons often included the official documentation for commands relevant to that lesson. This was their first time training for PostgreSQL 8.0, which still is in beta, so there were occasional minor mistakes in slides and manuals.
Aaron Hilegass and Chris Campbell were terrific instructors. Each knows PostgreSQL thoroughly and conveyed that knowledge with ease. They played tag-team training throughout the week, each teaching different lessons. The lessons consisted of a 10-30 minute slide presentation, followed by an exercise and a challenge problem to test what we had learned. I usually had time to do everything before we moved on to the next lesson. There were 40 lessons in all, covering everything from how to set up PostgreSQL, psql (the client command-line application) tricks, an overview of SQL, user and group permissions, client authentication, logging, backing up and restoring to a point in time, monitoring the server, query optimization, rules, triggers, replication and much more. On the last day, we wrote some C programs with the libpq library and Perl scripts using Perl DBI. Again, the manual stepped me through everything, so my inexperience in those languages was not a problem.
Each topic was well-researched and thoroughly covered. I was impressed by the depth in which the instructors covered the important topics. For example, a good amount of time was spent explaining how indexes are built and used internally and how to optimize your queries--stuff that good database developers need to know but usually do not bother to learn in detail.
Overall, I'd give the Big Nerd Ranch a ten out of ten. We had a great time and learned a tremendous amount of material in a week's time. This was, without a doubt, well worth the expense. Even though PostgreSQL is free, my time is not, and I'm sure I shaved off a huge chunk of the learning curve by attending this class.
Doug Hall is the primary database developer for AIDT in Montgomery, Alabama. He has developed in-house applications, primarily with 4th Dimension, for the past 13 years.
Practical Task Scheduling Deployment
July 20, 2016 12:00 pm CDT
One of the best things about the UNIX environment (aside from being stable and efficient) is the vast array of software tools available to help you do your job. Traditionally, a UNIX tool does only one thing, but does that one thing very well. For example, grep is very easy to use and can search vast amounts of data quickly. The find tool can find a particular file or files based on all kinds of criteria. It's pretty easy to string these tools together to build even more powerful tools, such as a tool that finds all of the .log files in the /home directory and searches each one for a particular entry. This erector-set mentality allows UNIX system administrators to seem to always have the right tool for the job.
Cron traditionally has been considered another such a tool for job scheduling, but is it enough? This webinar considers that very question. The first part builds on a previous Geek Guide, Beyond Cron, and briefly describes how to know when it might be time to consider upgrading your job scheduling infrastructure. The second part presents an actual planning and implementation framework.
Join Linux Journal's Mike Diehl and Pat Cameron of Help Systems.
Free to Linux Journal readers.Register Now!
- Murat Yener and Onur Dundar's Expert Android Studio (Wrox)
- SUSE LLC's SUSE Manager
- My +1 Sword of Productivity
- Managing Linux Using Puppet
- Non-Linux FOSS: Caffeine!
- Tech Tip: Really Simple HTTP Server with Python
- SuperTuxKart 0.9.2 Released
- Doing for User Space What We Did for Kernel Space
- Parsing an RSS News Feed with a Bash Script
- Google's SwiftShader Released
With all the industry talk about the benefits of Linux on Power and all the performance advantages offered by its open architecture, you may be considering a move in that direction. If you are thinking about analytics, big data and cloud computing, you would be right to evaluate Power. The idea of using commodity x86 hardware and replacing it every three years is an outdated cost model. It doesn’t consider the total cost of ownership, and it doesn’t consider the advantage of real processing power, high-availability and multithreading like a demon.
This ebook takes a look at some of the practical applications of the Linux on Power platform and ways you might bring all the performance power of this open architecture to bear for your organization. There are no smoke and mirrors here—just hard, cold, empirical evidence provided by independent sources. I also consider some innovative ways Linux on Power will be used in the future.Get the Guide