Medical Nerds Blog Logo
medicalnerds.com

technology, stats and IT for medics

 

Entries from March 2010

Invaders Internet explorer 6 must die

March 23rd, 2010 by Mark · 1 Comment

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!

[Read more →]

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

[Read more →]

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.

[Read more →]

Tags: WebObjects

Recursive SQL with PostgreSQL 8.4

March 4th, 2010 by Mark · No Comments

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

[Read more →]

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 the same person

[Read more →]

Tags: Medical · Research