Schooliee AI-Based School System
Pakistan's first AI-based school management system featuring automated parent WhatsApp notifications, rosters setup, attendance, and fee alerts.
Technology · 8 projects
PostgreSQL database development with Prisma
PostgreSQL is a reliable, open-source relational database. It enforces relationships and rules between records, supports transactions and handles reporting queries well, which is why I use it for ERPs, SaaS platforms, ledgers and most business applications, usually with Prisma for type-safe access and migrations.
When PostgreSQL is a good fit
- Orders, payments, inventory, instalments and other records that must stay consistent
- Multi-tenant SaaS platforms that need clear data separation
- Reporting and dashboards built on aggregations across many records
- Applications that also need JSON fields, full-text search or geographic data
When I'd suggest something else
- Data with no fixed structure that changes shape constantly, where a document database may be simpler
- Simple real-time prototypes, where Firebase can be quicker to start
How I work with PostgreSQL
Constraints and relations
Foreign keys, unique constraints and checks so invalid data is rejected by the database itself.
Migrations
Version-controlled schema changes with Prisma, reviewed and tested before production.
Indexes and query tuning
Measured with real query plans, focused on the screens and reports people use most.
Backups
Managed backups with a tested restore process and least-privilege access.
Projects built with PostgreSQL
Banwalo Factory Management ERP
Enterprise manufacturing ERP dashboard tracking live profit trends, raw material stock, production stages, client/vendor ledgers, and automated payroll.
Schooliee EdTech Lead CRM
Customer engagement platform and lead collection CRM built for educational institutions to streamline student admissions and inquiries.
Weekkly Meal Kit & Prep Marketplace
Meal kit & weekly food prep marketplace connecting consumers with local culinary vendors, customized meal plans, and subscription orders.
MFVisions Project Management SaaS
Business productivity SaaS platform to manage projects, departments, revenue tracking, team scheduling, and sales targets with a rich dashboard.
Devscot Blog Dashboard
Secure admin portal and content management dashboard for publishing and managing blogs, media assets, and user accounts.
Aqaar Real Estate ERP & Recovery Dashboard
Comprehensive real estate management ERP for tracking property plots, customer installment recoveries, overdue balances, and financial ledgers.
Humsafar Matrimonial Platform
Pakistan's premier matrimonial web application featuring 10,000+ verified educated professional profiles, privacy-first matchmaking, and family approval flows.
Frequently asked questions
Why PostgreSQL instead of MySQL?
Both are solid. PostgreSQL offers richer data types, strong standards compliance and advanced features such as JSON querying, which suit growing business applications. If your organisation already runs MySQL, that can be the better choice.
Which hosting do you recommend?
Managed PostgreSQL from providers such as Neon, Supabase, Railway or major cloud platforms, chosen for your region, budget and backup requirements.
Need a PostgreSQL developer?
Tell me about your product, your current stack and your timeline. I will reply with questions and a practical next step.
Request a quote