PostgreSQL

Databases

PostgreSQL is an open-source relational database, and it's where most of my applications store their data.

How I use PostgreSQL

I design schemas, relations and indexes, and write migrations, SQL queries and functions.

You get data that's properly connected and consistent: an order can't exist without a customer, and duplicates are blocked by rules in the database itself. Well-chosen indexes keep search and reports fast even as the amount of data grows.

In practice I write every schema change as a migration, so the database can be rebuilt from scratch and stays the same across environments. Scheduled jobs such as reminders and reports run through pg_cron directly in the database, and I write more complex logic as SQL functions.

I mostly use it through Supabase, with Row Level Security rules protecting the data, and I also work with it from a separate Node.js backend when a project needs one.

Used in: all Supabase projects, Sve od nameštaja, TerminiOnline.

Projects using PostgreSQL

Websites and apps I built where PostgreSQL was used.

  • Apartmani Jovča — Website and Booking System

    Apartmani Jovča — Website and Booking System

    Website and booking system for Apartmani Jovča at Bovan Lake near Sokobanja, Serbia. Guests choose an apartment, check availability in a calendar and send a booking, while the owner runs everything from an admin panel: apartments, bookings with statuses, gallery, messages and statistics. The site is in four languages (Serbian, English, German, Italian), sends automatic emails (confirmation, arrival instructions, reminder and review request) and has a guest portal. Built with Next.js and Supabase, live at apartmanijovca.rs.

  • Protokol Alert — Expiry Date Tracking SaaS

    Protokol Alert — Expiry Date Tracking SaaS

    My own SaaS for tracking product expiry dates in retail. A worker scans the barcode with a phone and enters the date, and the system sends alerts before expiry and shows what to return to the supplier, put on sale or take off the shelf. It consists of a worker app (PWA), an admin panel for stores, suppliers, reports and billing, a backend API with automatic expiry checks, and an Android app. Many stores and companies run in one system, and each sees only its own data. In production since 1 April 2026, tracking about 3,300 products.

  • Web Security Scanner — Free Website Security Check

    Web Security Scanner — Free Website Security Check

    My own product: a passive website security scanner with more than 240 automated checks. Enter an address and get a score and a list of issues by area: SSL and TLS, HTTP headers, DNS, GDPR and cookies, SEO, performance, CORS, APIs and dependencies. The scanner sends no attacks and never changes the site it checks, and it has four strictness levels. It comes with a separate malware scanner with a damage report, a public results gallery and a blog with guides. Bilingual (Serbian and English) and free to use, with a Pro subscription through Lemon Squeezy. The backend is Python and FastAPI in Docker, with a Supabase database.

  • gradovi.rs — Business Directory with Microsites

    gradovi.rs — Business Directory with Microsites

    My own platform: a business directory for the cities and municipalities of Serbia. A business signs up and gets its own microsite with a description, gallery, opening hours and contact form, and visitors find it by searching by city and category. Besides the free tier there are paid plans with more photos, reviews, visit analytics and a featured spot in the category, with up to 35% off for paying in advance. It has an admin panel for businesses, moderated reviews, invoices and payment processing. About 310 indexed pages, built with React and Supabase with 25 server functions.

  • Var Sistem — Weld Traceability, NDT and Certificates

    Var Sistem — Weld Traceability, NDT and Certificates

    A system for welding traceability, fabrication and quality control, built from my own experience in welding and NDT inspection. Every weld is tracked from the isometric to the report: who welded it, when, with which procedure, on which drawing and spool, and whether it passed inspection. It covers NDT, repairs, PWHT and hydrotest per weld and line, welders and WPS, documents per weld (NDT, MTR, certificates), a spool card with a QR code, photos and reports with CSV and Excel export. Multiple companies in one system, roles per user and a permanent audit trail of every change. The office web app is done, and an offline mobile app for field work is in progress.

  • Fakture Online — Invoicing with SEF Integration

    Fakture Online — Invoicing with SEF Integration

    My own SaaS for online invoicing for freelancers, flat-rate entrepreneurs and small businesses in Serbia. An invoice takes half a minute, goes out by email as a PDF with an IPS QR payment code and straight to SEF, the national e-invoicing system, with an inbox, cancellations and automatic status updates. It tracks who has paid, sends reminders for unpaid invoices, creates recurring invoices and keeps the KPO ledger for flat-rate entrepreneurs. It imports bank statements and matches them to invoices by payment reference. It also works as a phone app, with two-factor sign-in. Built with Next.js and Supabase.

  • Laser Wood Design — Price Configurator and Storefront

    Laser Wood Design — Price Configurator and Storefront

    A website with a configurator for Laser Wood Design from Pančevo, Serbia, a workshop making laser-engraved signs, keychains and 3D letters. The customer picks the material, size, model and LED lighting, sees a live preview of the sign and gets the price instantly, then sends an inquiry and downloads a PDF quote. The price is calculated on the server, so it always matches the workshop's price list. From the admin panel the owner manages materials and prices, the gallery, reviews and FAQ and tracks incoming inquiries. Built with React and Supabase, with automated tests and code checks on every change.

  • Sve od nameštaja — Furniture Marketplace with Search by Size

    Sve od nameštaja — Furniture Marketplace with Search by Size

    My own furniture marketplace for Serbia, being prepared for launch. The main filter is size: the buyer enters how much space they have and sees only what fits. Posting a listing takes a few steps with an automatic title, and photos are resized and stripped of GPS data before upload. For bulky items there is a transport request: carriers send quotes and the buyer picks one. It has buyer-seller messages, ratings that cannot be deleted, listing reports and a public moderation log. Buyers never pay anything, and sellers choose between a free account and plans for workshops, showrooms and carriers. The demo runs without a database, and the schema with 33 migrations is ready.

  • TerminiOnline — Online Booking for Salons and Clinics

    TerminiOnline — Online Booking for Salons and Clinics

    My own SaaS for online appointment booking for hair and beauty salons and clinics in Serbia. Every salon gets its own public page where clients choose a service and a free slot themselves, day or night, and receive an automatic reminder the day before. In the dashboard the owner sees the calendar, clients, services, staff, opening hours and reports. The subscription is monthly with no contract, the first 7 days are free and payments go through Lemon Squeezy. Built with Next.js and Supabase.

  • BrzoJelo — QR Ordering, Kitchen and Delivery for Restaurants

    BrzoJelo — QR Ordering, Kitchen and Delivery for Restaurants

    My own platform for small restaurants and fast food. A guest scans the QR code on the table and, with nothing to install, browses a menu with photos, allergens, sizes and extras, orders and follows the order status live. The kitchen works from a screen with cards by status, and staff sign in with a PIN. For delivery there is a driver panel, GPS tracking on a map, chat and a photo as proof of delivery. From the admin panel the owner manages the menu, QR codes for every table, stock, analytics with PDF and CSV export and an activity log. The core is free and other modules are switched on as needed. Built with Next.js and Supabase.

Frequently asked questions about PostgreSQL

What is PostgreSQL?

PostgreSQL is an open-source relational database that stores data in related tables and queries it with SQL. It's known for reliability, transaction support and extras like JSON columns and full-text search.

Is PostgreSQL free?

Yes, PostgreSQL is completely free and open source, including for commercial use. The only costs can come from hosting, meaning the server or service the database runs on, such as Supabase.

Do you design databases?

Yes, I design schemas, relations, indexes and migrations in PostgreSQL. I've done this in all my Supabase projects, as well as in Sve od nameštaja and TerminiOnline.

How much does a website or app built with PostgreSQL cost?

It depends on the type of project: Website with Online Booking from €300; 3-in-1 SaaS Platform (Web + Android + Custom) from €7,000; Website Security Review from €80; Custom Web Application from €500. These are starting prices; you get the final price and timeline in a written offer by email.

All skills →