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.
Finally, a Database That Actually Listens to You

Finally, a Database That Actually Listens to You

Comments
3 min read
Finding All Child Tables Referencing a Parent Table in Oracle

Finding All Child Tables Referencing a Parent Table in Oracle

5
Comments
1 min read
TIL: Clustered and Non-clustered indices in SQL

TIL: Clustered and Non-clustered indices in SQL

Comments
3 min read
Building Self-Correcting LLM Systems: The Evaluator-Optimizer Pattern

Building Self-Correcting LLM Systems: The Evaluator-Optimizer Pattern

1
Comments
6 min read
GCP Cloud SQL + Terraform: Quick Start Guide

GCP Cloud SQL + Terraform: Quick Start Guide

Comments
2 min read
MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis

MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis

Comments
2 min read
MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

Comments
2 min read
Database Security Patterns for Web Applications

Database Security Patterns for Web Applications

Comments
1 min read
Comparative guide for SQL Subqueries vs CTEs vs Temp Tables vs Views vs Materialized Views in AWS Aurora

Comparative guide for SQL Subqueries vs CTEs vs Temp Tables vs Views vs Materialized Views in AWS Aurora

1
Comments
5 min read
Mastering Postgres Window Functions for Data Analysis in Supabase

Mastering Postgres Window Functions for Data Analysis in Supabase

1
Comments
16 min read
PostgreSQL Advanced Queries & Data Types: A Practical Guide to Robust Data Management

PostgreSQL Advanced Queries & Data Types: A Practical Guide to Robust Data Management

Comments
3 min read
SQL GROUP BY Explained with Examples

SQL GROUP BY Explained with Examples

6
Comments
4 min read
ORMs vs CTEs: Why Choose When You Can Have Both?

ORMs vs CTEs: Why Choose When You Can Have Both?

1
Comments
1 min read
The main tasks of a Database Administrator (DBA) by 2025

The main tasks of a Database Administrator (DBA) by 2025

5
Comments
27 min read
5 Steps to Optimize MySQL Deep Pagination

5 Steps to Optimize MySQL Deep Pagination

Comments
4 min read
Building Trust in a Digital World: Why Transparency is Your Greatest Asset

Building Trust in a Digital World: Why Transparency is Your Greatest Asset

Comments
4 min read
MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

Comments
2 min read
Mangle: Google's Bold Take on Database Programming

Mangle: Google's Bold Take on Database Programming

5
Comments 1
2 min read
Ditch REST: How React + SQL + WebSockets Can Power Real-Time Apps Without the Overhead

Ditch REST: How React + SQL + WebSockets Can Power Real-Time Apps Without the Overhead

Comments
3 min read
Database Indexing: The Hidden Key to Application Speed

Database Indexing: The Hidden Key to Application Speed

1
Comments
2 min read
Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

1
Comments
11 min read
SQL Database Concepts:

SQL Database Concepts:

Comments
1 min read
DataPump : Disabling the Use of Symbolic Links When Creating a Directory

DataPump : Disabling the Use of Symbolic Links When Creating a Directory

Comments
2 min read
Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search

Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search

4
Comments
12 min read
From SQL to AI: A Fun Look at Conflict Detection Methods in MariaDB and PostgreSQL

From SQL to AI: A Fun Look at Conflict Detection Methods in MariaDB and PostgreSQL

1
Comments
4 min read
loading...