Amongst other things, I have worked on
- Building REST API servers from scratch with Object Relational Mapping (ORM), caching and middlewares with custom logic.
- Frontend with all kinds of visualisations (like charts, bar graphs, histograms etc.).
- Authentication and authorization layer.
- Dockering all kinds of applications written in Node, Python and Go for production as well as developer environment.
- Setting linters, code formatter, and testing using github actions.
- Setting up CI/CD pipeline for auto deployments.
- Setting up and configuring multiple AWS services like VPC, ECS, S3, EC2, Lambda and more.
- Database migrations using pg_dump/pg_restore and pgBackRest.
- Database modelling and optimising query performance.
- Setting up Kubernetes cluster for self managed postgres cluster.
Projects and Talks
-
Doing Geospatial analysis with Python (FOSS4G Asia, Nov 2023) (Github)
-
State of Maplibre (FOSS4G Asia, Nov 2023) (Slides) (Youtube)
-
Building a Robust Open Source Geospatial Database Solution using PostgreSQL and its Ecosystem (FOSS4G Asia, Nov 2023) (Slides)
-
Using Uber H3 Indexing Library in Postgres for Geospatial Data Analytics (FOSS4G Asia, Nov 2023) (Slides)
-
JSON in postgres - A Developer’s perspective (July 2023) (Youtube)
-
Leveraging the Power of Uber H3 Indexing Library in Postgres for Geospatial Data Processing (FOSS4G 2023) (Youtube) (Slides)
-
Scaling Spatial Temporal Data Analysis with Postgres, PostGIS, TimescaleDB, and H3 Indexing: A Hands-On Workshop (FOSS4G 2023) (Slides)
-
Time series raster data in PostgreSQL with the TimescaleDB and postgis_raster (FOSS4G 2023) (Slides)
-
Mastering Time Series Data Management with Postgres + TimescaleDB (pgConf Nepal, May 2023) (Slides)
-
Dockerize your PostgreSQL: A Step-by-Step Guide for Easy Deployment and Management (pgConf Nepal, May 2023) (Slides)
-
Spatio-temporal Database - Creating a high availability easily scalable Spatio-temporal database cluster with Postgres, PostGIS, and timescaleDB! (FOSS4G 2022)