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 To Create One-to-Many Relationships in SQL

How To Create One-to-Many Relationships in SQL

1
Comments
23 min read
SQL for Beginners

SQL for Beginners

Comments
2 min read
SQL antipatterns: Diplomatic Immunity

SQL antipatterns: Diplomatic Immunity

Comments
9 min read
Distributed Data and NoSQL

Distributed Data and NoSQL

Comments
4 min read
Diving Into Data: Understanding SQL and GraphQL for Junior Developers

Diving Into Data: Understanding SQL and GraphQL for Junior Developers

2
Comments
2 min read
SQL Column Deletion Techniques

SQL Column Deletion Techniques

Comments
2 min read
BigQuery Machine Learning

BigQuery Machine Learning

2
Comments
5 min read
Introduction to PL/SQL

Introduction to PL/SQL

2
Comments
2 min read
Como manipular variáveis locais utilizando SQL Server

Como manipular variáveis locais utilizando SQL Server

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

Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

1
Comments
3 min read
New Database IDE

New Database IDE

1
Comments
3 min read
Inner Join in SQL: A Comprehensive Guide

Inner Join in SQL: A Comprehensive Guide

Comments
10 min read
OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

3
Comments
8 min read
Partitioning and Clustering on BigQuery

Partitioning and Clustering on BigQuery

3
Comments 1
3 min read
How come there are tens of thousands of tables in a database

How come there are tens of thousands of tables in a database

7
Comments 1
5 min read
Get list of tables in mysql

Get list of tables in mysql

Comments
1 min read
Ruby Database Setup & Common Commands & CRUD

Ruby Database Setup & Common Commands & CRUD

1
Comments 1
3 min read
I have optimized my work with text-to-SQL translator improved with vector search

I have optimized my work with text-to-SQL translator improved with vector search

8
Comments
3 min read
Basics of RAG with pgVector and Langchain

Basics of RAG with pgVector and Langchain

16
Comments
13 min read
Crafting DDL Statements for an Online Food Ordering Service Database

Crafting DDL Statements for an Online Food Ordering Service Database

3
Comments
2 min read
Will Python replace Stored Procedures?

Will Python replace Stored Procedures?

1
Comments
2 min read
A Practical Guide to Caching: What to Cache and When

A Practical Guide to Caching: What to Cache and When

Comments
14 min read
Designing Database Tables for an Online Food Ordering Service

Designing Database Tables for an Online Food Ordering Service

36
Comments
2 min read
Explorando Funções de Agregação no SQL: SUM, MAX, MIN, AVG

Explorando Funções de Agregação no SQL: SUM, MAX, MIN, AVG

1
Comments
5 min read
API completa em Golang - Parte 7

API completa em Golang - Parte 7

62
Comments 5
22 min read
loading...