Todays Tweets . . .
- have just blocked and spam reported a dozen accounts that seem to have grabbed hold of theWifes companies conference tag, bastards!! #
- RT @vero:CharityHack at PayPal on 19-20th Sept looks like a great weekend: http://bit.ly/yNtsp Still some 30 tickets going! #
- the 09/09/09 09:09.09 pic for todays #ebethchallenge (been up for 3 hours and I'm not a morning person!!) http://yfrog.com/186o5j #
- oooooooo, ouchie!! http://bit.ly/ZsqgN #
- it's nearly that Apple time again . . . time to put up or shut up, what's happening today? http://tr.im/yfRX #
- have just seen a pigeon inside the tube . . . surprised it doesn't happen more often actually! #
- at Cambridge Geek Nights listening to a talk about Yahoo Pipes #
- hmmm, probably shouldn't have started updating my phone at this time of night! #
Powered by Twitter Tools
My predictions . . .
It’s time for another Apple event, well, it will be in a couple of hours so I thought I’d put up (because it’s very difficult to shut me up) about what I think is going to be announced.
- New iPod touches with cameras are pretty much a given, particularly after an online store put up pics of it’s new cases a tad early, whoops
- iTunes 9, I think it’s about time Apple did something about helping people to organise their iPhone apps and, rumour has it, they’ve been working for a while on some sort of social integration (presumably to compete with Last.fm and Spotify. It’s probably about time Apple and iTunes got into supporting Blue-Ray discs too
- I’d be very surprised if the Beatles catalogue wasn’t made available on iTunes. Rock Band Beatles and all the new remastered CD’s are out today so why not – having said that and EMI rep earlier said it wasn’t going to happen. Smoke and mirrors??
- a new music format. Something called Cocktail has been kicking around for a while. It’s supposidly a new album format that includes lyrics, artwork and other goodies designed to encourage people to buy whole albums rather than individual tracks. Unfortunately you can probably also expect it to come DRM’d up to the eyeballs
- and they’ll probably bump up the storage on the rest of the iPod range, and maybe the Apple TV too
and what’s not happening,
- The much vaunted Apple Tablet . . . nope, no way no how. It’s just not the right time for Apple to introduce this (and I’m not really convinced they’re particularly useful anyway). I’ll eat my hat if Apple show up with this
- dropping the iPod Classic. Why?? There’s no other iPod with this amount of storage yet. Once the nano gets it’s storage above 100G for a reasonable amount of cash then you’ll see that back of this but not until
- integrated AppleTV/HDTV, lol, don’t make me laugh!
Tell me about yourself . . .
A little while ago MySQL introduced Stored Procedures thereby, in some peoples eyes, making it a ‘proper’ database (clearly a load of rubbish as it was totally fit for purpose anyway but that’s another argument).
For security reasons if you DROP a stored procedure in MySQL any grants to use it are also removed. This makes perfect sense as stored procedures can be set to run internally as a different user that the one that called it. If the GRANT wasn’t removed it would be possible to have a perfectly innocent procedure removed and, a while later a new one added that happened to have the same name (I know that this would require a deal of disorganisation but hey) that could drop the whole DB. The user who had access to the first procedure would then have access to the new one (bad times).
While it makes sense that the GRANT is removed when the stored procedure is removed it doesn’t really make sense that you can’t update stored procedures, you have to drop and recreate them, thereby losing all the grants applicable to them every time – damn annoying
The solution . . . Read more
Todays Tweets . . .
- having seen todays 26 degree forecast I'm wearing shorts to work, maybe for the last time this year? #
- (picks up card) huh . . . Advance to Chalfont & Latimer. Do not pass Paddington, do not top-up your Oyster, fair enough #morningtoncrescent #
- #morningtoncrescent hmm, would have gone with West Ruislip but with the Monument/Bank interchange still b0rkd it'll have to be Hatch End 🙂 #
- coffee or tea . . . that is the question??? #
- RT @eBeth: Ooh – native Flickr app now out for the iPhone.. (must go take a look now!) #
- forgot I'd booked beer and a curry with a colleague over from Amsterdam #pectember #FAIL #
- oopsie . . . diet go bye bye!! http://yfrog.com/0xv8vgj #
- oooooffff . . . have eaten too much, leaving the curry house now 😐 #
- goodnight Twitter (facebook) . . . going to bed now to dream that I didn't just totally blow #pectember with that curry 😐 #
- yea, ignore the tweet from half an hours ago, had a couple of things to do . . . NOW I'm going to bed! #
Powered by Twitter Tools
How old are you???
Everyone knows how old they are, right?? Well OK, so sometimes I have to think about it a couple of times just to check (what with it nearly being my birthday) but still, it’s pretty easy.
However if you’re a database without a function to find out age it’s a tad more tricky.
This just came up as someone in the office was writing a report that included calculating the users ages . . . the solution they used was good enough for our purposes but was also one of those little things that bugs you because you know there’s a better way to do it.
The initial solution was as follows . . . btw, let’s also chuck the date of birth into a variable to simplify the queries 😉
SET @dateOfBirth=’1972-10-03′;
SELECT (DATEDIFF(NOW(), @dateOfBirth))/365;
Todays Tweets . . .
- at end of the first week of #pectember I have lost 4lbs!! Have turned the livestrong.com dial to 2lbs a week and have lost 300 calories/day! #
- something weird going on in Cambridge, just been past the Courthouse and there are a bunch of satellite vans round the back??? #
- ah, I guess it's related to this, http://news.bbc.co.uk/1/hi/england/cambridgeshire/8241723.stm #
- have a couple of free evenings while theWife's away – am spending the first driving my in-laws to Heathrow, M25 'fun' and games approaching #
- in-laws depoited, at South Mimms for a comfort break on the way home, denying myself the usual Burger King motorway treat today #pectember #
- I should really go to bed now – gonna be wrecked at 6am tomorrow morning 🙁 #
Powered by Twitter Tools
Back for good???
I’ve finally got around to upgrading the site to the latest version of WordPress, something I should have done a long while ago but the recent security issues prompted me to finally get it done. I’d heard a variety of horror stories relating to the upgrade process but all went through without incident. Thanks should go out to Vero who I had a quick chat with before hand. Her thirty-second tid-bit, turn off all the plugins and backup, backup, backup . . . good advice at any time but especially so during an upgrade (as my ex-honeymoon photos would attest to).
There’s a lot going on at the moment so I figured I’d start chatting again on here, probably more as an extension of things I Tweet about but there you go. I wonder how long the updates will last this time 😉
Testing testing 1, 2, 3 . . .
Just wondering if I can still update a 2.6 WordPress site from the newer iPhone app????
.
.
.
and I can edit it still too 🙂
ATM’s ‘double your money’ error
ATM’s ‘double your money’ error:
Bwwaahhhaaaahaaaahaaaaaa!
Sorry but well … the Banks do everything they legally can to shaft people out of their money, charging £25 for sending letters about 1p overdrafts, hiding extortionate interest rates for credit cards inside huge maasses of small print and they claim that they’re disapointed when people don’t report an error like this – really, they’re only got themselves to blame 🙂
Pirates win music download battle
Pirates win music download battle:
I call shennigans … nay, I call bullshit!
What a surprise, the record industry that’s been ripping everyone off for years bitching that they’re not making as much money at the moment by mudslinging around unsupported ‘facts’ that show that everyone in the world over the age of 3 weeks is a criminal … Fuck off!
