#postgresql

4 results

Explainer

Why PostgreSQL Is the Most Secure System in the World: Layered Defense from role and schema to GRANT and RLS

Industry security tends to get 'looser the closer you get to the database' — backends often connect directly with an admin account, bare and unguarded. PostgreSQL uses role + schema + column-level GRANT + RLS to build outside-in permissions that can go as fine-grained as a single row (or even a single cell), keeping the last lock inside the database itself.

Case Study

Live English Tutor: Building a Real-Time Voice AI English Tutor with LiveKit + Gemini Native Audio

A real-time-voice-first AI English tutoring system: students converse with the AI teacher Emma via microphone (optionally with video/screen sharing), the system corrects mistakes in real time, and generates a post-class report in Chinese. The technical core is LiveKit (Self-hosted WebRTC) + Google Gemini 2.5 Flash Native Audio, with a FastAPI backend handling auth, courses, and data persistence.