Tech Couch

A Comfy Corner for Software, Security, Cloud, and AI

Browse category SQL

Dealing with pagination queries in SQL

The difficult choice behind chunking results into simple pages

Understanding postgres query plans

Making sense of postgres explanations

Working with JSON in PostgreSQL

When the line between SQL and NoSQL becomes blurred

What are NewSQL Databases?

A primer on the drop-in replacements for traditional RDBMS systems

Optimizing SQL queries with ChatGPT

Take advantage of ChatGPT's processing capabilities to make sense of complex query costs and optimization opportunities