SQLite Rules

Quick, what’s the most widely deployed database in the world? MySQL? Oracle? Nope, it’s that puny squirt SQLite – the one you see listed as an option every time you set up a new Rails or Django site. SQLite is not a database server, but a SQL-compatible interface to a single file — perfect for every application that needs a full relational database without the overhead and complexity of a client/server connection. In other words, it’s in your smartphone. It’s on your Mac (driving the indexes in Mail.app, plus the databases behind Aperture and Safari). It’s in Adobe AIR. It’s in FireFox. It’s in Android. It’s in a bunch of giant products and services that will never admit to it.

SQLite is fast. Hella fast. Not great with massive concurrency or transactions, but runs circles around its more popular big brothers in simple SELECT/INSERT statements in moderate-traffic environments. Apparently it can be used to run production web applications if you don’t transactions or permissions (“If your site is small enough to run on a single server, it’ll rock on SQLite.”)

Excellent interview with SQLite’s creator Richard Hipp in this week’s FLOSS. Incredibly humble guy. Talks like his accomplishments ain’t no big thing. But his software changed the world. And instead of making a million bucks off it, he took his name out of the source code and released it into the public domain. Now he makes his living doing customizations for giant corps. Altruism can be good business.

Music: The Who :: Sunrise

Duck Butter

Sauces 2008

Ooooooo wEEEEE! Made my “annual” pilgrimage at SXSW to Tears of Joy Hot Sauce Shop in Austin (bottom of 6th street, across from Damn Good Tacos). Since I depleted last year’s 8-bottle shipment easily, ramped it up to 10 this time, plus an assortment of mustards (I loves me my mustards) and a bottle of Salt Lick BBQ sauce for good measure. Came home tonight to a big box full of foam peanuts and bubble wrap, which Miles and I dove into just in time for dinner (chicken sandwiches).

First up: Duck Butter. Mmmmm tasty! But too mild. Followed by Bee Sting, a honey-based habanero sauce. Totally different kind of tasty, but still on the mild side (Amy disagreed). I was looking for some real tears of joy, which I finally got with a big dollop of Lottie’s scotch bonnet elixir. Blinding sheet of pain racing up the plane of my face and I’m in heaven.

Music: Rufus Thomas :: The Preacher And The Bear

What Makes Finnish Kids So Smart?

Wall Street Journal: In the international PISA test, Finnish students rank as among the smartest in the world. Yet they don’t start school until age 7, have no classes for the gifted, no standardized testing, have plenty of “fruittari-hoppari,” and don’t agonize over college (since it’s free).

Finland’s secret? Not much. Basics. Pride. And, oh yeah – small class sizes and teachers with masters’ degrees. Another interesting difference – a much narrower gap between the highest- and lowest-performing students (4% in Finland, 29% in the U.S.) That’s because in Finland, none of the students move on until the slower students have caught up. Rather than pushing advanced students forward, they’re invited to help the slower ones. The thinking is that they can do so without harming their own progress.

“In most countries, education feels like a car factory. In Finland, the teachers are the entrepreneurs.”

There are good reasons (see article) why it would be hard for the U.S. to emulate Finland’s educational performance, but surely we can learn something by observing? Let’s start with smaller classes, better teachers, and and end to No Child. That seems pretty fundamental.

Music: The Hold Steady :: Cattle And The Creeping Things

WordPress Patch Committed

Wpicon Woo hoo! Last June, while trying to convert a Movable Type site to WordPress, I struggled to come up with a way to get the site’s existing tags, stored in the MT “keywords” field, converted to native WordPress meta fields during import. Finding no workable recipes in the wild, realized I was going to have to modify WordPress’ MT importer directly. Took a bit of hacking and experimenting, but eventually got it working. Decided to share my mods back with the community by contributing a patch to WP Trac.

Months passed, nothing happened. In WP 2.3, WordPress gained native tagging support and I found myself facing a similar problem, needing to convert MT keywords directly to WP tags. Modified the importer again, re-contributed my patch, and… nothing happened. Then, last night, just a week or two before the release of WordPress 2.5, received notice that my patch has been committed to trunk. Fewer than ten lines of code, but it’s my first tangible contribution to an open source project (beyond helping with documentation and plugins, etc.)

A small deal, but I’m proud.

Music: Talking Heads :: Born Under Punches (The Heat Goes On)

Shift Happens

This video’s projections re: the capabilities of a $1000 personal computer exceeding the capabilities of the human brain by 2023 and that of the entire human race by 2049 remind me of one of the most jaw-dropping books I’ve ever read, Ray Kurzweil’s The Age of Spiritual Machines.

You are a speck, flitting briefly through an inky void…

SXSW 2008 Recap

Howareyou Just before leaving for Austin last week I caught an article that brazenly wondered “Has SXSWi gone mainstream?,” citing the choice of Mark Zuckerberg for one of the keynotes. What happened to the cutting edge? It’s true nothing really ground-breaking came out of this year’s show, but that had absolutely nothing to do with the conference’s usefulness… or fun quotient.

As usual, I took (and posted) loose notes on most of the sessions I attended. And as usual, there are often two or three sessions you want to see all happening at once. If you realize you’ve stumbled into a clinker, it’s a crapshoot whether it’s going to be worth it to stumble out, walk halfway across the convention center and try for seating in another — but you do your best. The Twitter back-channel helped tremendously… getting bits and pieces of other panels whispered in helped alleviate the feeling that you were missing something big.

