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.
ACID Properties in Databases - Part 2: Your Shield Against Transactional Chaos

ACID Properties in Databases - Part 2: Your Shield Against Transactional Chaos

8
Comments
5 min read
Day 6 of SQL Series || Alter Table, Order By, NULL Values

Day 6 of SQL Series || Alter Table, Order By, NULL Values

7
Comments
3 min read
Mental Health WebApp

Mental Health WebApp

10
Comments 3
1 min read
Front-End to Full-Stack Journey Part 1: Planning My Attack

Front-End to Full-Stack Journey Part 1: Planning My Attack

Comments
4 min read
🔧 Embed SQL Editor ✍️ in Your Internal Web Portal 💻

🔧 Embed SQL Editor ✍️ in Your Internal Web Portal 💻

11
Comments
5 min read
How to Monitor SQL Performance in Spring Boot

How to Monitor SQL Performance in Spring Boot

2
Comments
7 min read
How to remove duplicates in Postgres SQL

How to remove duplicates in Postgres SQL

Comments
4 min read
The Importance of Minimizing Database Queries in Backend Development

The Importance of Minimizing Database Queries in Backend Development

Comments
1 min read
Top 8 Free Database Design Tools for 2025

Top 8 Free Database Design Tools for 2025

11
Comments 3
6 min read
Mastering SQLMap Tamper Scripts: The Ultimate Guide to Evading WAFs Like a Pro [Must Read Article]

Mastering SQLMap Tamper Scripts: The Ultimate Guide to Evading WAFs Like a Pro [Must Read Article]

7
Comments
3 min read
SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

7
Comments
9 min read
Transforming Nested JSON into Usable Data with SQL CROSS APPLY

Transforming Nested JSON into Usable Data with SQL CROSS APPLY

2
Comments
3 min read
Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!

Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!

2
Comments
13 min read
Simple SQL Statements Only Exist in Coursebooks and Training Courses

Simple SQL Statements Only Exist in Coursebooks and Training Courses

6
Comments
7 min read
How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword

How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword

Comments 1
1 min read
Day 5 of SQL Series || Operators , Wildcards and Aggregate Functions

Day 5 of SQL Series || Operators , Wildcards and Aggregate Functions

6
Comments
4 min read
PostgreSQL CSV Import and Export Guide

PostgreSQL CSV Import and Export Guide

1
Comments
1 min read
Understanding Transaction Isolation Levels in PostgreSQL

Understanding Transaction Isolation Levels in PostgreSQL

1
Comments 1
2 min read
Selecting the Right Database for the Job

Selecting the Right Database for the Job

8
Comments 1
6 min read
Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client

Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client

11
Comments
5 min read
Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)

Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)

12
Comments 3
3 min read
Oracle Database Fragmentation - How to reorg Tables / Indexes

Oracle Database Fragmentation - How to reorg Tables / Indexes

18
Comments 2
3 min read
How to Manage Your SQL Server Database Effectively

How to Manage Your SQL Server Database Effectively

6
Comments 1
3 min read
Exploring Aurora DSQL with TypeScript, Drizzle, Lambda, and AWS CDK

Exploring Aurora DSQL with TypeScript, Drizzle, Lambda, and AWS CDK

13
Comments
5 min read
Day 4 of SQL Series || SELECT Statement Use cases

Day 4 of SQL Series || SELECT Statement Use cases

7
Comments
3 min read
loading...