Report, Feedback, Suggestions
Help improve PublikoPH by sending a quick message directly to the project channel.
John Benedict Badilla
Hello, I am John Benedict Badilla, a Bachelor of Science in Computer Science student at Quezon City University. I am passionate about Web Development, Software Engineering, and Cloud Computing.
Right now, I am focused on strengthening my technical foundation through projects, community work, and continuous learning so I can grow into a reliable cloud engineer. I enjoy solving real problems, improving team workflows, and building tools that are practical for students, communities, and public service use cases.
Feel free to connect so we can share ideas, exchange learning resources, and explore opportunities in technology together.
What is PublikoPH?
PublikoPH is a public budget explorer built to make government financial information easier to understand and easier to check. It organizes data from the General Appropriations Act, allotment releases, and related datasets into searchable pages, clear cards, and practical charts that regular users can navigate without needing technical background.
The goal is to support transparency, strengthen public understanding, and help students, researchers, and citizens track where funds are allocated across departments, locations, and priority programs.
This project was curated from official public sources, including yearly GAA datasets and DBM pages for budget and status of allotment releases, then organized into a single workflow for search, analysis, downloads, and location-based exploration.
PublikoPH was solo developed in a few days with focused iteration, testing, and UI refinements. Development was accelerated through AI-assisted programming with the GPT-5.3-Codex model to speed up implementation, debugging, and consistency updates across pages.
Technical Stack
PublikoPH is built with a modern web stack focused on speed, clean UI, and reliable data access.
Framework
Next.js App Router + React
Styling
Tailwind CSS
Data Backend
Supabase + PostgreSQL RPC
Charts
Recharts
Deployment
Vercel
Build Workflow
AI-Assisted Programming with GPT-5.3-Codex
What you can do here
- Browse yearly budget summaries and quick indicators for faster context.
- Compare allocations across departments, offices, and entities in one place.
- Find location-based project entries from region down to barangay.
- Open analytics charts to review budget and release trends over time.
- Download resource files by year and format for offline analysis.
- Use references and metadata to confirm source credibility.
Data note
Values and labels come from integrated budget datasets and release files. Some entries may contain source-level naming variations, so filtering behavior is tuned to preserve location context while staying practical for real-world search input.
PublikoPH continuously improves matching logic, scope handling, and table metadata so users can get reliable results faster while still seeing the original structure of source data.