Articles on postgres

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

Christian Nelson

Christian Nelson

Raygun: Hit the Ground Running When You Start Your Next Project

We start new Rails projects all the time, for client, side and internal projects. Each time we do the dance to get things just the way we like them. You probably have a similar process: switch the view library, set the database, use rspec, tweak this and that, etc. Even when you do it all