The Wayback Machine - https://web.archive.org/web/20231201195451/https://dev.to/t/sql

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.
Custom ordering without custom SQL with Ruby on Rails 7

Custom ordering without custom SQL with Ruby on Rails 7

6
2 min read
Order-based Group Operations (I)

Order-based Group Operations (I)

5
6 min read
Calling all beginners: simple SQL challenge

Calling all beginners: simple SQL challenge

2 min read
Materialized View to improve the performance of complex queries?

Materialized View to improve the performance of complex queries?

1
3 min read
Maximizing Database Efficiency Mastering Query Optimization in SQL

Maximizing Database Efficiency Mastering Query Optimization in SQL

2 min read
WEREWOLF WEED

WEREWOLF WEED

1
1 min read
Why do we NOLOCK in SQL server with an example

Why do we NOLOCK in SQL server with an example

1
1 min read
Why do we NOLOCK AND LOCK in SQL server with an example

Why do we NOLOCK AND LOCK in SQL server with an example

1 min read
Database server communication and data migration from one database to another server database in SQL server

Database server communication and data migration from one database to another server database in SQL server

2 min read
Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement

Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement

1 min read
How to create and configure a linked server in SQL Server Management Studio

How to create and configure a linked server in SQL Server Management Studio

2 min read
SQL Math Functions with Use Cases

SQL Math Functions with Use Cases

3
3
2 min read
Using SQLite to Examine Data Relationships and Compare Tables

Using SQLite to Examine Data Relationships and Compare Tables

7 min read
Partition Strategies: Fundamental Concepts for PostgreSQL Partitioning

Partition Strategies: Fundamental Concepts for PostgreSQL Partitioning

3
4 min read
Embedded Python Stored Procedure

Embedded Python Stored Procedure

6 min read
SQL - Use Subqueries for Complex Data Retrieval

SQL - Use Subqueries for Complex Data Retrieval

1 min read
SQL Stored Procedures - Na visão de um estudante.

SQL Stored Procedures - Na visão de um estudante.

6 min read
It's not surprising that it's N times faster than ORACLE, such lightweight is the king

It's not surprising that it's N times faster than ORACLE, such lightweight is the king

2
7 min read
How Metis Detects Too Many Open Connections on Postgres

How Metis Detects Too Many Open Connections on Postgres

3 min read
Dominando JOINs no SQL: Guia Completo

Dominando JOINs no SQL: Guia Completo

1
4 min read
Monolithic vs. Distributed SQL

Monolithic vs. Distributed SQL

6 min read
PostgreSQL. How to list the most IOPs-intensive queries?

PostgreSQL. How to list the most IOPs-intensive queries?

3
1 min read
Unlocking the Power of Apache Age: Advanced Techniques for SQL/Cypher Hybrid Queries

Unlocking the Power of Apache Age: Advanced Techniques for SQL/Cypher Hybrid Queries

2 min read
Group By, Grouping Sets, Cube, and Rollup Queries in SQL

Group By, Grouping Sets, Cube, and Rollup Queries in SQL

5 min read
SQL and NoSQL databases: What are the types and ideal use cases

SQL and NoSQL databases: What are the types and ideal use cases

1
1
6 min read
Comparing Types of Databases: A Real-World Benchmark Analysis

Comparing Types of Databases: A Real-World Benchmark Analysis

8 min read
Mastering Graph Queries with Cypher in Apache Age

Mastering Graph Queries with Cypher in Apache Age

3 min read
O problema de SQL que quase me enlouqueceu

O problema de SQL que quase me enlouqueceu

9
5 min read
Tenha controle sobre seu SQL com Golang e SQLC

Tenha controle sobre seu SQL com Golang e SQLC

6
11 min read
Structured Query Language (SQL) - Series

Structured Query Language (SQL) - Series

4
2 min read
IN() list filter with Top-N

IN() list filter with Top-N

6
15 min read
Triggers in SQL database to extend its declarative data logic (but not business logic)

Triggers in SQL database to extend its declarative data logic (but not business logic)

1
5 min read
SQL - Use Views for Simplified and Reusable Queries

SQL - Use Views for Simplified and Reusable Queries

2 min read
Can writes be blocked by reads in YugabyteDB?

Can writes be blocked by reads in YugabyteDB?

6 min read
SQL Server - Types of System Databases and Tables

SQL Server - Types of System Databases and Tables

4
3 min read
Locks, latches & distributed system coordination

Locks, latches & distributed system coordination

9 min read
Row Level Security with an ARRAY of tenants set in session parameter

Row Level Security with an ARRAY of tenants set in session parameter

2
6 min read
Docker Image for YugabyteDB Developers

Docker Image for YugabyteDB Developers

3 min read
Yet Another PostgreSQL-REGEX Article 🤺

Yet Another PostgreSQL-REGEX Article 🤺

8
4 min read
Let's have fun with MySQL JSON functions!

Let's have fun with MySQL JSON functions!

5
4
4 min read
The Hallucinated Rows Incident

The Hallucinated Rows Incident

6
1
11 min read
A Comprehensive Guide to SQL Query Optimization Techniques

A Comprehensive Guide to SQL Query Optimization Techniques

1
1
2 min read
Foreign Keys on Distributed SQL: don't worry, it scales

Foreign Keys on Distributed SQL: don't worry, it scales

1
6 min read
How To Create Many-to-Many Relationships in SQL

How To Create Many-to-Many Relationships in SQL

12
2
21 min read
🚛 Deploy Database Schema Migrations with Bytebase

🚛 Deploy Database Schema Migrations with Bytebase

9
5 min read
What makes a database ACID compliant?🧪

What makes a database ACID compliant?🧪

12
6 min read
The simplicity of DuckDB

The simplicity of DuckDB

2
9 min read
Entendendo o WHERE e o ORDER BY

Entendendo o WHERE e o ORDER BY

1
2 min read
Stored Procedures: Where to Go

Stored Procedures: Where to Go

10
5 min read
Usando migrations com Golang

Usando migrations com Golang

7
5 min read
Exploring Ways of Performance Tuning Your Postgresql Database

Exploring Ways of Performance Tuning Your Postgresql Database

2
6 min read
Data Engineering For Beginners: A Step-By-Step Guide

Data Engineering For Beginners: A Step-By-Step Guide

5
8 min read
Which Scenarios Does ClickHouse Applies to?

Which Scenarios Does ClickHouse Applies to?

5
9 min read
What the pluck?

What the pluck?

2
1
4 min read
Top 10 Tools For SQL Writing For Students

Top 10 Tools For SQL Writing For Students

2 min read
Deploying a Golang RESTful API with Gin, SQLC and PostgreSQL

Deploying a Golang RESTful API with Gin, SQLC and PostgreSQL

3
22 min read
How to check the number of queries per second (QPS) on the PostgreSQL DB instance?

How to check the number of queries per second (QPS) on the PostgreSQL DB instance?

7
1 min read
How to Deploy PostgreSQL with Docker and Docker Compose

How to Deploy PostgreSQL with Docker and Docker Compose

3
6 min read
Authorization

Authorization

1
1
3 min read
What Are ORMs & Should You Use Them

What Are ORMs & Should You Use Them

7 min read
loading...