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.
How I Slashed CPU Usage by 20%: 5 Proven SQL Optimization Techniques

How I Slashed CPU Usage by 20%: 5 Proven SQL Optimization Techniques

2
Comments
2 min read
Creating Unique Slugs on Supabase with PostgreSQL

Creating Unique Slugs on Supabase with PostgreSQL

56
Comments 1
3 min read
Ma Première Expérience avec SQL Server et T-SQL : Création d'une Base de Données pour une Bibliothèque

Ma Première Expérience avec SQL Server et T-SQL : Création d'une Base de Données pour une Bibliothèque

Comments
5 min read
Exploring New Features in PostgreSQL 17 with Python

Exploring New Features in PostgreSQL 17 with Python

3
Comments 1
3 min read
Understanding Your Data: The Essentials of Exploratory Data Analysis

Understanding Your Data: The Essentials of Exploratory Data Analysis

4
Comments
8 min read
Basic MySQL Queries: A Comprehensive Guide

Basic MySQL Queries: A Comprehensive Guide

7
Comments
4 min read
Database Indexing Explained: Why It's Like a Book's Table of Contents

Database Indexing Explained: Why It's Like a Book's Table of Contents

Comments
3 min read
Group and Summarize data, and align to the specified sequence #eg31

Group and Summarize data, and align to the specified sequence #eg31

6
Comments
1 min read
Unlocking the Power of Text-to-SQL with LangDB

Unlocking the Power of Text-to-SQL with LangDB

2
Comments
3 min read
SQL, mark continuous rows with sequence numbers #eg30

SQL, mark continuous rows with sequence numbers #eg30

8
Comments
1 min read
Boost Your Website Security for Free with SafeLine WAF

Boost Your Website Security for Free with SafeLine WAF

6
Comments
3 min read
SafeLine: Secure Your Web Applications Effortlessly

SafeLine: Secure Your Web Applications Effortlessly

6
Comments
2 min read
SQL, compute cumulative sums according to the termination condition #eg29

SQL, compute cumulative sums according to the termination condition #eg29

7
Comments 1
1 min read
Cast for type conversion in SQL

Cast for type conversion in SQL

1
Comments
2 min read
Calculating Fingerprints For SQL Queries

Calculating Fingerprints For SQL Queries

Comments
4 min read
One Minute: DuckDB

One Minute: DuckDB

1
Comments
1 min read
How to build a new Harlequin adapter with Poetry

How to build a new Harlequin adapter with Poetry

Comments
12 min read
SQL, parse json data #eg28

SQL, parse json data #eg28

11
Comments
1 min read
Declarative Multi-Engine Data Stack with Ibis

Declarative Multi-Engine Data Stack with Ibis

1
Comments
10 min read
Tips for Working with Complex Normalized Databases

Tips for Working with Complex Normalized Databases

Comments
15 min read
Understanding The ‘AND’ Keyword In SQL Server

Understanding The ‘AND’ Keyword In SQL Server

1
Comments
5 min read
Understanding Data Normalization and Database Design Principles

Understanding Data Normalization and Database Design Principles

1
Comments
2 min read
SQL, concatenate multiple rows of strings and remove duplicates #eg27

SQL, concatenate multiple rows of strings and remove duplicates #eg27

6
Comments
1 min read
Hotel reservation Schema design (PostgreSQL)

Hotel reservation Schema design (PostgreSQL)

2
Comments
4 min read
Understanding Lookup Tables in Excel and SQL

Understanding Lookup Tables in Excel and SQL

Comments
12 min read
loading...