DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Why I Built a Go SQL Helper

Why I Built a Go SQL Helper

Comments
8 min read
SQL as Architecture: The Irreconcilable Philosophies of jOOQ and LINQ

SQL as Architecture: The Irreconcilable Philosophies of jOOQ and LINQ

Comments
17 min read
When Kubernetes Isn't the Problem: Debugging External Dependencies in AKS

When Kubernetes Isn't the Problem: Debugging External Dependencies in AKS

Comments
5 min read
PostgreSQL 2200H Error: Causes and Solutions Complete Guide

PostgreSQL 2200H Error: Causes and Solutions Complete Guide

Comments
3 min read
Oracle ORA-00472 Error: Causes and Solutions Complete Guide

Oracle ORA-00472 Error: Causes and Solutions Complete Guide

Comments
3 min read
How to see running queries in Postgres and kill them

How to see running queries in Postgres and kill them

Comments
3 min read
SQLite Ecosystem: RTree/JSON Bugs, ON CONFLICT DO SELECT & PG Query Planning

SQLite Ecosystem: RTree/JSON Bugs, ON CONFLICT DO SELECT & PG Query Planning

Comments
3 min read
PostgreSQL 22003 Error: Causes and Solutions Complete Guide

PostgreSQL 22003 Error: Causes and Solutions Complete Guide

Comments 1
3 min read
Database Management Systems for Beginners: Learn SQL, Tables, Queries, and Data Design.

Database Management Systems for Beginners: Learn SQL, Tables, Queries, and Data Design.

Comments
1 min read
Oracle ORA-00447 Error: Causes and Solutions Complete Guide

Oracle ORA-00447 Error: Causes and Solutions Complete Guide

1
Comments
3 min read
day 01 of learning data engineering (step1: sql joins and set operators)

day 01 of learning data engineering (step1: sql joins and set operators)

1
Comments
3 min read
PostgreSQL 2200G Error: Causes and Solutions Complete Guide

PostgreSQL 2200G Error: Causes and Solutions Complete Guide

1
Comments
3 min read
Real-Time Metrics Dashboards with SQL: Patterns That Actually Scale

Real-Time Metrics Dashboards with SQL: Patterns That Actually Scale

1
Comments
7 min read
SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug

SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug

Comments
3 min read
PostgreSQL 2200C Error: Causes and Solutions Complete Guide

PostgreSQL 2200C Error: Causes and Solutions Complete Guide

Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.