Insights & articles
Thoughts, tutorials, and insights about web development
FeaturedDiscover FullstackPOS, a modern Point of Sale system featuring QR code ordering, KDS, and queue voice announcers to streamline your restaurant operations.
Finish the series with window functions, JSONB, full-text search, UPSERT with ON CONFLICT, roles and permissions, and backups with pg_dump.
Keep data consistent with transactions, savepoints, isolation levels and row locks, then move business logic into PL/pgSQL functions and triggers.
Read query plans with EXPLAIN ANALYZE and speed up a 500,000-row table with B-tree, composite, partial and GIN indexes.
Break complex questions into readable steps with subqueries, WITH clauses and recursive CTEs, then save reusable queries as views and materialized views.
Connect users, courses and orders with foreign keys, then combine them using INNER, LEFT, RIGHT, FULL and self joins.
Turn raw orders into business numbers: total revenue, average order value, sales per month and top customers using COUNT, SUM, AVG, GROUP BY, HAVING and FILTER.