Articles by Matt Wean

Matt Wean

Matt Wean

Adventures in Searching with Postgres: Part 2

In part one, we looked at querying 100,000 International Statistical Classification of Diseases (ICD) code records for 3-7 character codes. In part two of three, we’ll cover full-text search of the record descriptions using Postgres and Arel.

Matt Wean

Matt Wean

Adventures in Searching with Postgres: Part 1

For a recent project, we built a live-search for over 60,000 records which used both simple pattern matching and full-text search. The records we needed to search were diagnoses that are used to assign patients to a therapy. I had never done full-text search or anything real-time with that many records, so I ended up