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.
Introduction To MySQL & SQL QUERIES

Introduction To MySQL & SQL QUERIES

2
Comments
2 min read
Транзакционные приключения плюшевой семьи медведей

Транзакционные приключения плюшевой семьи медведей

7
Comments
2 min read
SQL Recursive Queries - Understanding Common Table Expressions (CTEs)

SQL Recursive Queries - Understanding Common Table Expressions (CTEs)

41
Comments 4
2 min read
Introduction to Databases

Introduction to Databases

4
Comments
3 min read
Migrating from Azure Database for PostgreSQL to Neon

Migrating from Azure Database for PostgreSQL to Neon

9
Comments
7 min read
How to detect query which holds the lock in Postgres?

How to detect query which holds the lock in Postgres?

Comments
1 min read
How to Reset a Forgotten MariaDB User Password

How to Reset a Forgotten MariaDB User Password

Comments
1 min read
Free Database Diagram Tool - Easy Design and Collaboration

Free Database Diagram Tool - Easy Design and Collaboration

3
Comments 1
4 min read
🧐 What is Write Ahead Logging 📝🗂️ (WAL)

🧐 What is Write Ahead Logging 📝🗂️ (WAL)

11
Comments
3 min read
What does NULL mean in an OUTER JOIN? ("unknown" vs. "not exists")

What does NULL mean in an OUTER JOIN? ("unknown" vs. "not exists")

2
Comments
4 min read
How to build multi-tenancy in PostgreSQL for developing SaaS applications?

How to build multi-tenancy in PostgreSQL for developing SaaS applications?

2
Comments
4 min read
Working with JSON in MySQL

Working with JSON in MySQL

3
Comments
3 min read
Aggregates with NULL: count(), min(), max(), sum()

Aggregates with NULL: count(), min(), max(), sum()

Comments
3 min read
Build an OTP-Based Authentication Server with Go: Part 4 - File Uploads and Graceful Shutdown

Build an OTP-Based Authentication Server with Go: Part 4 - File Uploads and Graceful Shutdown

5
Comments
9 min read
.NET Developer - Azure API -interview questions - Part 1

.NET Developer - Azure API -interview questions - Part 1

5
Comments 1
5 min read
Understanding and Using Table Hints in SQL Server

Understanding and Using Table Hints in SQL Server

2
Comments 2
3 min read
Query optimization in MySQL is crucial for improving database performance, especially when dealing with large datasets

Query optimization in MySQL is crucial for improving database performance, especially when dealing with large datasets

Comments
2 min read
Unlocking the Power of AWS Databases: A Complete Guide for Developers

Unlocking the Power of AWS Databases: A Complete Guide for Developers

2
Comments
2 min read
Enhancing Text-to-SQL With Synthetic Summaries: A Few-Shot Learning Approach

Enhancing Text-to-SQL With Synthetic Summaries: A Few-Shot Learning Approach

1
Comments
16 min read
Could not drop object 'TABLE' because it is referenced by a FOREIGN KEY constraint

Could not drop object 'TABLE' because it is referenced by a FOREIGN KEY constraint

Comments
3 min read
SQL Performance Tuning: Best Practices for Faster Queries

SQL Performance Tuning: Best Practices for Faster Queries

Comments 1
3 min read
SQL in CouchDB: Get SQS for FREE and Celebrate Our Birthday

SQL in CouchDB: Get SQS for FREE and Celebrate Our Birthday

Comments
3 min read
Simple SQL Generator using AWS Bedrock

Simple SQL Generator using AWS Bedrock

1
Comments
3 min read
Explaining DELETE vs DROP vs TRUNCATE in SQL

Explaining DELETE vs DROP vs TRUNCATE in SQL

2
Comments
1 min read
Drizzle ORM Crash Course

Drizzle ORM Crash Course

8
Comments 2
4 min read
loading...