Blockchain isn’t the answer?

It is important to remember that there are problems for which blockchains are not the correct answer.

Posted in General | Leave a comment

Tags and Taxonomies

When tagging documents with keywords, sometimes too many keywords is as bad as too few.

If you have too few, the document might not be found.

If you have too many, the document will be found every time; even if it isn’t relevant.


Posted in General | Leave a comment

Another unbelievable truck advert

Following from the entirely unbelievable but true Epic Split truck advert with Jean-Claude Van Damme,

Scania has offered a new ad, building a working clock using trucks.

I love all of these ads, I really do. But I’m not in the market for a truck. ūüôĀ

Posted in General | Leave a comment

Birkhill Fireclay Museum Closed

Sadly it seems that the Birkhill fireclay mine has been permanently closed as a visitor attraction. I was lucky enough to go round the mine tour a few years ago when it was still open and it was a fascinating visit.

The mine had been in operation from the 18th century before closing about 1980. The fire clay that was mined there was made into bricks for use in furnaces, the bricks being particularly suited for the high temperatures involved.

Unfortunately the mine was permanently closed in 2013, after an extended temporary closure. The closure has been blamed on the high costs of maintenance and the poor state of the buildings. I also suspect that the income from visitors couldn’t hope to cover the costs of operating the place, since several people were needed to give guided tours.

So I got to see something that others probably won’t, which is sad.

Posted in General | Leave a comment

SQLEditor javascript plugins

There is some new sample code for writing javascript plugins on our shiny new organisation github page:

Posted in SQLEditor | Leave a comment

SQLEditor 3.0 release

SQLEditor 3.0 is ready!

I’ve feel like I’ve been working on this for ages, so I’m really happy that it’s now ready.

The most visible change is the new user interface, which has been merged into a single window. Single window interfaces are something that I wasn’t initially convinced by, I liked palettes and life was good. But since then, I’ve come to see the benefits of the single window. Keeping the panels in a relatively fixed position means that you know where they are. There’s also less busy-work managing the panels.

The tradeoff is obviously that it’s less flexible and on a large screen it can lead to more and larger¬†mouse¬†movements. Feedback has generally been good on this, I don’t think there have been any complaints (so far). If you have an opinion on this please do send in comments!

For me the most interesting new feature is the Javascript plugin system. Export dialects can now be written in Javascript. You can even edit them while SQLEditor is running and see the results immediately.

The new plugin system¬†grew out of the report generating code¬†(also new in 3.0) which was targeting html and using a javascript template language. But then I started looking at this code and realised that there was no reason that export dialects couldn’t be in Javascript as well. The difference between a report and an export is minimal. Both take a data structure and return a string (or possibly a file).

So far all of the built in dialects use native code, but my eventual plan is to convert them to javascript too.

Early code for my own javascript version of the SQLite dialect is already up on Github and further progress is planned for this.

There are lots of other improvements in SQLEditor 3 and I hope to write further about them soon.

Or see for yourself ūüôā

SQLEditor 3 Download (58MB zip)



Posted in Macintosh, SQLEditor, Writing Software | Leave a comment

Raspberry Pi Zero

The new Raspberry Pi Zero looks amazing!

Base price is just £4!

Sure you have to add stuff like an SD card, a screen and a keyboard. But these can be shared, or borrowed or obtained second hand from somewhere if necessary.

Almost anyone can get one of these and starting building stuff.

It’s going to to be great. ūüôā


Posted in General | Leave a comment

SVG Explanations

Working on SQLEditor SVG improvements (arriving soon in 3.0), and found this excellent series of articles by Sara Soueidnn on several of the details.

So SQLEditor in future will be using the same object icons in SVG as are drawn in the main document and each will be its own beautiful SVG symbol, rather than being separately drawn.

(Object icons in SQLEditor 3 are now little images rather than being individually, because this improves performance quite noticeably and allows nicer styling)

Posted in SQLEditor | Leave a comment

Apple Developer Program improvements

Apple has made some big changes to their developer programs, which I think are a big improvement:

1) You can now apparently develop and deploy to your own iOS¬†device without a program membership. (Possibly only with Xcode 7, I’m not perfectly clear yet). This is a big win for casual developers and people just getting started.

