Hi! I am Gab

This is a remake of our RAG based phlaw chatbot capstone Research. This project using industry standard technologies for AI and automation development.

This is a POS system for businesses that specializing in time renting such as karaoke rooms and billiard tables.

Built the sales and inventory system for Amry Pharmacy, a three-branch retail pharmacy in Davao del Norte (Asuncion, Kapalong, Talaingod). It replaces Loyverse and a stack of Excel sheets and paper logs with one Django REST API on PostgreSQL and two installable PWAs: a Storefront for counter work

LegalBot PH is a chatbot that turns a G.R. number, case title or legal topic into a structured Supreme Court case digest. It was built as our undergraduate capstone thesis at Ateneo de Davao University (accepted November 2025), over Philippine Supreme Court decisions from 2005 to 2025.

I build a sales and inventory system for a family pharmacy: a Next.js frontend on Vercel and a Django REST API on Render. One day, logging in on an iPhone sent users straight back to the login page with no error. The bug wasn't in either server. It was in the browser.

Most database problems I hit on a Django team had the same cause: the Python looked fine, and the SQL it produced didn't. This post covers two cases, N+1 queries and JSON lookups. Both are solved by the same habit: look at the SQL first.

The "Sign in with Google" button hides two protocols, three secrets, and a signed token your backend must verify before it trusts a single claim. I first met this flow while reviewing the social-login plugin of a production e-commerce backend built on Django (Mugna Internship).