Debugging Adventures #2: Memory Leaks In Database
Debugging a prod issue where we had a memory leak in RDS
Oct 20, 20233 min read605
Command Palette
Search for a command to run...
#postgresql
Articles tagged with #postgresql
Faster JSON generation using PostgreSQL
What? There are a lot of ways to generate JSON in rails, from the inbuilt to_json to gems like jbuilder gem or active model serializer. But as responses and data grow in size JSON generation can become a bottleneck for many backend services. In this ...
Mar 12, 20232 min read378
Store accessor for nested JSON in Rails
Today we will look at a handy Rails tool called store_accessor. store_accessor can be used with PostgreSQL(hstore/jsonb), or MySQL (5.7+ json) to directly access your data without clogging your models. It also allows us to use dirty methods on these ...
Mar 11, 20231 min read2.2K
Cat Driven Development: Working with JSONB in PostgreSQL (#2)
Context Following my Purrsuit of optimization method a few days ago I noticed a very slow api on New Relic at , it was our one of the slowest due as per the time taken by the database transcations in it, with an avg response time of just above 3.5s a...
Dec 21, 20215 min read20
TIL #1 : How to pluck jsonb fileds in Rails
If you have a jsonb field in your Active record object and you want some nested value you can use pluck Example: Lets say your Users model has a jsonb attribuite metadata which has a nested key location which in turn has city you can get the value of...
Sep 6, 20211 min read83