All About Adds
A secure, transparent classified ads platform concept. Its Unique Selling Proposition (USP) is the mandatory human review of every ad to ensure trust, coupled with privacy-focused real-time communication.
Built on Supabase and PostgreSQL, this platform enforces strict data privacy using Row Level Security (RLS). Real-time chat and notifications are powered by WebSockets, ensuring instant communication without exposing user contact information.
The Challenge
The project faced a significant ethical and technical challenge: designing a real-time notification and chat system that strictly adhered to GDPR. I needed immediate data flow for a good user experience without exposing sensitive user information like email addresses or phone numbers between buyers and sellers.
The Solution
The platform was architected using Supabase, which leverages PostgreSQL's Row Level Security (RLS). Real-time communication was handled via WebSockets, but all database policies were written to ensure a user could only read data related to their own session or conversations they were a part of. This enforced data isolation at the lowest possible level.
Gerasimos Makris is an AI Web Developer with a background in FinTech operations. He specializes in building secure, scalable web applications that solve real-world financial problems. When he's not coding, he enjoys exploring the intersection of technology, finance, and business strategy.
