In Nigeria: Weekend exploring
By Selena Deckelmann
July 5, 2009
Yesterday, I traveled to a Michelin (yes, the tire company!) plantation for a party thrown in honor of the new Secretary to the Ondo State Government, Dr. Aderotimi Adelola.
Michelin grows rubber trees on this sprawling estate. It took nearly 20 minutes to get from the highway to the primary school deep inside the plantation where the celebration was held. Tapped rubber trees pictured below!
I was invited to a table inside the Governor’s main tent, and spent most of the time just looking around at all the government officials, and chatting with the Chairman of SITEDEC, Cyril Egunlayi.
The high point of the afternoon was Dr. Olusegun Mimiko’s speech welcoming Dr. Adelola to the government. He’s a charismatic speaker. The people around the perimeter pressed closer, and were attentively silent for his 10 or 15 minute speech. He emphasized education—his hometown’s slogan is “Home of Education”. He also said that despite Ondo State’s history of leading Nigeria in educational opportunities, the state had regressed and needed to catch up again. Mimiko speaking:
The car ride out and back to the plantation took about two hours each way. I spent much of that time talking about open …
postgres
Nigeria PostgreSQL Training: Day 1
By Selena Deckelmann
July 3, 2009
I am in Lagos, Nigeria this morning, preparing for a half-day car ride to Akure in Ondo State. I’ll be spending the next seven days with programmers from Ondo state, who are six months or so away from deploying a system to provide government-provided services using a centralized card system. They are designing their database using PostgreSQL!
Ondo state has a little over 3 million people, and plans to integrate a half-dozen government services under the centralized data system. They conducted a census in 2006, and will be using their new system to gather data yearly going forward.
Their plan is extremely ambitious, given obstacles like lack of power in most of the rural areas, and social issues like people not wanting to give accurate information about themselves to the government. Some biometric information, like finger prints, will be gathered electronically using special machines that they will primarily lease (instead of buying—significant cost savings), and these machines require power. They have been specially outfitted with dry-cell batteries, that operate for about 8 hours before needing to be recharged.
For the social problems around data collection, a marketing campaign …
postgres
LinuxTag 2009 day 1
By Jon Jensen
June 24, 2009
Today was the first day of LinuxTag 2009. Representing the Interchange project are Stefan Hornburg of LinuXia Systems in Germany, Davor Ocelić of Spinlock Solutions in Croatia, and I, Jon Jensen, of End Point in the U.S.
Tuesday afternoon we set up the booth (here still underway):
That was a fairly quiet affair since many exhibitors showed up later that afternoon or early Wednesday morning. But it was nice to get it all done early. The setup involves the network and power wiring behind the scenes, hanging the signs, unloading the marketing materials, and getting all the equipment tested (and then put away again for the night). At night back in our apartment we made some updates to the slide presentation to include many more examples of some of the busy and interesting sites we have current data on that appear in the Interchange Hall of Fame.
We’re sharing a booth with the YaCy distributed search project, and have had a few good discussions with their people.
Booth traffic was probably about the same this year as it was the first day last year—a little slow. We talked with several people who were interested in hosted e-commerce solutions such as Interchange is.
In two cases, very …
conference interchange open-source
nofollow in PageRank Sculpting
By Steph Skardal
June 24, 2009
Last week the SEO world reacted to Matt Cutts’ article about the use of nofollow in PageRank sculpting.
Google uses the PageRank algorithm to calculate popularity of pages in the web. Popularity is only one factor in determining which pages are returned in search results (relevance to search terms is the other major factor). Other major search engines use similar popularity algorithms. Without describing the algorithm in detail, the important takeaways are:
- PageRank of a single page is influenced by all inbound (external links) links
- PageRank of a single page is passed on to all outgoing links after being normalized and divided by the total number of outgoing links
So, given page C with an inbound links from page A and B, where page A and B have equal page rank X, page A has 3 total external links and B has 5 total external links, page C receives more PageRank from page A than page B.
From an external link perspective, it’s great to get as many links as possible from a variety of sources that rank high and have a low number of external links. From an internal site perspective, it’s important to examine how PageRank is passed throughout a site to apply the best site architecture. …
seo
Open Source Bridge: the aftermath
By Selena Deckelmann
June 24, 2009
Open Source Bridge Opening Day
I’ve been planning the Open Source Bridge conference in my spare time over the past 9 months here in Portland, OR. We finally made it happen June 17-19, 2009 at the Oregon Convention Center. I had the pleasure of co-chairing the event with Audrey Eschright, and was extremely happy that End Point decided to also sponsor the event.
The conference was organized around the idea of “open source citizenship”, and what things we as individual contributors, companies and users of free and open source software do to participate. We came together to share how we do things, what we’ve already done, and what we might be doing in the future.
The conference held 76 sessions, from over 100 speakers and panelists and 475 total participants over three days. There were 8 rooms full of talks for about 9 hours every day. We had a 24-hour hacker lounge at the conference hotel, and it was packed every evening—including our closing night, when we wrapped right at midnight.
Above, are my slides for the opening remarks, and there’s even a video of the opening session, the keynotes and all the sessions that happened in the Fremont room will be available at osbridge.blip.tv. …
conference open-source
Getting Started with Demand Attach
By Steven Jenkins
June 23, 2009
As OpenAFS moves towards a 1.6 release that has Demand Attach Fileservers (DAFS), there is a need to thoroughly test Demand Attach. Getting started can be tricky, so this article highlights the important steps to configuring a Demand Attach fileserver.
OpenAFS CVS HEAD does not come with Demand Attach enabled by default, so you’ll need to build your own binaries. You should consult the official documentation, but the major requirement is to pass the –enable-demand-attach-fs option to configure. You should also note that DAFS is only supported on namei fileservers, not inode.
Once you’ve built and installed the binaries, you need to be careful to remove your existing fileserver’s bos configuration (i.e., fs) and put a dafs one in place; e.g.,
$ bos stop localhost fs -localauth
$ bos delete localhost fs -localauth
Once the fs bnode is deleted, you need to install the new binaries and create the dafs entry. You should pass your normal command line arguments to the fileserver and volserver processes:
$ bos create localhost dafs dafs "/usr/afs/bin/fileserver -my-usual-options" \
/usr/afs/bin/volserver \
/usr/afs/bin/salvageserver /usr/afs/bin/salvager
Once the …
openafs
Packaging Ruby Enterprise Edition into RPM
By Adam Vollrath
June 16, 2009
It’s unfortunate that past versions of Ruby have gained a reputation of performing poorly, consuming too much memory, or otherwise being “unfit for the enterprise.” According to the fine folks at Phusion, this is partly due to the way Ruby does memory management. And they’ve created an alternative branch of Ruby 1.8 called “Ruby Enterprise Edition.” This code base includes many significant patches to the stock Ruby code which dramatically improve performance.
Phusion advertises an average memory savings of 33% when combined with Passenger, their Apache module for serving Rails apps. We did some testing of our own, using virtualized Xen servers from our Spreecamps.com offering. These servers use the DevCamps system to run several separate instances of httpd for each developer, so reducing the usage of Passenger was crucial to fitting into less than a gigabyte of memory. Our findings were dramatic: one instance dropped 100MB down to 40MB. (The status tools included with Passenger were very helpful in confirming this.)
There has been some discussion on the Phusion Passenger and other mailing lists about packaging Ruby Enterprise Edition for Red Hat Enterprise Linux and its derivatives …
hosting redhat ruby spree
Inside PostgreSQL - Clause selectivity
By Josh Tolley
June 5, 2009
One of the more valuable features of any conference is the so-called “hall track”, or in other words, the opportunity to talk to all sorts of people about all sorts of things. PGCon was no exception, and I found the hall track particularly interesting because of suggestions I was able to gather regarding multi-column statistics, not all of which boiled down to “You’re dreaming—give it a rest”. One of the problems I’d been trying to solve was where, precisely, to put the code that actually applies the statistics to a useful problem. There are several candidate locations, and certainly quite a few places where we could make use of such statistics. The lowest-hanging fruit, however, seems to be finding groups of query clauses that aren’t as independent as we would normally assume. Between PGCon sessions one day, Tom Lane pointed me to a place where we already do something very similar: clausesel.c
“Clause selectivity” means much the same thing as any other selectivity: it’s the proportion of rows from a relation that an operation will return. A “clause”, in this case, is a filter on a relation, such as the “X = 1” and the “Y < 10” in “WHERE X = 1 AND Y < 10”. PostgreSQL uses …
postgres