database

When working with Amazon’s Redshift for the first time, it doesn’t take long to realize it’s different from other relational databases. You have new options like COPY and UNLOAD, and you lose familiar helpers like key constraints. You can work faster with larger sets of data than you ever could…

At Lucid, we deal with data—a LOT of it. Ever since we migrated our code to the Play! Framework, we’ve been leveraging the Anorm database access library provided by the framework. Being able to write our own SQL queries gave us a lot more control than using an ORM, and…

For months now, the business team at Lucidchart has been overhearing discussions of “sharding” from the other end of the office. As a curious tech geek, I wanted to know what was going on. I ended up cornering Brian Pugh, VP of Engineering, and Matthew Barlocker, Chief Architect, to interrogate…