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.
Difference between WHERE vs HAVING Clause in SQL

Difference between WHERE vs HAVING Clause in SQL

42
Comments 1
3 min read
SQL Injection Isn't Dead Yet

SQL Injection Isn't Dead Yet

35
Comments 1
6 min read
Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval

Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval

32
Comments 1
4 min read
Mastering SQL Queries: A Comprehensive Guide for Beginners

Mastering SQL Queries: A Comprehensive Guide for Beginners

25
Comments 5
2 min read
How I migrated from Firebase to Supabase

How I migrated from Firebase to Supabase

17
Comments 2
5 min read
Using migrations with Golang

Using migrations with Golang

15
Comments
5 min read
Calculate the Total Price According to the Cumulative Price Table

Calculate the Total Price According to the Cumulative Price Table

6
Comments 3
1 min read
How to Replace a Null with the Corresponding Value in the Previous Record

How to Replace a Null with the Corresponding Value in the Previous Record

6
Comments 1
1 min read
Types of equi-joins

Types of equi-joins

6
Comments 1
4 min read
What is the Difference between "sequel" and "SQL"?

What is the Difference between "sequel" and "SQL"?

6
Comments 6
1 min read
About transaction identifier (transaction_id) in PostgreSQL.

About transaction identifier (transaction_id) in PostgreSQL.

6
Comments
2 min read
JOINs in SQL

JOINs in SQL

5
Comments 1
5 min read
In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes

In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes

5
Comments 1
1 min read
How to Calculate Median on Values That Have Corresponding Quantities

How to Calculate Median on Values That Have Corresponding Quantities

5
Comments
2 min read
How to Transpose Rows to Columns on Multiple Fields in Each Group

How to Transpose Rows to Columns on Multiple Fields in Each Group

5
Comments 1
2 min read
Practical Experiments for Optimizing Django query with the power of SQL joins

Practical Experiments for Optimizing Django query with the power of SQL joins

5
Comments
7 min read
SQL | DDL, DQL, DML, DCL and TCL Commands

SQL | DDL, DQL, DML, DCL and TCL Commands

5
Comments
2 min read
Building a REST API with FastAPI, Async SQLModel, and PostgreSQL

Building a REST API with FastAPI, Async SQLModel, and PostgreSQL

4
Comments
1 min read
Introducing Filterable: Simplify Data Handling in Your Laravel Applications

Introducing Filterable: Simplify Data Handling in Your Laravel Applications

4
Comments
7 min read
Predicate Pushdown - Understanding Practically With An Example

Predicate Pushdown - Understanding Practically With An Example

3
Comments 1
2 min read
Oracle Database - Compare Execution Plans

Oracle Database - Compare Execution Plans

3
Comments
5 min read
How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

3
Comments 1
2 min read
Understanding of NULL in PostgreSQL database.

Understanding of NULL in PostgreSQL database.

3
Comments
2 min read
Introduction to Amazon Athena: A Fast and Cost-Effective Serverless Query Service

Introduction to Amazon Athena: A Fast and Cost-Effective Serverless Query Service

3
Comments
3 min read
The best type for storing money in our posgresql db

The best type for storing money in our posgresql db

3
Comments
2 min read
Easy no-code REST API for your databases

Easy no-code REST API for your databases

3
Comments 2
3 min read
What is SQL in picture

What is SQL in picture

2
Comments 2
1 min read
Custom SQL Scripts in PostgreSQL PgBench

Custom SQL Scripts in PostgreSQL PgBench

2
Comments
6 min read
PostgreSQL: Deleting all records from a table, except for the first and last ones.

PostgreSQL: Deleting all records from a table, except for the first and last ones.

2
Comments
2 min read
Understanding SQL vs. NoSQL Databases: A Beginner's Guide

Understanding SQL vs. NoSQL Databases: A Beginner's Guide

2
Comments
2 min read
Oracle Database - Identifying Session Tracefiles - without actually tracing them :-)

Oracle Database - Identifying Session Tracefiles - without actually tracing them :-)

