medicalnerds.com

A quick update to my previous post Batch converting PDF to JPG/JPEG using free software about converting multiple files. [Read more →]

A short post. Apache Lucene is amazing - I was faced with slow full text searches searching >1.6 million SNOMED CT descriptions using PostgreSQL’s built in full-text search. Apache Lucene performs these searches in microseconds - I rapidly turn the list of concept Ids into full enterprise objects and my work is done!

Please check out Apache Lucene….

Repeat after me:


while (1) {
System.out.println("Internet explorer 6 must die");
}


Why is internet explorer so ubiquitous across all NHS organisations?

I’m currently fighting CSS, javascript and graphics transparency problems…. ARRRRGHHHHHHH!

In implementing a comprehensive SNOMED CT browser as part of a research clinical information system, I cache the results of several processor and disk-intensive queries to speed up lookup and SNOMED CT navigation. I was finding some odd results and found that my caching was missing for several items. I needed a way of comparing the contents of one table with another in PostgreSQL and finding out which rows were not present. [Read more →]

WebObjects is an extraordinarily powerful java based web-application server. On occasions, I need to execute arbitrary SQL against the underlying database. This is not necessary for most uses, but for certain batch operations it is useful. [Read more →]

Representing hierarchical data in a relational database is easy. For instance, modelling the contents of a filesystem with directories and subdirectories is straightforward using self-joins on a parent key. The root node(s) are represented as those without a parent. Such a model is useful for modelling other types of data - in particular, hierarchies in which nodes can have multiple parents - for example, SNOMED CT is a hierarchical clinical terminology - the “Systematised Nomenclature of Medicine Clinical Terms”. The Connecting for Health website suggests this terminology is in widespread use by “all computers” in the NHS (website accessed 4th March 2010) but as those of us who work in the NHS will testify, this is not the case. [Read more →]

After a long hiatus while we both finish our theses (one of us [1] more successfully than the other) and obtain substantive posts (one of us [2] more successfully than the other), we are keen to restart regular nerdy medical technology posts.

Welcome back!

If you are a healthcare professional you have a duty to maintain the security of patient identifiable data. Within your job you sometimes need to use a USB key to transfer lists or letters between computers. If you lose your un-encrypted USB key with patient identifiable data then it may deemed negligent and you may face disciplinary action. In this how-to I will talk through how to setup an easy to use secure software encryption scheme for a USB stick/key for use with Windows. [Read more →]

Windows has had built in zip file support with encryption since Windows XP, unfortunately the quality of this encryption is poor as evidenced by the number of commercial programmes available to crack it. Winzip, WinRAR are trialware commercial programs that offer secure AES encryption to your compressed files but cost between 23 and 30 Euros per user. 7-Zip is an open-source, free utility that offers AES-256bit encryption. In this how-to I will show you how to install and produce 256-bit encryption of your compressed files. [Read more →]

Foxit PDF Reader is a free closed source alternative to Adobe’s PDF reader. On older machines it feels snappier than using Adobe’s bloated product. In this short how-to I will show you how to fill in forms using Foxit Reader with the 39 US$ Pro-Pack. [Read more →]