Resources from

REDWrap

No Comments

Updated 9/11/20 REDWrap is a free utility for converting REDCap data exports to a normalized relational data format. It runs in Microsoft Access and converts the flat-file REDCap export into Access tables, created with a more logical (normalized) structure. It’s available in version 1.11. Download here. Requirements Since REDWrap uses Microsoft Access, it can only… (read more)

mySQL: on duplicate key update

No Comments

mySQL has a proprietary extension to the “insert” statement which is really handy in certain situations. It’s called ON DUPLICATE KEY UPDATE. If you want to update a table from a similar table, when there are possible duplicates, it updates just the way you’d want. For example. Take a simple table “test” with five records:… (read more)

Safe end-user querying for Access

No Comments

When developing a new database, smart practice is to start from the reports and work backwards from there. It’s easy to get excited about all the interesting data that we want to put into the thing. But at the end of the day, what really matters is the data that somebody, someday, will need to… (read more)

Paper! (with an SVG gauge from QS)

No Comments

Just found out that I was named as a co-author on a new paper, published in the online journal Cureus in January: A Web-based Decision Tool to Estimate Subarachnoid Hemorrhage Risk in Emergency Department Patients This “web-based decision tool” was an online calculator that I built to the specifications of Dr. Prasanthi Govindarajan of Stanford… (read more)