-
I'm going to need to do this at some point.
-
"Here is a memory-friendly function that should be able to split a big file in individual queries without needing to open the whole file at once:" Yep, that'll do.
-
"Competitors should take a page from Apple's playbook here and be open about stuff that will give you a competitive advantage and shut the hell up about everything else. Open is not always better." If only because: you get a hell of a launch day. (But also because: you'll never promise things you can't deliver).
-
"Passing the salt will never be the same. We all knew it was inevitable. Passing the salt by hand just isn’t efficient enough in a world of bullet trains and pizza delivery and broadband. Luckily the condiments have come to life! They will waddle wherever you tell them to, so the next time someone wants the pepper, wind up the key, and pepper they shall have! Mercilessly marching towards them like the terminator, more of a threat to dull tastes than the human race." Not sure they're £20-good, but I do like this condiment set made of small robots.
-
"Here’s a complication of some common and useful time & date calculations and equations. Some, though very simple, are often misunderstood, leading to inefficient or incorrect implementations. There are many ways to solve such problems. I’ll present my favorites." These are, indeed, useful, and I've been using a few of them recently.
-
A good list of tips – lots of compiled stuff needs to be recompiled to x64, and this will be confusing. I am not upgrading quite yet.
-
"My other half says I’m losing it. But I think that as an enthusiast kernel developer she doesn’t have the right to criticize people." Generating ASCII pie charts with a single SQL query. It's a very, very big query. It's a bit crazy.
-
Castronova's paper on whether the Law of Demand, as it works in the real world, also works in the virtual.
-
Ryan North makes a little poem dedicated to the COALESCE function in MySQL. He's right: it's super useful.
-
"Local devs, running local services, but how to share with everyone in the room?" Answer: rebuild all your tools to work across Bonjour. Slightly bonkers but very cool.
-
"When we assembled a focus group of Xbox Live players, they immediately asked for one feature we hadn’t even considered – in-depth tracking of the groin area, for post-kill celebrations. We were proud to help them find a new revolutionary way to teabag – and believe me, these ain’t no waggle controls." Hardcasual goes for the soft targets, as usual. Ahehe.
-
Seriously, Harmonix' character design is just amazing, and this movie – just the _intro_ movie to Beatles Rockband – is making me care more about that band than anything in my life has. Harmonix are gods.
-
"The first viewings of Dante's Inferno suggest the action adventure will be very similar to God of War… enemies can be smashed into the air and juggled around using simple combos that mix light and heavy attacks. Magical abilities will also feature, and fallen enemies will spill health and magic orbs that replenish respective status bars." Oh Jesus, please make it stop.
-
The reason CakePHP has issues connecting to MySQL database on OSX 10.5 is because its database adaptor is explicitly looking for the default mysql socket defined in your php.ini. If you fix that, everything works. The critical adjective, if you ever search for this again, is the "OSX" part.
-
You're a little robot. You're also indestructible. Use bombs to bounce yourself around the level, but don't run out. Lovely little flash game.
-
In which an entertaining man plays a hacked, super-hard Super Mario map, swears at his TV a lot, and still manages to be pretty good at it. It's a nice illustration of the problem-solving process, and it's rather funny. "This is worse than Panic At The Disco. This is worse than Ann Coulter."
-
"The No Game is a party game with only one real rule."
-
This looks like it could be interesting/fun; if anything, worth watching as a slightly more attractive option for lifestreaming…
-
"Sequel Pro is the perfect tool for working with database-driven websites and applications." Leopard-only MySQL management application; forked out of the long-neglected CocoaMySQL.
-
I need to think on this more; there's a lot of meat in it, and some interesting commentary, but suggesting that "the entire bachelor’s degree in English is all about bullshitting things" I find somewhat insulting. I'm frustrated because it feels like Blow is pushing for people to find the "correct" interpretation, rather than any valid criticism they can back up. Still, there's also some excellent stuff in here, but it's the first thing he's said that's rubbed me the wrong way a little (and I'm not just talking about the 'bullshit' comment).
-
WikkaWiki is a flexible, standards-compliant and lightweight wiki engine∞ written in PHP, which uses MySQL to store pages. Forked from WakkaWiki. Designed for speed, extensibility, and security. Released under the GPL license.
-
"The Morning After is a magazine-style theme for WordPress created by Arun Kale. The theme was created based on a brief survey on the WordPress forums about what people would want to see in a unique magazine-style theme." Looks great.
-
Now that's what I call a UI. Nice idea!
-
"Are you tired of browser-based games that are thinly veiled interfaces for databases? Finally, there's a game that just is a database!" This looks awesome.
-
"A simple pocket knife can be more appealing and usable than a bristling Victorinox, and a dedicated little games machine like the DS can engage us far more than the sleek power of the PSP. You can feel admiration and even awe for the big power boxes, but for the DS you feel affection – and that, in marketing terms, is worth a whole heap more." I love Stephen Fry.
One thing I usually forget to do when I backup a computer is back up my MySQL databases. Partly, because they’re not stored in my Library (I don’t think); partly because I forget how many I have. mysqldump only backs up one database at a time, unfortunately. What would be great is something that dumps all of the databases in the system.
Anyhow, whilst on hold to my ISP this morning, I decided to solve this problem once and for all.
The end result is a pair of Ruby scripts which you can get from github.
The first will iterate over every db on your system (when run with an appropriate username and password) and spit out a .sql file with a filename corresponding to that database. The second look at a folder of .sql files named similarly, and for each one, drop a databases with that name, re-create it, and restore from the .sql file.
I’m sure I could do it just fine in a bash script, but it made sense to use the tool that comes most quickly to my hands, and that means Ruby. Once you’ve got Ruby installed, the rest is easy. Clone them, patch them, fix them; they’re basic, as maintenance goes, but handy.