"I already use PostgreSQL for a few years, but every now and them, when I need to upgrade my local installation, I run into trouble. This is the step by step that I’ve used to upgrade my (homebrew) installation." This worked for me, and saved me a lot of time.

"Here’s my notes for the talk Streaming Massive Environments from 0 to 200 MPH presented by Chris Tector from Turn 10 Studios. He’s listed as a Software Architect there, and obviously has a deep understanding of the streaming system they used on Forza 3. This talk was nice and deep technically, and touches all parts of the spectrum." Very technical. But: if you can grok what's going on (and this is about at the limits of my simple understanding – could barely start to recreate what's described), it's very interesting about the challenge of rendering beautiful, high detail environments at a solid 60fps, mainly by pre-preparing a lot, and maximising streaming performance both from disk and from memory.

"A computer mystery/romance set five minutes into the future of 1988." Looks jolly good.

Ben Heck made his own pinball table. And it's not some half-baked pinball table running off a connected PC, with off the shelf components; it's largely built from scratch, from the cabinet to the LED matrix (!). All running off a single microcontroller. He's a smart guy.

"With this unique book, programmers, administrators, and others who handle data can learn by example from the best data practitioners in the history of the field. Modeled after O'Reilly's highly-acclaimed book, Beautiful Code, Beautiful Data lets readers look over the shoulders of prominent data designers, managers, and handlers for a glimpse into some of the most interesting projects involving data. In an engaging narrative format, the authors think aloud as they explain their work, highlighting the simple and elegant solutions to problems they encountered along the way." Oh. This could be lovely.

This is both good and bad in places; I'm not totally convinced by the "What would players rather shoot — a wall, or a Nazi?" argument, but I'm very interested (as per my previous writing on Far Cry 2) in notions of non-player characters as protagonist; the player as lens through which story emerges, rather than hero of said story. Stuff to think on, for sure, but I'm still working out how to respond to this; I'm not sure it fulfils its goal of discussing "how writers and designers can collaborate smoothly and successfully"; it just shows me some examples.

"We are defined by what we build. It’s not just the engineering ambition that designed these structures, nor the 20 people who died building the Brooklyn Bridge. It’s that we believe we can and decide to act." This is good.

Chemically, this makes sense, but I'd never thought this might be possible.

"Obama Says: Yes We Can is a Simon Says game based on Barack Obama's New Hampshire Primary speech, as later turned into song by will.i.am. Watch the game create a pattern of button and direction presses, and repeat that pattern correctly to score! The more you get correct, the harder the patterns become – can you keep up?" Oh blimey.

Lots of good stuff in here I didn't know about, all for your DS, and all not illegal. Hurrah for homebrew.

"With DS Reader you can read any e-book (or text file) on your DS. It even has a great little bookmarking function to keep track of your progress." Ooh.

"Game Trivia Catechism is a multiple-choice trivia game, testing your knowledge of video gaming. It can be played as straight trivia, or as part of a story that follows Al and Sally as they compete in the King of Game Trivia Tournament." Looks awesome.

"Current mass-market games present simulations of incredible fidelity. Many of these titles also push genre boundaries and offer new mechanics to players. The problem, argues Ubisoft’s Patrick Redding (FAR CRY 2), is that these two developments are disconnected. Game output appears information-rich, but how much of that information can the player actually use to play better, and how much of it is just there to be spectacular or cinematic?" I would pretty much kill to see this. Gah.

For those of you who might not be aware of its size, James has put the size of Gaza in context through comparing it to maps of other cities. Simple, effective communication.

"…most public objects – and certainly all municipal objects – should offer APIs. Furthermore, specifically with regard to public infrastructures like transit systems, I believe that this should be a matter of explicit government policy. What’s a public object? A sidewalk. A building facade. A parking meter. Any discrete object in the common spatial domain, intended for the use and enjoyment of the general public. Any artifact located in or bounding upon public rights-of-way. Any discrete object which is de facto shared by and accessible to the public, regardless of its ownership or original intention. How’s that for starters?"

Better than GetBundle, apparently – hunts down unofficial bundles on github and the like, as well. Nifty.

"What a wonderful idea," Jennifer noted. "We never get to see the people who make the games." Michael Abbott is talking about LittleBigPlanet.

Leanoard rounds up his favourite DS homebrew games. Some good stuff in here that I didn't know of.

"This is just one of many examples that show you can participate in online community without having to pretend to be something you’re not. In fact, participating with authenticity is not just morally good, it’s measurably more effective."