2
Comments
5 min read
Move Fast and “Branch” Things

Move Fast and “Branch” Things

1
Comments
8 min read
SQL DATA MANIPULATION

SQL DATA MANIPULATION

1
Comments
3 min read
A Software Engineer's Tips and Tricks #1: Drizzle

A Software Engineer's Tips and Tricks #1: Drizzle

1
Comments 1
2 min read
Statistical information about tables in a PostgreSQL Database.

Statistical information about tables in a PostgreSQL Database.

1
Comments
2 min read
What is SQL in pictures. Diving deeper (Part 2)

What is SQL in pictures. Diving deeper (Part 2)

1
Comments
2 min read
Tips and Tricks for Troubleshooting ClickHouse Wait Events

Tips and Tricks for Troubleshooting ClickHouse Wait Events

1
Comments
2 min read
Python and SQL: Objects in Programming

Python and SQL: Objects in Programming

1
Comments
3 min read
Simulate Clock Skew in Docker Container

Simulate Clock Skew in Docker Container

1
Comments
2 min read
Advanced SQL Techniques: Take Next Level with CTE and SubQueries

Advanced SQL Techniques: Take Next Level with CTE and SubQueries

1
Comments
2 min read
How to find the third and fifth-highest values in a PostgreSQL table?

How to find the third and fifth-highest values in a PostgreSQL table?

1
Comments
2 min read
How to join tables in PostgreSQL using the WITH clause?

How to join tables in PostgreSQL using the WITH clause?

1
Comments
2 min read
How to Back Up and Restore Azure SQL Databases

How to Back Up and Restore Azure SQL Databases

1
Comments
8 min read
Tracking Personal Finances with SQL: Learn As You Manage Your Money!

Tracking Personal Finances with SQL: Learn As You Manage Your Money!

1
Comments
2 min read
Week 1: New NOTR Server - Containerization and Data Storage

Week 1: New NOTR Server - Containerization and Data Storage

1
Comments
3 min read
Finding Which Columns Value Has Actually Changed in PostgreSQL Trigger Functions

Finding Which Columns Value Has Actually Changed in PostgreSQL Trigger Functions

1
Comments
2 min read
Fetching Data (Next.js)

Fetching Data (Next.js)

1
Comments
2 min read
Why MongoDB is not great for complex reporting?

Why MongoDB is not great for complex reporting?

1
Comments
1 min read
Query Store Part 2- Regression Detection and Execution Plan Analysis: A Guide

Query Store Part 2- Regression Detection and Execution Plan Analysis: A Guide

Comments
3 min read
Building a Mermaid.js Gantt Chart in a FileMaker Web Viewer

Building a Mermaid.js Gantt Chart in a FileMaker Web Viewer

Comments
5 min read
PostgreSQL. How do you find potentially ineffective indexes?

PostgreSQL. How do you find potentially ineffective indexes?

Comments
2 min read
Using SQL to discover problem dates in your data

Using SQL to discover problem dates in your data

Comments
10 min read
How to check the distribution of timestamps in a PostgreSQL table?

How to check the distribution of timestamps in a PostgreSQL table?

Comments
3 min read
How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

Comments
2 min read
Passing The DataCamp SQL Associate Certificate

Passing The DataCamp SQL Associate Certificate

Comments
2 min read
How to Secure Your Supabase Database and Storage

How to Secure Your Supabase Database and Storage

Comments
6 min read
Find increases, latest values, and cumulative sums in SQL (postgres)

Find increases, latest values, and cumulative sums in SQL (postgres)

Comments
7 min read
How can we analyze total wait times in the last 15 minutes on Oracle RDBMS by users?

How can we analyze total wait times in the last 15 minutes on Oracle RDBMS by users?

Comments
4 min read
Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster Than ORACLE” an Exaggeration?

Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster Than ORACLE” an Exaggeration?

Comments
4 min read
Using Temporary Tables in MariaDB

Using Temporary Tables in MariaDB

Comments
2 min read
loading...