Pulling Election Count data out of Google Sheets for fun and democracy

Messing around with Elections NI data Sources: Live Data (for 2023) 2022 Assembly Elections Creating your own Google Sheet and referencing the crowdsourced data The above linked spreadsheets are naturally not editable by everyone; this is great for reliable data but isn’t so great when you want to make pretty graphs. Google Sheets supports the live referencing of external sheets in your own sheets, so you can ‘import’ the data from the read-only sheets as they evolve over the count, and then reference those data in your own visualisations. ...

May 18, 2023 · Andrew Bolster

UUIDs and You

The guts of this document was originally created as part of my work at NTT Application Security stripped of its specificity and retained for my own reference. Background Entities need to be identifiable, but the existence of entities should not be predictible, and it should not be easy for an external user/attacker to infer anything about the number of or presence of entities. Conventional auto-increment integer ID’s were historically de-rigeur for (now largely spurious) database performance optimisation reasons, however, they are succeptible to both presence estimation, and scale estimation. ...

November 10, 2021 · Andrew Bolster

Python + Oauth2 for Twitter Status Updates

Working on the Farset Labs Big Red Button for space occupancy, had to find a simple way to tweet a status. This is a post to remind myself and anyone else who has dived through hundreds of incorrect, out of date, or inapplicable examples of Oauth 2 with Twitter using a pre-generated auth-token pair. import oauth2 as oauth import urllib ckey='$CONSUMER_KEY' csecret='$CONSUMER_SECRET' akey='$AUTH_TOKEN' asecret='$AUTH_SECRET' def post_twitter(status): try: consumer = oauth.Consumer(key=ckey, secret=csecret) token = oauth.Token(key=akey, secret=asecret) client = oauth.Client(consumer, token) resp, content = client.request( postapi, method='POST', body = urllib.urlencode({"status": status, "wrap_links": True}), #headers=http_headers, #force_auth_header=True ) except oauth.Error as err: print("Twitter Error:"+err) return resp, content post_twitter("Hello Twitterverse")

April 10, 2012 · Andrew Bolster

Coming Soon!

EDIT - 2017 Updated broken links thanks to heads up from Paul @ Art of Blog Ok, its been a busy few weeks, and I’ve let the blog slip again, but coming up: Implementing Google Webfonts Ubuntu Dot-File Dropbox Synchronisation Drupal 6 Installation of Ubuntu 10.04 My Revision Scheduling/Tracking System Summer Plans including VPN work for Dr David Laverty and CUDA research with Alastair Mckinley and Dr Alan Marshall

May 20, 2010 · Andrew Bolster

Add a Twitter @anywhere hovercard to links containing tweeps

Everyone and their dog has a walkthrough of adding @anywhere hovercards to your blog. But the default has a small failing that irked me when I was re-doing my Blogroll (check them out, they’re all great! I promise!), and that was that if you take a tweep, like @god for example, it’ll happily wrap the hovercard around it, but if you have a link to this great status that @god posted, @anywhere won’t pick this @god up. ...

April 17, 2010 · Andrew Bolster

Shared Items - 31/03/2010

NumberQuotes Gives Perspective to Your Statistics, Is Great for Presentations [Statistics] The Menaissance: The Death of the Metrosexual and the Rise of the Retrosexual Jesus Loves Me? World’s Most Stunning Data Centers Jason takes us through exploit a web application, uploading a… IF YOU DON’T STUDY Recursively remove all empty directories Top 10 Atheism Quotes Dynamic lighting effects in Canvas Digg: 4000% Performance Increase by Sorting in PHP Rather than MySQL ...

March 31, 2010 · Andrew Bolster

Shared Items - 10/03/2010

Wireshark Remote Capturing Google Code University - New Content Added! Statistics for a changing world: Google Public Data Explorer in Labs New OK Go’s Music Video Features Awesome Rube Goldberg Machine

March 10, 2010 · Andrew Bolster

Shared Items - 13/01/2010

ChromiumOS Zero Boots Faster, Offers Automatic Updates [Updates] 11/01/2010 Make Your Mockup in Markup 24/12/2009 10 Innovative Ways To Use Twitter For Business 09/01/2010 6 Digital Photography Websites With Free Tutorials 08/01/2010 Use Better Tools to Be a Better Student in 2010 [Students] 06/01/2010 Doing It Wrong 02/01/2010 Terrorball 04/01/2010

January 13, 2010 · Andrew Bolster

The Making of a Timelapse

Starting in May 2012 (a few weeks after we ‘opened’) I set up an eventcam in Farset Labs, and I don’t think I ever officially explained it… Well, first off we were using a Microsoft Lifecam that was kindly donated by Josh Holmes. This was wired up to an even-then-ancient Asus Eee 7001, wired with power and network, and left in the roof. That was about it. The Linux motion utility was used to drive the camera and after fiddling with motion’s many many options, I settled on this config file to strike a balance between dropping boring frames when nothing was happening but to also maintain ‘day night’ cycle more or less realistically. ...

Andrew Bolster