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.
Understanding SQL: The Language of Relational Databases

Understanding SQL: The Language of Relational Databases

1
Comments
3 min read
Out of Range statistics with PostgreSQL & YugabyteDB

Out of Range statistics with PostgreSQL & YugabyteDB

Comments 1
7 min read
FIRST_VALUE Function In SQL Server

FIRST_VALUE Function In SQL Server

5
Comments
2 min read
O que é a normalização em um banco de dados ?

O que é a normalização em um banco de dados ?

3
Comments
2 min read
Unlock Complex Time Series Analysis in SQL with Range Queries

Unlock Complex Time Series Analysis in SQL with Range Queries

Comments
6 min read
YugabyteDB bulk inserts with function: faster with SQL compared to PL/pgSQL

YugabyteDB bulk inserts with function: faster with SQL compared to PL/pgSQL

Comments
4 min read
Relational Database Management Systems (RDBMS): Benefits and Limitations

Relational Database Management Systems (RDBMS): Benefits and Limitations

1
Comments
3 min read
Paginate SQL results

Paginate SQL results

Comments
5 min read
Top Asking SQL vs Mongo Queries

Top Asking SQL vs Mongo Queries

1
Comments
12 min read
Understanding 'Single' vs "Double" Quotation Marks in PostgreSQL

Understanding 'Single' vs "Double" Quotation Marks in PostgreSQL

1
Comments
3 min read
Exploring Relational Databases: Concepts and Applications

Exploring Relational Databases: Concepts and Applications

Comments
3 min read
Data Residency Compliance: PostgreSQL RLS to access YugabyteDB local region

Data Residency Compliance: PostgreSQL RLS to access YugabyteDB local region

1
Comments
8 min read
#7 MongoDB VS SQL

#7 MongoDB VS SQL

Comments
7 min read
SHOW ENGINE INNODB STATUS\G

SHOW ENGINE INNODB STATUS\G

Comments
2 min read
SQL vs NoSQL Databases: Which is Better?

SQL vs NoSQL Databases: Which is Better?

Comments
11 min read
Chat with your Database using Custom GPTs

Chat with your Database using Custom GPTs

6
Comments
3 min read
Let's do some decorating!

Let's do some decorating!

1
Comments
4 min read
PostgreSQL Vs Supabase

PostgreSQL Vs Supabase

2
Comments
3 min read
Step-by-Step Guide to Setting Up Your First AWS EC2 Instance

Step-by-Step Guide to Setting Up Your First AWS EC2 Instance

10
Comments 2
3 min read
Troubleshooting Fragmented Indexes in PostgreSQL

Troubleshooting Fragmented Indexes in PostgreSQL

2
Comments
3 min read
The Syntax of Discreteness - Using SQL as an Example

The Syntax of Discreteness - Using SQL as an Example

6
Comments
4 min read
What Is Database Monitoring

What Is Database Monitoring

1
Comments
12 min read
A Laymen’s Roadmap for Data Analysis and Processing Technology

A Laymen’s Roadmap for Data Analysis and Processing Technology

Comments
12 min read
Analyzing Retail Sales Data in SQL

Analyzing Retail Sales Data in SQL

1
Comments
6 min read
API completa em Golang - Parte 6

API completa em Golang - Parte 6

11
Comments
15 min read
CSV vs SQL

CSV vs SQL

Comments
1 min read
Getting Started with SQL: A Quick Reference for Beginners.

Getting Started with SQL: A Quick Reference for Beginners.

1
Comments
9 min read
How to encrypt MySQL data with keys

How to encrypt MySQL data with keys

Comments
2 min read
What Actually is GraphQL?

What Actually is GraphQL?

1
Comments
3 min read
You Must Test Your Databases And Here Is How

You Must Test Your Databases And Here Is How

Comments
27 min read
Translating Database Queries

Translating Database Queries

110
Comments 3
3 min read
Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

Comments
3 min read
IBM is Offering 21 Courses For Free : No Payment Required

