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.
From 40% to 100% SQL Generation Accuracy: Why Local AI Needs Self-Correction, Not Perfect Prompts

From 40% to 100% SQL Generation Accuracy: Why Local AI Needs Self-Correction, Not Perfect Prompts

1
Comments
4 min read
Generating Table Schema from AWS Glue Table

Generating Table Schema from AWS Glue Table

2
Comments
1 min read
SQL Injection: The Security Nightmare Every Developer Must Understand

SQL Injection: The Security Nightmare Every Developer Must Understand

2
Comments
6 min read
Diving Deeper into SQL: Advanced Queries and Real-World Applications

Diving Deeper into SQL: Advanced Queries and Real-World Applications

Comments
3 min read
MySQL Performance Tuning: From Slow Queries to Lightning-Fast Database

MySQL Performance Tuning: From Slow Queries to Lightning-Fast Database

5
Comments
5 min read
SQL Case Files: A Free, Story Driven way to practice SQL

SQL Case Files: A Free, Story Driven way to practice SQL

12
Comments
2 min read
Getting Started with Database Migrations using FluentMigrator

Getting Started with Database Migrations using FluentMigrator

Comments
6 min read
Practical SQL Observability for Forge Apps with forge-sql-orm

Practical SQL Observability for Forge Apps with forge-sql-orm

2
Comments
8 min read
🧠 Understanding SQL Execution Order: The Real Flow Behind Your Queries

🧠 Understanding SQL Execution Order: The Real Flow Behind Your Queries

Comments
2 min read
Free Interactive SQL Practice Platform for Developers

Free Interactive SQL Practice Platform for Developers

Comments
1 min read
Generate UUID in PostgreSQL

Generate UUID in PostgreSQL

1
Comments
1 min read
Getting Started with PostgreSQL: A Comprehensive Guide

Getting Started with PostgreSQL: A Comprehensive Guide

Comments
2 min read
БД2 Практ (подзапрос)

БД2 Практ (подзапрос)

Comments
2 min read
Master SQL with Interactive Hands-On Practice

Master SQL with Interactive Hands-On Practice

Comments
1 min read
How to Generate SQL Queries with AI: Step-by-Step Guide Using Claude Code and DBHub

How to Generate SQL Queries with AI: Step-by-Step Guide Using Claude Code and DBHub

Comments
10 min read
LLMSQL&Arabic WikiTableQA&Payment-SQL:SQL Dataset(202510)

LLMSQL&Arabic WikiTableQA&Payment-SQL:SQL Dataset(202510)

1
Comments
5 min read
Optimizing SQL LIKE Security, Performance and Best Practices

Optimizing SQL LIKE Security, Performance and Best Practices

Comments
10 min read
SQL for Data Analytics: A Must Read for Beginner Data Analysts Before Diving Into SQL

SQL for Data Analytics: A Must Read for Beginner Data Analysts Before Diving Into SQL

Comments
4 min read
Using LIKE with Variables and Patterns in SQL

Using LIKE with Variables and Patterns in SQL

Comments
10 min read
A Minimal Go Toolkit for Cleaning, Validating, and Querying CSV/TSV/Excel/Parquet Files

A Minimal Go Toolkit for Cleaning, Validating, and Querying CSV/TSV/Excel/Parquet Files

Comments
3 min read
Computed columns in D365FO – Using Correlated Subqueries with Real SQL

Computed columns in D365FO – Using Correlated Subqueries with Real SQL

1
Comments
2 min read
How I Automated 90% of Data Requests Using LLM-Powered SQL Generation

How I Automated 90% of Data Requests Using LLM-Powered SQL Generation

5
Comments 2
7 min read
Database Transactions and ACID Properties: Guaranteeing Data Consistency

Database Transactions and ACID Properties: Guaranteeing Data Consistency

Comments
8 min read
EP 13: SQL Injection Isn't Dead - It Just Evolved

EP 13: SQL Injection Isn't Dead - It Just Evolved

1
Comments
3 min read
PART 5 — The Rise of Network SQL (N-SQL)

PART 5 — The Rise of Network SQL (N-SQL)

4
Comments
26 min read
loading...