Understanding Transactions and Locking in PostgreSQL
A deep dive into PostgreSQL transactions, error handling, savepoints, transactional DDLs, and locking with MVCC.
Abishek Neupane / Chitwan, Nepal
Software Engineer focused on backend systems, databases, and production applications.
I build and ship real-world applications across APIs, databases, frontend integration, Linux servers, and production deployment.
TypeScript · Node.js · NestJS · PostgreSQL · Docker · Linux
Open to Software Engineer / Backend Engineer opportunities — Remote & Relocation
Currently
Astavision Infosys Pvt. Ltd.
Building and delivering production applications across APIs, databases, frontend integration and deployment.
At Astavision, I work with TypeScript, React/Next.js, Node.js/NestJS, PostgreSQL and MySQL. My work includes a multi-tenant commerce platform, school administration and application delivery through cPanel and Linux VPS deployments.
Selected engineering work
Work completed at Astavision Infosys · 2026
A multi-tenant commerce platform built with NestJS, PostgreSQL, TypeScript and a React/Next.js frontend, supporting independent shops, customer-facing storefronts and administrative workflows.
NestJS · PostgreSQL · TypeScript · Next.js · Docker
Work completed at Astavision Infosys · 2025
A TypeScript/Express news aggregation backend and Next.js frontend, with MySQL storage, scheduled ingestion, source attribution and searchable categories.
TypeScript · Express · MySQL · Next.js · Drizzle
Independent project · 2026
A local-first desktop utility for inspecting and managing Android packages through ADB without root access.
Electron · React · TypeScript · ADB · SQLite
Independent project · 2026
A Go and PostgreSQL backend with a TypeScript frontend, built around reusable questions, hierarchical topics and overlap-safe quiz allocation.
Go · PostgreSQL · TypeScript
Working in the open
Linux / Omarchy / 2026
Contributed to Omarchy by migrating Brave Origin integration from the beta package to the stable release, updating related installation, desktop/configuration references and migration handling.
Adapted into the Quattro branch with author credit, confirmed by the maintainer in July 2026.
What I work with
Backend engineering is my current focus. I’m growing deeper into databases, Linux, networking and production systems, with platform and cloud engineering as a longer-term direction.
More about me →From the notebook
Notes on databases, backend development and Linux. These are snapshots of what I was learning when I wrote them. Personal writing is still in the archive.
A deep dive into PostgreSQL transactions, error handling, savepoints, transactional DDLs, and locking with MVCC.
A practical guide to implementing secure JWT-based authentication with access tokens and refresh tokens in a NestJS e-commerce project. Covers token generation, validation, refresh flow, security best practices, and real-world application in an online store.
Exploring Linux, distro-hopping, and how WSL changed my development workflow.
I explored different database and compared with each other. I also tested PostgreSQL for its size and time for the 100000 tuples
I explored the paper - Spanner: Google’s Globally Distributed Database. This blog contains about the spanner in easier way to those who wants to learn about it
A raw, honest dive into building a PHP portal from scratch, grappling with a new tech stack, and learning to embrace the mess of coding.
No matches this time. Try a different word or topic.
Opportunities & conversations
I’m currently open to backend-focused Software Engineer opportunities, including remote roles and relocation.
You can also write about a project, an open-source contribution or an engineering question.
abishekneupane.np@gmail.com ↗