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.
The First Production Performance Problem I Faced (and How I Solved It)

The First Production Performance Problem I Faced (and How I Solved It)

Comments
2 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
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
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
📘 Database Normalization Example (1NF 3NF) with SQL in Oracle Live SQL

📘 Database Normalization Example (1NF 3NF) with SQL in Oracle Live SQL

2
Comments
2 min read
TRANSACTIONS , DEADLOCKS AND LOG BASED RECOVERY

TRANSACTIONS , DEADLOCKS AND LOG BASED RECOVERY

2
Comments
2 min read
🚀 How I Learned That Thinking “Small” Can Save Hours of SQL Headaches

🚀 How I Learned That Thinking “Small” Can Save Hours of SQL Headaches

1
Comments
2 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
CRUD Operations in MongoDB for Beginners

CRUD Operations in MongoDB for Beginners

4
Comments
2 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
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

Comments
4 min read
Handle Large PostgreSQL Schemas with a GUI Tool

Handle Large PostgreSQL Schemas with a GUI Tool

6
Comments
3 min read
Qantler interview Questions

Qantler interview Questions

5
Comments
1 min read
concat() vs Group_concat()

concat() vs Group_concat()

1
Comments
1 min read
SQLite dot commands: change directory command

SQLite dot commands: change directory command

1
Comments
1 min read
SQLite Scalar function: 3 valued iif and if scalar function

SQLite Scalar function: 3 valued iif and if scalar function

Comments
3 min read
Working with Cursors and Triggers in Oracle Live SQL

Working with Cursors and Triggers in Oracle Live SQL

6
Comments
2 min read
From SQL to Python: Uniting Stored Power with Functional Flexibility

From SQL to Python: Uniting Stored Power with Functional Flexibility

Comments
5 min read
loading...