Chandra Sekar's Blog

Connection Leak in PgBouncer Behind AWS NLB

10 May, 2020 postgresql / aws / database

At a previous job, we had several instances of Ruby on Rails applications connecting to PostgreSQL through PgBouncer. The services and databases were deployed on bare-metal servers and chugged along fine. We then decided to migrate to AWS. Upon migration, we noticed that PgBouncer started leaking connections to PostgreSQL like a sieve, leading to exhaustion of the maximum number of connections configured in RDS.

 Read more

Using Command-Line Tools on Vim Buffers

23 Apr, 2020 vim / command-line / tips / linux

Vim offers many ways to use the command-line tools available on your system when editing. You can:

  1. insert the output of a command into the current buffer - e.g., insert the current date.
  2. process lines of the current buffer through a command - e.g., sum up a list of numbers in the file.
  3. manipulate lines of the current buffer using a command - e.g., sort a list of names in the file.

 Read more

GnuCash for Personal Finance: Online Quotes

28 Jul, 2018 gnucash / personal-finance / mutual-fund

This is third in the series of posts describing how I use GnuCash to manage my finances. In previous posts, I had discussed how I organize my accounts, record transactions and handle taxation in GnuCash. In this post I’ll show how GnuCash can be configured to fetch the current NAV of mutual funds from the Internet.

 Read more

GnuCash for Personal Finance: Transactions and Taxes

26 Jul, 2018 gnucash / personal-finance / accounting / mutual-fund

This is second in the series of posts describing how I use GnuCash to manage my finances. In the previous post I had discussed how I organize my accounts in GnuCash. In this post I’ll describe how I record transactions and use GnuCash to help with computation of taxes and filing of tax returns.

 Read more

GnuCash for Personal Finance: Chart of Accounts

22 Jul, 2018 gnucash / personal-finance / accounting

GnuCash is an open-source double-entry bookkeeping software. In a series of posts this week, I will describe how I use GnuCash to manage my finances. The series will be biased towards a portfolio composed primarily of Indian mutual funds. This post describes the chart of accounts involved and the purpose of each account.

 Read more

  Older Posts →