In case anyone is looking for a SocketHandler client written in PHP to do some light testing with, I’ve written one and made it available
-
Home > MySQL
Category Archives: MySQL
php open locking daemon
Monday, September 14th, 2009
Don’t you hate that… When it’s 2:00am… and you really should be in bed… But your mind has hold of a problem, and wont let it go. I have a project where it would be really handy for a process to be able to lock (arbitrary string identifier) and for another process to be able [...]
Bigger Aint Always Better
Monday, June 15th, 2009
Recently I was troubleshooting some inefficiencies with the jobs systems locking and fetching queries at work. Like a good little boy I, originally, came up with one index which satisfied all the queries that I needed to run against this particular critical table. (`completed`,`heartbeat`,`priority`,`datacenter`,`worker`) — datetime,datetime,tinyint,varchar(16),varchar(255) the query looked like this: SELECT `id`,GET_LOCK(CONCAT(‘foo_’,`id`),0) as mylock [...]
Just what you need to know to write a CouchDB reduce function
Wednesday, February 18th, 2009
Lets say you have the CouchDB classes (located here) all compiled together and included into your test.php script. Lets also say that you have created a database with the built-in web ui called “testing”. Finally let us say that your test.php has the following code in it, which would add a record to the db [...]
a dumbed down version of wpdb for sqlite
Tuesday, November 18th, 2008
I’ve been working, gradually, on a project using an sqlite3 database (for its convenience) and found myself missing the clean elegance of wpdb… so I implemented it. It was actually really easy to do, and I figured I would throw it up here for anyone else wishing to use it. The functionality that I build [...]
Writing your own shell in php
Sunday, August 3rd, 2008
I’ve always wanted to write my own simple shell in php. Call me a glutin for punishment, but it seems like something that a lot of people could use to be able to do… If your web app had a command line interface for various things… like looking up stats, or users, or suspending naughty [...]
so-you-wanna-see-an-image
Wednesday, October 10th, 2007
We’ve been asked how we manage serving files from Amazons very cool S3 service at WordPress.com… This is how. (covering a requested image already stored on S3, not the upload -> s3 process) A request comes into pound for a file. Pound hashes the hostname (via a custom patch which we have not, but may, [...]
I have to say
Saturday, October 6th, 2007
this is amazing: http://jan.kneschke.de/2007/10/7/wormhole-index-reads and I cant wait to try it somewhere!
PHP CLI Status Indicator
Monday, May 21st, 2007
Most times when people write command line scripts they just let the output flow down the screen as a status indicator, or just figure “it’s done when it’s done” But sometimes it would be nice to have a simple clean status indicator, allowing you to monitor progress and gauge time-to-completion. This is actually very easy [...]
Any… good… php devs out there looking for some side work?
Thursday, May 17th, 2007
I know a group of guys looking to do some cool stuff who could use a few good contractors. Drop me an e-mail with maybe a sample or something cool you did in php and I’ll pass it on. apokalyptik apokalyptik com — Subject: “PHP Consulting” (I’ll likely completely overlook your mail if you use [...]