Posts

All the articles I've posted.

• Exporting MSSQL tables to CSV/JSON

  Posted on:December 20, 2023 |  at 07:27 PM

  MSSQL doesn't provides any straightforward CLI utilties to export data in common formats like CSV or JSON. To tackle this, I developed a script using polars library in Python.

• JS Quirks: Sorting array of numbers

  Posted on:October 22, 2023 |  at 12:13 PM

  Sorting numbers in JS isn't as straightforward as you think. You'll have to explicitly pass a comparator.

• Efficiently grouping SAM/BAM file by reference name using Awk

  Posted on:September 27, 2023 |  at 12:13 PM

  A simple Awk oneliner to group SAM/BAM contents by reference names (or other fields).

• Libraries v/s Frameworks

  Posted on:September 27, 2023 |  at 12:13 PM

  An attempt to explain the difference between libraries and frameworks

• The curious case of missing hyphens

  Posted on:September 27, 2023 |  at 12:13 PM

  Looks can be deceptive! This article discusses the bugs that arise due to different representations of similar looking symbols, and why do we need them in first place.

• Chromedriver v/s Geckodriver

  Posted on:August 11, 2023 |  at 12:13 PM

  Managing PDF downloads with Geckodriver is easier than Chromedriver

• Leveraging Encodings to speedup grep

  Posted on:March 22, 2023 |  at 12:13 PM

  A guide on how to use grep efficiently (if your data allows it)

• Python functions on steroids

  Posted on:September 22, 2022 |  at 12:13 PM

  TIL that you can attach custom properties to a function in Python. I tried to explore its usecases.