Featured
Exporting MSSQL tables to CSV/JSON
Posted on:December 20, 2023 at 07:27 PMMSSQL 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.
Efficiently grouping SAM/BAM file by reference name using Awk
Posted on:September 27, 2023 at 12:13 PMA simple Awk oneliner to group SAM/BAM contents by reference names (or other fields).
Leveraging Encodings to speedup grep
Posted on:March 22, 2023 at 12:13 PMA guide on how to use grep efficiently (if your data allows it)
Recent Posts
Exporting MSSQL tables to CSV/JSON
Posted on:December 20, 2023 at 07:27 PMMSSQL 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 PMSorting 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 PMA 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 PMAn attempt to explain the difference between libraries and frameworks