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.
Advance SQL tricks.

Advance SQL tricks.

10
Comments 1
1 min read
Exploring PostgreSQL's EXCLUDE Operator: Advanced Data Constraints

Exploring PostgreSQL's EXCLUDE Operator: Advanced Data Constraints

7
Comments 1
3 min read
Using Triggers to Map Database Relationships in Custom Claims

Using Triggers to Map Database Relationships in Custom Claims

3
Comments
6 min read
TEMPORARY FUNCTION IN SQL

TEMPORARY FUNCTION IN SQL

4
Comments
2 min read
DROP TABLE while being read: wait or wound?

DROP TABLE while being read: wait or wound?

1
Comments
8 min read
Interpreting Low-Code from the perspective of open-source SPL

Interpreting Low-Code from the perspective of open-source SPL

Comments
8 min read
Join Elimination - Advanced SQL tuning

Join Elimination - Advanced SQL tuning

86
Comments 3
3 min read
Don't miss out on the new features in SQL Server 16.x

Don't miss out on the new features in SQL Server 16.x

5
Comments 2
2 min read
Oracle MERGE to UPDATE SQL

Oracle MERGE to UPDATE SQL

Comments
3 min read
How to connect multiple databases to Django project

How to connect multiple databases to Django project

17
Comments 1
2 min read
Routable computing engine implements front-end database

Routable computing engine implements front-end database

Comments
5 min read
The Trade-offs Between Database Normalization and Denormalization

The Trade-offs Between Database Normalization and Denormalization

14
Comments 1
4 min read
Sequelize Migration

Sequelize Migration

2
Comments
2 min read
Creating a Node.js web app service and SQL Database in Azure

Creating a Node.js web app service and SQL Database in Azure

8
Comments
4 min read
Approximate Count for hash sharded YugabyteDB tables

Approximate Count for hash sharded YugabyteDB tables

Comments
4 min read
SQL Case Study - Tiny Shop Sales

SQL Case Study - Tiny Shop Sales

6
Comments 2
6 min read
How to write SQL query in Ruby On Rails

How to write SQL query in Ruby On Rails

Comments
4 min read
Speeding up MySQL for testing or development

Speeding up MySQL for testing or development

1
Comments
3 min read
Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)

Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)

Comments
3 min read
Subqueries Unraveled: Exploring SQL’s Hidden Power

Subqueries Unraveled: Exploring SQL’s Hidden Power

1
Comments 6
3 min read
25 SQL tricks for beginners.

25 SQL tricks for beginners.

27
Comments 2
2 min read
How to pivot data using Dynamic SQL in SQL Server

How to pivot data using Dynamic SQL in SQL Server

5
Comments 4
3 min read
Exploring Advanced and Modern Concepts in SQL with Practical Examples.

Exploring Advanced and Modern Concepts in SQL with Practical Examples.

41
Comments 13
4 min read
Postgres Concurrency : What could go wrong (part 2)

Postgres Concurrency : What could go wrong (part 2)

6
Comments 2
3 min read
Generate SQL Script in PostgreSQL

Generate SQL Script in PostgreSQL

2
Comments
1 min read
loading...