2) There is now a single developer program combining iOS and OS X which is much simpler and cuts the price in half if you subscribe to both

3) The safari extension program is being merged in. This possibly isn’t so great if you were solely doing safari extensions, because now you may need to pay. But if you are doing other development anyway, then it’s a simplified approach (only one program to deal with and remember to renew)

Overall big changes and a strong improvement in most areas.

I’m also hopeful about the new OS versions too.


Posted in General, Macintosh, Writing Software | Leave a comment

New Bujold Book!

Wonderful news: Lois McMaster Bujold, one of my favourite authors, has announced a new novel, due sometime in 2016.

If you haven’t read Bujold, I strongly recommend going out, getting a copy of one of them and reading it right now (or you know, when the bookstore or library are next open)

The title will apparently be Gentleman Jole and the Red Queen.

Author Blog Link

Posted in books | Leave a comment

Updating wordpress plugins via svn:externals

WordPress usually needs plugins for things, but it’s a pain keeping them updated, unless you want to use the built in auto-updating (which I don’t use for various reasons)

That was until I discovered this method of using svn:externals to update them.[]

cd public_html/wp-content/
svn propedit svn:externals plugins
<edit as required>
svn update

By adding third party plugins to the plugins directory svn:externals list, they all get updated at the same time as I update the wordpress install, which I already use subversion for anyway. The akismet plugin already gets updated by this method. It also allows changes to the version of the akismet plugin, which is good if it gets updated between major WordPress releases.

Posted in General | Leave a comment

MOD releasing open source stuff

MoD releases code to GitHub

Well done to the¬†Defence Science and Technology Laboratory at the UK ministry of Defence. They’ve started to release code on github.

I can’t imagine that getting approval for this was easy, and¬†it probably required a fair amount of negotiation to get¬†this far; but it’s a good sign for openness in government and hopefully it will be a good thing for¬†both the government and the wider community.

Given that governments aren’t trying to make money selling software, open source seems an excellent fit. Hopefully we’ll see more stuff from them. (I imagine¬†not the classified things though!)

Posted in General | Leave a comment

Prison Architect

I’ve been playing Prison Architect recently, having picked it up in a¬†Humble Bundle deal.

Interesting idea and great fun. Plus not so lifelike that I would be uncomfortable playing.


Posted in General | Leave a comment

Is Yosemite going to be released today?

October 16th has arrived, the Apple event is scheduled. Will this be the official release date of Yosemite? Enquiring minds want to know…

update: yes it looks like it will be

Posted in Macintosh | Leave a comment

Google XSS game

It teaches a bit about Cross-site scripting (XSS) bugs that, as the page helpfully describes, are one of the most common and dangerous types of vulnerabilities in web apps.

Worth checking, even if you think you know the material.

Posted in General | Leave a comment

Webkit Javascript Optimizing JIT compiler(s)

Is your JIT compiled javascript function running too slow?
No worries, just wait and the javascript engine will recompile it and then replace the function with a faster version!

But that’s not fast enough either?
Webkit will compile another version using more optimizations, using code from LLVM.

Is the function still executing some long running loop?
No problem! The javascript engine will copy all of the current state and build a new compiled function that starts at the beginning of that loop, then replace the old slower function with the new one, while it is still running!
It gets flipped over at the beginning of the next run through the loop.
(see the Hot-Loop Transfer section of the original article)

Just from the description, this sounds stupendously complicated. But the performance improvements are apparently quite considerable.

I’m truly impressed by the effort that goes in and the work that’s been done on this.


Read the original post for the full details:


Posted in Internet Stuff, Macintosh, Writing Software | Leave a comment

SQLEditor 2.7 – the customizable object palette

The newest and latest feature to arrive in SQLEditor 2.7 [55MB Zip] is a customizable object palette.

For a long time, the object palette in SQLEditor has looked like this:

Old Palette (pre 2.7)

There were three fixed objects, that could be dragged from the palette into the document. The images have changed, but the basic functionality is little changed from v1.0, which also had a three object palette that worked like this.

In version 2.7 though, there is a new palette, that initially looks like this:

New palette in default mode

