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.
Simple query for remove duplicates from table

Simple query for remove duplicates from table

2
Comments
2 min read
SQL Server Performance Tuning

SQL Server Performance Tuning

2
Comments
2 min read
Structure Query Language

Structure Query Language

6
Comments
2 min read
Millions record query - with and without index

Millions record query - with and without index

Comments
2 min read
How to validate your prisma raw query results

How to validate your prisma raw query results

1
Comments
2 min read
How to use sequel.ai to convert natural language queries into SQL queries

How to use sequel.ai to convert natural language queries into SQL queries

Comments
3 min read
YugabyteDB column-level locking for UPDATE

YugabyteDB column-level locking for UPDATE

1
Comments
2 min read
Polars for Analytics an Introduction

Polars for Analytics an Introduction

3
Comments 2
3 min read
How to choose the right streaming database

How to choose the right streaming database

12
Comments
7 min read
Essential SQL Commands For Data Science

Essential SQL Commands For Data Science

Comments
3 min read
Mastering SQLAlchemy Relationships: Exploring the back_populates parameter and different relationship types

Mastering SQLAlchemy Relationships: Exploring the back_populates parameter and different relationship types

Comments 1
5 min read
[GDB] Debugging session PostgreSQL & AGE