This post covers the implementation of pgreplay-go, a tool to realistically simulate captured Postgres traffic. I'll explain why existing tools didn't fit and explain some challenges in the implementation, focusing on what I learned personally from the process.

Diving into the Postgres query planner to understand its decisions- and occasionally- its mistakes. Explore a query plan that went wrong, discovering the statistics that informed the bad decision.

R. Chatley and L. Jones, "Diggit: Automated code review via software repository mining," 2018 IEEE 25th International Conference on Software Analysis, Evolution and Reengineering (SANER), Campobasso, Italy, 2018, pp. 567-571. doi:10.1109/SANER.2018.8330261

By flagging code smells in review, diggit raises awareness of problems at a point in the development process where code can easily be changed, with an audience of devs who are immediately familiar with program context.

Today we're open sourcing Coach, a library that removes the complexity from Rails controllers. Bundle your shared behaviour into highly robust, heavily tested middlewares and rely on Coach to join them together, providing static analysis over the entire chain. Coach ensures you only require a glance to see what's being run on each controller endpoint.