Powazek is right; this is definitely smart advertising, and full props to EA/W+K for just taking the credit and not trying to make it "viral"; it'll do that anyway. Although: it really is a glitch, you know.

"We need a National Videogame Archive. Luckily, we've just started one. We're going to preserve videogames for the nation. For better or worse. Forever. It's going to be brilliant…" Oh, that it is. Jonathan Smith on *every single bloody thing* that's perfect about Micro Machines 2 on the Mega Drive is a highlight so far.

Commander Keen on the DS. Heck yes. One of the first games I spent a *lot* of time playing.

"The technology will probably improve, but in lieu of the promised emergent web AI, we need to build more small tools, more games to bootstrap datasets, and more simple ways of encouraging people to play their part in the semantic web without ever having to explain what it is." tt++.

Fantastic presentation from Giles Bowkett, which is about generative music, art, shipping, Ruby, and building things for yourself.

"Paine does have a descendent, a place where his values prosper and are validated millions of times a day: the Internet. There, his ideas about communications, media ethics, the universal connections between people, the free flow of honest opinion are all relevant again, visible every time one modem shakes hands with another." Fantastic article

"At its core, what should this product be best at? When users think of this product, what is the central feature(s) that should spring to mind? Everything else is distraction, clutter, cruft."

"I think this vision of artistic expression as a form of collaboration is a truer description of the nature of game design than of any other medium, because video games are inherently interactive." Pliskin on Steve Gaynor, and the gap between the screen and the gamepad.

Portal-inspired homebrew game for the DS. Looks rather sweet, although not keen on collect-em-up mechanics.

"…then, after destroying his nano-network, as an admonition to the audience, extended [Arthur C Clarke's metaphor]: 'Any truly advanced technology is indistinguishable from garbage.'" Excellent summary of what sounds like a wonderful GDC Austin keynote from Bruce Sterling.

"'What we've done in MMOs and what we tend to lean toward is building an enviroment for the new player to explore that is essentially a safe environment… the newbie zone. For our explorative learners, we've given them safe zones to explore.' But that doesn't work for imitative learners." Excellent article on styles of learning, with particular attention to how MMOs teach players game mechanics.

"Very recently an anonymous poster on /b/ claimed to have hacked Sarah Palin's Yahoo e-mail account." 4chan members get into Sarah Palin's barely-disguised Yahoo mail accounts which she used for business.

Oh boy.

“I decided to create Flatshare fridge because there is nothing more disgusting than a dirty fridge in a shared flat,” he says. “At the time, I was living in such a flat!” Amazing.

"It occurred to me that if I could somehow tether a DSLR to an instant-on device like an Arduino microcontroller I would have less weight to carry around and could get more work done. After mentally spec’ing out what I would need, I realized the solution was right in front of me – because I bring it with me for Mario Kart wireless races on long night jobs – (In the manner of John Lasseter’s slow epiphany voice): “Use-the-Nintendo-D-S.” Duh." Oh wow.

Soulja Boy reviews Braid. Oh dear. (Although: much as I want to mock it, he is correct that time-rewind mechanics are, usually, a lot of fun in and of themselves. But still.)

"These concepts are not complicated by Cern standards. We are entering a zone which is weaponised to boggle."

Simple, straightforward, pretty much correct.

Yes, this is going to come in handy.

"This javascript function can then read in the current content of the text area, format it using a trimmed down version of textile, and then set the content of a DIV with the resulting HTML. The end result of all this is live comment preview, with textile formatting." Live textile preview functionality.

"Trying to over-explain the cause of a disaster often detracts from its more tangible impact. … Instead, Faliszek says, it is more effective to create resonant gameplay experiences that players will remember, particularly if the setting in question, such as a zombie invasion (or a tornado outbreak, for that matter) is already familiar." Why games don't always need tangible villains.

A nice approach to doing some of the typical monitoring you'd want to do with Google Analytics, eg monitoring PDF downloads. I'm not totally convinced by some of his syntax, but the functionality is good, and the regex trick is nice.

"It's just an Nintendo in a toaster, but I like it."

"With a recent project, we really started utilizing extensions with named_scope which is very powerful and cleaned up our code considerably." Some really nice examples of using named_scope effectively.

"Nintendo makes money with the hardware alone, which may be a superior business model." What, making profit on units rather than selling them at colossal loss is a *superior* business model? Who would have thought it!

Long thread of patched and hacked 8-bit and 16-bit ROMs, some bringing a vast amount of customisation.