It doesn’t look that much different at first, however it’s much more than it used to be.
The biggest change is that you can now add your own items to the palette.
To add an object, you can hold option (alt) and drag it to the palette.


SQLEditor create a new palette item, with a small preview of the objects. You can rename the item by double clicking on the label. Or delete it by right clicking and choosing delete.

You can also add palette items from the clipboard. Add items to the clipboard using the normal cut or copy commands, then click on the small gear icon in the bottom left to see a menu. The New from clipboard command adds the contents of the clipboard as a new palette item.

Or use the gear icon menu to add from the clipboard

You can the use the new palette item just like the default ones. The palette item contains a copy of the original objects, so you don’t need the original document they came from.

There are lots of possible uses for this, the obvious one is templates for tables. If you frequently create the same kinds of databases, you’re probably also creating the same kinds of tables.

For example, there always seems to be a “user” table, with a fairly similar set of columns. In the above example the user table has been added and now we can instantly create a user table in a single action that contains the four important columns in every user table:¬†unique id, first name, surname and shoe size. You can also set things like table type=INNODB, or set colors and styles (although not yet object labels).
SQLEditor will save the objects and bring it out ready for use.

You can also add groups of objects, including any relationships between them.

This feature has been on the wish-list for some time, I’m glad it’s now finished and I hope that people will like it.

SQLEditor 2.7 is available now via the in-app update system or from the website:

SQLEditor 2.7 [55MB zip, 10.6.8+]

Posted in Macintosh, SQLEditor | Leave a comment

Teddy the Guardian – a smart toy and medical sensor device

I just saw details of this new stuffed/plush toy bear that contains medical sensors, which seems absolutely wonderful as an idea.

The idea is that instead of having to persuade a child patient to put up with various medical devices and sensors (like thermometers or heart rate sensors), the child just hugs a small toy bear, which contains the sensors. The data is sent wirelessly to a computer device that the doctor can then view.

It’s a brilliant idea and I would think that anything that makes the time children spend in hospitals a little easier is a good thing.

[Via CNet Interview]

Posted in General | Leave a comment

The Journal of Cartoon Overanalyzations

For all of your cartoon analysis needs:

Posted in General | Leave a comment

SQLEditor 2.5 – now with native database drivers and process separation

I’m really happy to say that SQLEditor 2.5¬†[60MB zip]¬†has just been released. This has some interesting new features that have been in development for some time. Native database drivers have been something I’ve been hoping to support for ages, while process separation should improve stability and performance.

Native database drivers

SQLEditor 2.5 now includes native database support bundled with the app.
Native drivers are bundled for SQLite (using standard sqlite), MySQL/Drizzle (using the Drizzle driver library) and Postgres (using Postgres client libraries).

The native drivers don’t use Java at all, which gives a marginal performance improvement. Although if you’re using SQLEditor in standard, graphical mode you probably won’t notice.

Native driver support means that SQLEditor should now be zero configuration for many users. Just install the app and start using it. This should be a big win, as opposed to finding, downloading and installing the JDBC drivers. It also gives a predictable and standard configuration to test, which should reduce bugs.

SQLEditor still supports JDBC drivers as before, but if you definitely don’t require them, the JDBC driver loading can be turned off entirely.
(Preferences->Database->Database Options->Enable Java (JDBC) Driver Support)

Database process separation

SQLEditor 2.5 now splits off database operations and anything involving Java into a separate process. This was primarily to provide more protection with native drivers, if they crash. However it also means that there is no Java VM running in the main process at all, which should make SQLEditor open an editable document faster from cold start. The worker thread is started, but can then load java separately, you don’t need to wait for this to happen.There is also better stability should JDBC driver discovery hang or crash, because this is running in a third process.

Overall there are more processes, but it doesn’t seem to make that much difference memory wise. Plus Chrome does something similar, so SQLEditor is in good company (or so I’m hoping).

The new version is available to download today:

SQLEditor 2.5 [60MB zip, 10.6+]

Alternatively the in-app updater should be offering the upgrade right now.

Upgrading via the in-app updater also reduces the download size, because, in many cases, it only downloads the changes between versions, rather than the whole app.
(thanks Sparkle)

I hope that you like the new release, if you have comments or wish to report a bug please do email at 

Posted in General, SQLEditor | Leave a comment