IBM is Offering 21 Courses For Free : No Payment Required

1
Comments
1 min read
Go ORMs Compared

Go ORMs Compared

31
Comments 3
5 min read
Database Monitoring Metrics: Key Indicators for Performance Analysis

Database Monitoring Metrics: Key Indicators for Performance Analysis

Comments
9 min read
Pages and Blocks in DBMS

Pages and Blocks in DBMS

Comments
2 min read
Improving Performance with SQL Aggregate Functions

Improving Performance with SQL Aggregate Functions

Comments
7 min read
How to fix a sequence when it goes out of sync in PostgreSQL

How to fix a sequence when it goes out of sync in PostgreSQL

Comments
5 min read
Partitioning a Billion-Row Table of Soccer Data Using Data Context

Partitioning a Billion-Row Table of Soccer Data Using Data Context

Comments
8 min read
Improving Performance in a Hierarchical SQL Table Structure with Column Propagation

Improving Performance in a Hierarchical SQL Table Structure with Column Propagation

Comments
9 min read
When to Use JSON Data in a Relational Database

When to Use JSON Data in a Relational Database

3
Comments
6 min read
A complete guide to generated columns in MySQL

A complete guide to generated columns in MySQL

Comments
6 min read
CRUD and SQL - the basics!

CRUD and SQL - the basics!

64
Comments 9
5 min read
Oracle SQL database with CodeIgniter?

Oracle SQL database with CodeIgniter?

Comments
2 min read
YugabyteDB avoids bloat with the outbox pattern

YugabyteDB avoids bloat with the outbox pattern

3
Comments
6 min read
Back to Basics #3 - Databases and SQL Fundamentals

Back to Basics #3 - Databases and SQL Fundamentals

3
Comments
2 min read
Monitoring Is Not Enough and Understanding Through Observability Is the Key

Monitoring Is Not Enough and Understanding Through Observability Is the Key

Comments
13 min read
SQL and PostgreSQL for Advanced Full-Text Search

SQL and PostgreSQL for Advanced Full-Text Search

1
Comments
5 min read
Handling JSON data in SQL Databases

Handling JSON data in SQL Databases

1
Comments
3 min read
Why do I put a table between the images and the data

Why do I put a table between the images and the data

Comments
4 min read
SQL looks like English is a well-intentioned error

SQL looks like English is a well-intentioned error

12
Comments 5
4 min read
Understanding Custom Functions in DuckDB

Understanding Custom Functions in DuckDB

9
Comments
2 min read
Covering Index nuances: which columns to cover (WHERE, ORDER BY, LIMIT, SELECT)?

Covering Index nuances: which columns to cover (WHERE, ORDER BY, LIMIT, SELECT)?

2
Comments
12 min read
Querying MongoDB Like an SQL DB Using Aggregation Pipeline

Querying MongoDB Like an SQL DB Using Aggregation Pipeline

Comments
8 min read
SQL Assistant: Text-to-SQL Application in Streamlit 🤖

SQL Assistant: Text-to-SQL Application in Streamlit 🤖

52
Comments
6 min read
18 GitHub Repositories You Need to Star Right Now! 🌟🔥

18 GitHub Repositories You Need to Star Right Now! 🌟🔥

60
Comments 5
4 min read
PostgreSQL Backup and Restore Strategies: A Comprehensive Guide

PostgreSQL Backup and Restore Strategies: A Comprehensive Guide

4
Comments
5 min read
How to Write a SQL Subquery with Drizzle ORM

How to Write a SQL Subquery with Drizzle ORM

Comments
2 min read
Unveiling the Potential of the COUNT Function in SQL

Unveiling the Potential of the COUNT Function in SQL

1
Comments
3 min read
Import data from Excel to SQL Server or Azure SQL Database | Convert Excel Files to Databases Quickly

Import data from Excel to SQL Server or Azure SQL Database | Convert Excel Files to Databases Quickly

1
Comments 1
1 min read
loading...