Twitterrific Icon Yeah, I fell for the Twitter thing big-time this year (I’m “waxwing,” if you care); remains to be seen whether it will be as fun or as useful outside the context of the show. Twitter was everywhere – at times it seemed like you couldn’t glance at a laptop (must have been 85% Mac, for cripes sake) without seeing someone plotting their tweets. I’m not big into SMS, but between trying to hook up with people and following Twitter feeds, I’ve never done so much texting in my life

Zucker Had the inverse privilege of being present at the Mark Zuckerberg train wreck interview … not to be forgotten. Gossip and armchair analysis of the interview dominated conversations for the next 24 hours until we were all just sick of hearing about it.

Cacherock Got four hours of good geocaching in with mandric on the first day, before badge pick-up. Austin is in love with virtual (no physical box) caches for some reason – I think they just love their history. As a way to discover parts of a new city through serendipity, caching can’t be beat (and I think Milan caught the bug too!) Some pretty creative hides. Thanks Austin!

As for panels… where to begin? The Expression Engine 2.0 demo blew our doors off (coming version fully integrates ORM-based framework CodeIgniter). Jason Fried’s 10 Things We’ve Learned at 37 Signals totally inspiring for the 2nd year in a row. Henry Jenkins keynote an intellectual rollercoaster — tough competition with Kathy Sierra’s Tools for Enchantment (walked out of that one reeling). So many incredible data visualization techniques unwrapped in Data as Art (big implications and challenges for journalists). Went to two scaling sessions: Scalability Boot Camp and Scaling Web Ventures – of the two, the 2nd had more real-world tips, both both full of useful goodies. Interesting web pre-history in The Web That Wasn’t. Still feeling ho-hum about Adobe Air. Building Portable Social Networks attempted to address the coming tower of Babel between SNs, but left us with “We’re in for a world of pain.” Speaking of pain, I felt for the Microsoft guy defending MS Sharepoint against Drupal at the CMS Roundup. More here.

Neil Getting too old for the relentless party scene that is SXSW, now more interested in finding quiet places to talk with old co-workers and friends, but managed to squeak in a couple of good parties. Really enjoyed myself at Opera‘s party at Stubbs, where I spent 20 minutes in the bathroom talking with an Opera engineer who was the spitting image of Neil from The Young Ones. Think Opera is dead/irrelevant? Factoid: Opera currently employs more than 500 people – the mobile browser market is huge, and Opera owns it. Also a great party at the Mexican American Cultural Center (gorgeous architecture, and music by Gruppa Phantasma = Santana + War + 2008; break dancing like you never seen. Managed to get by on 5-6 hours of sleep per night, but couldn’t keep up that pace for much longer (despite official advice to NOT try and pace yourself (the “liver hacks” portion of that session were especially interesting).

Finally made my pilgrimage to the Daniel Johnson “Hi, How Are You?” mural at the top of Guadalupe, en route to lunch at Ruby’s – some of the most amazing brisket and ribs I’ve ever eaten, served up by the pound on butcher paper in a ramshackle wood and corrugated tin building that hasn’t been renovated in 70 years (or something like that). Even beat The Salt Lick (but not by much).

Didn’t take as many photos as in years past, but managed to get a Flickr set up. Once again, it takes something like SXSW to lift us out of the .edu miasma and into the new world. Always worthwhile.

Update: Wow – Check out these SXSW Interactive 2008 Sketchnotes. Gorgeous.

Scalable Web Ventures

Loose notes from SXSW 2008 panel Scalable Web Ventures, with:

Chris Lea Media Temple
Joe Stump Lead Architect, Digg.com Inc
Cal Henderson Badass MC, Flickr
Matt Mullenweg Founding Dev, Automattic/WordPress
Kevin Rose Founder, Diggnation/Digg Inc

This session was about much more than load balancing – scaling orgs in all directions (personnel, technique, communication), but was focused on technical scaling techniques. Amazing to see how some of the internet’s most popular properties have faced the problem in completely different ways, and how all of them basically learned by doing. You can throw, money, software, hardware, or brains at the problem, in various combinations… and these orgs have tried everything. Juicy stuff.
Continue reading “Scalable Web Ventures”

CMS Roundup

Loose notes from SXSW 2008 panel Content Management System Roundup, with:

George DeMet Owner, Palantir.net
Jeff Eaton Lullabot
Tiffany Farriss Pres, Palantir.net
Mike Essl Owner Operator, mike.essl.com
Matthew McDermott Principal Consultant, Catapult Systems

The perennial question on every web dev mailing list: What CMS should I choose? Expression Engine made a huge splash at this year’s SXSW, but the Drupalites were out in force as well. This panel basically boiled down to MS Sharepoint (missed this, but not interested), EE, Drupal, and observations on a smattering of other systems. In a software category that offers around 600 choices, it’s impossible ever to represent the whole picture with anything approaching accuracy, but the conversation was still useful.

Continue reading “CMS Roundup”

Building Portable Social Networks

Loose notes from SXSW 2008 session Building Portable Social Networks with:

Jeremy Keith Clearleft Ltd
Chris Messina CEO, Citizen Agency
Leslie Chicoine Experience Designer, Get Satisfaction
Joseph Smarr Chief Platform Architect, Plaxo Inc
David Recordon Open Platforms Tech Lead, Six Apart Ltd

This topic has been fresh on our minds at the Berkeley J-School in our work providing guidance to news publications who are trying to focus more on community, and wondering whether to just tap into Facebook, use Ning, or create their own. The public is rapidly approaching SN overload. Are people really willing to create yet another SN profile? Will they able to re-engage their existing networks of friends? What about all of the data they’ve already stored in their existing SNs? Will BuddyPress help? OpenSocial? SocialThing? What are the technical and privacy issues we’re facing here? Is this problem solvable, or are we erecting a tower of babel?

Continue reading “Building Portable Social Networks”