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
