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.
Machine-learning life-cycle management using MLflow

Machine-learning life-cycle management using MLflow

3
Comments
29 min read
SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

6
Comments
11 min read
Why should you replace your PostgreSQL with 2000 SQLite databases?

Why should you replace your PostgreSQL with 2000 SQLite databases?

1
Comments
3 min read
How to write Database Procedures

How to write Database Procedures

3
Comments
4 min read
Utilizando o Prisma com TypeScript e SQLite: Um Guia Prático

Utilizando o Prisma com TypeScript e SQLite: Um Guia Prático

16
Comments
4 min read
How To Create One-to-Many Relationships in SQL

How To Create One-to-Many Relationships in SQL

1
Comments
23 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
SQL for Beginners

SQL for Beginners

Comments 1
2 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
loading...