Resources from
REDRightHand
What is REDRightHand? REDRightHand converts REDCap exports into tidy normalized tables, which can then be queried with any SQL-based data system. It uses REDCap’s API to pull in data and convert it with a single button-click. About REDCap REDCap is an immensely popular data management system for clinical researchers. It’s easy to use, easy to… (read more)
REDRightHand download and documentation
REDRightHand lets you download your REDCap data and convert it into tidy, normalized tables—with a single button-click. Requirements: Microsoft Windows Internet connection REDCap API key (see the installation guide) Microsoft Access 2016+ (if you’re using UCSF’s Research and Analysis Environment (RAE), this is already installed) Note: REDRightHand can download PHI (protected health information), if such… (read more)
REDRightHand is coming
Update March 2026: The free version of REDRightHand v.3.4.1 is now available for download. This is a fully-functional version of REDRightHand, except that it downloads data for a maximum of fifty participants from your REDCap project. So, if you have a very small study, or just want to see how REDRightHand works, this version should… (read more)
REDWrap
Updated 9/12/23 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.22. Download here. Requirements Since REDWrap uses Microsoft Access, it can only… (read more)
mySQL: on duplicate key update
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
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)
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)