Posts by Lauren Ellsworth


A short story of Bootcamp at Flatiron Health

An employee’s first few weeks at a company are critical; it’s during this time that the company sets the stage for life as an engineer at Flatiron, and the employee begins to absorb the day-to-day culture of the company. It’s also when details on both sides are laid bare. On the company’s side, anything that was perhaps glamorized or obfuscated during the interview process is suddenly readily apparent. For the...

Read more...


Uniqueness in PostgreSQL: Constraints versus Indexes

While doing a bit of database cleaning, I noticed many tables with more than a few indexes and constraints. In particular, a few tables had both a unique index and a unique constraint for the same column. Constraints and indexes come at a cost: they add write overhead with each INSERT and UPDATE and they can take up significant amounts of space. Since a unique constraint and a unique index...

Read more...