Category Archives: development

How are things going with HtmlCleaner?

HtmlCleaner is the FOSS project I’ve been maintaining since 2013. So, how is it going so far? Downloads and users I can get download stats from Sourceforge, which hosts the binaries, but perhaps a better perspective is the number of times the project … Continue reading

Posted in development, open source | Tagged | Leave a comment

Creating a simple SQL query editor

I recently needed to add a simple visual interface for building SQL queries based on existing schema models – you know the sort of thing, a bit like the UI you get in Access, but running in the browser. I really, … Continue reading

Posted in development, open source | Leave a comment

Going old skool with SQL: from Access to PostgreSQL

Well, after several years where I mostly worked on Redis, MongoDB and client-side browser storage, I’m currently working on a project that is most definitely old-skool SQL. So I spent much of today writing code to handle importing Access databases into PostgreSQL … Continue reading

Posted in development | Leave a comment

Why CKAN’s datastore_search_sql gives you a syntax error, and how to fix it

If you’re using the DataStore extension with CKAN, one of the first things you’re likely to try is to execute a SQL query on your data. However, you’ll likely see something like this: [“(ProgrammingError) syntax error at or near \”-\”\nLINE … Continue reading

Posted in development | Leave a comment

SPAWS: Impact

The SPAWS project – or rather, the funded part – is coming to an end so its time to wrap up the project details. In terms of impact, what have we achieved? 1. We answered the question we set: “is … Continue reading

Posted in widgets, development | Tagged , | Leave a comment

PHP: The Pot Noodle of software development

PHP is, despite its huge popularity, one of only a handful of web programming tools I’ve never really used in anger. And thats because, basically, I’m a programming snob. I like Java (despite its annoyances), Ruby, Python, JavaScript and a … Continue reading

Posted in development | 11 Comments

Unhosted – building web apps without servers

For some reason I never came across this before, but it seems there is something of a movement (complete with manifesto) promoting client-side-only web apps. According to the Unhosted site: By “unhosted web apps” we mean browser-based apps with no server-side backend. Unlike … Continue reading

Posted in apps, development, javascript, mashups, standards, widgets | 8 Comments

SPAWS: Lessons Learned So Far

The funded part of SPAWS is coming to a close, so its time for me to write about some of the things I’ve learned so far from working on this project. Is the LearningRegistry Node infrastructure suitable for sharing paradata … Continue reading

Posted in standards, apps, widgets, development, lessonslearnt | Tagged , | 1 Comment

SPAWS: Its all started coming together…

Another progress update on my mini project, which is about sharing paradata (user comments, stats etc) from web app stores using a distributed network store (for more info, check out this post). One of my big worries when I started … Continue reading

Posted in apps, development, open education, widgets | Tagged | 2 Comments

SPAWS meets Edukapp

After a bit of a delay (the JLERN server was having some issues) I’ve finally been able to include my user-generated info sharing library SPAWS in the white-label web app store  project Edukapp. As a first stage, each user-submitted review published … Continue reading

Posted in apps, development, widgets | Tagged | 2 Comments