Andrew PlatkininReviewTrackers Engineering, Product and Design BlogRefactoring slow code using instrumentationA few weeks ago, we started seeing a series of timed out requests against our Amplify service in production. This service is responsible…Jun 8, 2020Jun 8, 2020
Andrew PlatkininReviewTrackers Engineering, Product and Design BlogTaming our Postgres IO problem with a Materialized ViewUsing a materialized view and change in process to drastically speed up performance of an important serviceNov 25, 2019Nov 25, 2019
Andrew PlatkininReviewTrackers Engineering, Product and Design BlogScaling an API endpoint that hits 100 million rowsTLDR: How we increased the performance of our slowest API endpoint that hits our largest table by over 95%.Oct 7, 20191Oct 7, 20191
Andrew PlatkininReviewTrackers Engineering, Product and Design BlogCustom built request caching in RubyTLDR: Building out a caching layer for a new Ruby application that was able to keep our avg load time around 1ms when scaling to 500…Dec 20, 2018Dec 20, 2018
Andrew PlatkininReviewTrackers Engineering, Product and Design BlogReviewTrackers’ Hackathon: Part 1One of our Senior Engineers, Yohei, had the great idea of putting a Hackathon together. The rules were pretty simple.Apr 29, 2018Apr 29, 2018
Andrew PlatkinFrom iOS Native to React NativeI recently built a cross-platform app in React Native to gain some experience with the technology and to see how it stacks up to a fully…Dec 25, 2017Dec 25, 2017
Andrew PlatkininReviewTrackers Engineering, Product and Design BlogIndexes are your friendWhen building out your backend, it’s really easy to forget indexes for your database. Indexes make retrieval of data for your various use…Dec 15, 2017Dec 15, 2017
Andrew PlatkininReviewTrackers Engineering, Product and Design BlogReal-Time Data Warehousing in Production ApplicationsThough Data Warehousing has been used since the late 80’s, it still has many valid use cases in modern web applications. At ReviewTrackers…Oct 12, 2017Oct 12, 2017
Andrew PlatkininReviewTrackers Engineering, Product and Design BlogSpeeding up our API with RedisWhen we released the second version of our API, we didn’t include any caching at the application level.Aug 30, 2017Aug 30, 2017
Andrew PlatkinSMS AuthenticationIntegration SMS based authentication in a mobile app flowFeb 11, 2017Feb 11, 2017