Medical Nerds Blog Logo

technology, stats and IT for medics


Entries from March 2010

Invaders Internet explorer 6 must die

March 23rd, 2010 by Mark · 3 Comments

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!

[

Tags: Uncategorized

Finding rows in one table not present in another table with PostgreSQL

March 6th, 2010 by Mark · 2 Comments

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 […]

[

Tags: Databases

Executing raw SQL with WebObjects and Project Wonder

March 6th, 2010 by Mark · No Comments

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.

[

Tags: WebObjects

Recursive SQL with PostgreSQL 8.4

March 4th, 2010 by Mark · 1 Comment

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 […]

[

Tags: Databases · Medical

More posts

March 4th, 2010 by Mark · 1 Comment

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! (1) Completed his MD in 2008 (2) This is not necessarily […]

[

Tags: Medical · Research