Remember this post regarding the trainwreck that is the NHS National Programme for IT? In it, we discussed the institutional factors that made it a trainwreck, and specifically the way demands for commercial secrecy made it impossible to involve the users in designing the system.
Well, now there's a discussion at Kevin Drum's about how the US Veterans' Administration got a really good patient information system. It turns out they asked the users, then rolled their own. Not just that, but they kept asking the users.
There's loads of information here; so if you're a techie you can add DHCP to your mental list of confusable multiletter acronyms. As well as the Dynamic Host Configuration Protocol, it's also the Decentralised Hospital Computer Program. More importantly, you may recall I queried the need for the NPfIT's structure of local, regional and national systems on the basis that, as it also required common standards for information exchange, that meant the local systems should be able to intercommunicate without needing the extra layers. Here is a whole working example of such standards.
Further, there's a standard RPC interface to lash your applications to the database, with details of the SDK here, and guess what? It's all open source and completely free. And guess what? A bunch of Finnish hospital sysadmins built a graphical frontend for it, which is soon to be ported to Java. Or you can use Visual Basic and SQL. Python is surely not far off:-)
Seriously, I've just read through this stuff and it's just desperately cool; and nobody, literally nobody, in the UK has even mentioned it with regard to the NHS Monster Database. Despite successive Health Secretaries' much-hyped efforts to find out "what the Americans are doing", which has involved various more or less horrible forms of backdoor privatisation, they don't seem to be aware that a bunch of civil servants built a cracking healthcare data system - and it's FREE.