SQLite3 databases get messy over time (especially if there’s churn on the database).
I’ve noticed that “vacuuming” them from time to time can speed up searching in Squeezebox Center… so I have the following cron job (as root):
file /var/lib/squeezeboxserver/cache/*.db | grep SQLite | cut -d: -f 1 | xargs -I % sqlite3 % vacuum
Hope that helps 🙂
We have a scanner with a document feeder (Officejet Pro 8500 A910), which is really useful, but it can’t deal with double sided documents… which is annoying 🙂
This perl script takes two PDF files created by first scanning the front pages (odd) in the correct order and then the back pages (even) in reverse order. This means that you don’t need to re-order the real pages, you just scan them face up then, when they’re done, turn the whole stack over and scan them again.
Seems to work a treat 🙂
Having been collecting river levels for various rivers for a few weeks via Munin, I thought I’d make a specific graph watching Canterbury. Luckily there are stations just upstream and just downstream of Canterbury on the Great Stour!
Isolating just these two datasets and plotting them results in:
Recently I’ve made available two little mini-projects…
If you find either of these useful and would like more motorways or rivers added, please let me know!
This morning I published (two) Wordles based on the content of my Twitter timeline for 2011 which I’ve been archiving to a SQLite database since July 2010.
- Export tweets
- Process into words
- Count word frequency
- Upload to Wordle
Wordle accepts data input in the form:
First output was:
This was a little skewed towards the various travel and weather related feeds I follow (@SEtrafficnews, @nationalrailenq, @NRE_SEastern, @SEplaying, @KentWeatherObs) so I then excluded them…
And finally… a Wordle of my
Two and a bit months ago, I started archiving my friends timeline on Twitter into a SQLite database for posterity (I didn’t really like the idea that it just vanishes after a while).
It then occurred to me earlier that I didn’t actually know how many tweets I read in two months… the answer appears to be over 40,000.
Posting this fact on twitter, the first reply I got was “how many are about sandwiches?” to which the answer is 39. Wow. What wonders 🙂
I thought about the only useful thing I could probably do in the short term was make a pretty graph of the rate of tweet flying past my friends timeline per day… so here it is:
Other interesting facts:
- @TelegraphNews accounts for 6% of the throughput
- 62 tweets contain the word “argh”
- 350 mentioned “facebook”
I may get around to thinking up new and more interesting stuff to do with this data later… maybe 🙂
Today, the VOSA released data pertaining to a Freedom of Information request from the BBC detailing the rates and reasons for vehicles failing the MOT Test in the UK
There’s a rather interesting report on the content of the data on the BBC news site but the only way to download the data is as a PDF from VOSA or as a Excel spreadsheet from the BBC. Both of these are not very parseable so I’ve converted them into a CSV and a MySQL dump file.
These files are not small… it’s over 12,600 rows in the following format:
- make varchar
- model varchar
- year int
- passes int
- failures int
- failrate float
- body int
- brakes int
- driverview int
- emissions int
- lights int
- identity int
- wheels int
- belts int
- steering int
- suspension int
- tyres int
- othercycles int
- controls int
- nottested int
The data is public, and the following files are released under the Creative Commons licence (see below for more info).
The two files available are:
I would be interested to hear of any interesting uses for this data, please feel free to comment below or let me know via Twitter (@fooflington)
Reworking of VOSA FoI data about MOT Test failures by Matthew Slowe is licensed under a Creative Commons Attribution-Share Alike 2.0 UK: England & Wales License.
Based on a work at www.vosa.gov.uk.
They’re at it again. When will they learn that people (well, some people) will not roll over and let their civil liberties in a “free nation” be eroded away?
Sent to my MP today:
Dear Julian Brazier,
My apologies for taking up yet more of your time, however our
Government seem to be leaving me little choice but to do so. I wish to
draw your attention to a story breaking in the Daily Telegraph today
(Saturday 14th March, 2009) regarding so called “e-borders”.
This would seem to be, if accurate (and I can find no cited references
to active or pending legislation), a HUGE step into the surveillance
culture which campaigns such as NO2ID are opposing and trying to publicise.
I don’t know if it is “too late” to do anything about this but, even if
it is, I would ask why this is necessary (to fight international
terrorism?!) and how it will help… surely the checking of persons on
“watch lists” can be done without the need for such a tracking database
of the general public at point of entry/exit.
What will be next? Will travelling outside your county (or perhaps into
London on a “sensitive” day) require written permission from a
bureaucrat before you’re allowed on a train?
This yet another appalling regime being apparently pushed in sideways
hoping law abiding citizens will roll-over and take it without any
question. I don’t have anything to hide about my whereabouts, but I
find the whole idea of registering my movements with an agency and
having that retained for a decade disgusting.
Once again, I’m sorry to have taken up your time but this is an issue
which is often overlooked and needs more attention.
He’s usually quite good about replying to emails so I will await the response…
Yesterday I made something new (for me, anyway) as a kind of experiment (I seem to have been doing this a bit recently) with some Lamb’s Heart (this comes in nice and cheap as people don’t tend to want to buy something they can identify… usually about Â£1.50 for three which is enough for 2-3 people depending on how it’s cooked).
- 3 Lamb’s Hearts
- ~1 glass of White Wine
- 2 cloves of Garlic (chopped)
- Olive Oil (infused with garlic?)
- 1 Lamb Stock Cube made up with 8fl oz of water
- Rosemary to taste
- Black Pepper to taste
- 1 tsp Lemon Juice
I started by trimming off the top of the hearts as they tend to be quite fatty and the arteries/veins are quite chewy, then diced the remainder.
Warm the oil in a frying pan (medium heat) with the garlic until the garlic starts to turn brown then drop in the heart and allow that to brown for 5-10 minutes.
Add the wine and lamb stock and allow to reduce for about 15 minutes — the juice should start to thicken slightly. About 5 minutes before serving, add the lemon juice.
Serve with mashed potato and vegetables.
Last week, we spent some very damp days near Poolewe in the Highlands of Scotland. There is plenty of picture evidence available here.
The week went, more or less, thus:
- Friday night: Drive from the Deep South to Inverness via Tebey and Stirling — the A9 is a fantastic road at 2am
- Arrive at Inverness at about 0700 Saturday after a nap near Dalwhinney and catch a train to the Kyle of Lochalsh (because we can).
- Conclude drive to cottage and unpack
- Go for an extremely soggy walk around Inverewe Gardens (nearby National Trust for Scotland property with lovely trees etc).
- Sarah and her Dad went to attempt a walk over the hills behind our cottage to Rubha Reidh lighthouse … but were forced to abandon this due to encountering a 4″ deep river which the buggy was thwarted by… so, instead, we drove 🙂 Once there, we found the old supply jetty for the lighthouse complete with former railway for whinching the supplies up the steep incline (with kart and whinch in the gorge below).
- A trip out to the other side of Loch Ewe to see a tiny distillery and while going there found a small NATO navy base… which initially dates from when the loch was using extensively during WW2 by the Navy with a lot of the old emplacements still evident.
- We left after lunch on Friday having seen the surrounding hills covered in snow overnight to drive back during the day to see the landscape.
On the Sunday, we received a phone call to say that Mum had been taken into hospital suffering with what turned out to be a stroke hense leaving a bit earlier than we would otherwise have done.
She’s doing really well, having been transferred to Addenbrookes (Cambridge) a few days after it happend near Enfield. Having intially been unable to move her left side or talk at all, she’s now making reasonable sentences (while still struggling with remembering some words) and, although having issues with sensation, able to mostly move but is still quite weak and gets very tired easlily.
We’re taking Benji in to see her as much as possible 🙂