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!
Entries from March 2010
Invaders Internet explorer 6 must die
March 23rd, 2010 by Mark · 3 Comments
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 […]
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 […]