Andrew KaneRails, Meet Data ScienceOrganizations today have more data than ever. Predictive modeling is a powerful way to use this data to solve problems and create better…Oct 29, 2018Oct 29, 2018
Andrew KaneStrong Encryption Keys for RailsEncryption is a common way to protect sensitive data. Generating a secure key is an important part of the process.Oct 22, 20181Oct 22, 20181
Andrew KaneSecuring Database Traffic with PgBouncer and Amazon RDSSecuring database traffic inside your network can be a great step for defense in depth. It’s also a necessity for Zero Trust Networks.Nov 28, 20172Nov 28, 20172
Andrew KanePgHero 2.0 Has ArrivedIt’s been over 2 years since PgHero 1.0 was released as a performance dashboard for Postgres. Since then, a number of new features have…Aug 8, 20171Aug 8, 20171
Andrew KaneIntroducing Dexter, the Automatic Indexer for PostgresYour database knows which queries are running. It also has a pretty good idea of which indexes are best for a given query. And since…Jun 27, 20174Jun 27, 20174
Andrew Kaneintech-at-instacartBootstrapping Postgres UsersSetting up database users for an app can be challenging if you don’t do it often. Good permissions add a layer of security and minimize the…May 23, 20172May 23, 20172
Andrew KaneLarge Text Indexes in PostgresNote: This article was written for Postgres 9.6 and below. For Postgres 10+, use hash indexes instead.Oct 9, 20163Oct 9, 20163