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.
Ruby Database Setup & Common Commands & CRUD
marywebby profile

Ruby Database Setup & Common Commands & CRUD

#ruby #sql #crud #notes
1
Comments 1
3 min read
I have optimized my work with text-to-SQL translator improved with vector search
zakharsmirnoff profile

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

#ai #sql #go #python
8
Comments
3 min read
Basics of RAG with pgVector and Langchain
muyiwexy profile

Basics of RAG with pgVector and Langchain

#ai #sql #flutter #tutorial
16
Comments
13 min read
Crafting DDL Statements for an Online Food Ordering Service Database
bshadmehr profile

Crafting DDL Statements for an Online Food Ordering Service Database

#sql #database #programming
3
Comments
2 min read
Will Python replace Stored Procedures?
lucaliu profile

Will Python replace Stored Procedures?

#discuss #sql #python #programming
1
Comments
2 min read
A Practical Guide to Caching: What to Cache and When
readyset profile

A Practical Guide to Caching: What to Cache and When

#caching #database #postgressql #sql
Comments
14 min read
Designing Database Tables for an Online Food Ordering Service
bshadmehr profile

Designing Database Tables for an Online Food Ordering Service

#sql #database #programming
37
Comments
2 min read
Explorando Funções de Agregação no SQL: SUM, MAX, MIN, AVG
nathalia_friederichs profile

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

#beginners #programming #sql #database
1
Comments
5 min read
API completa em Golang - Parte 7
wiliamvj profile

API completa em Golang - Parte 7

#go #braziliandevs #sql #api
63
Comments 5
22 min read
Mastering Table Relationships in Relational Databases: The Role of Primary and Foreign Keys
bshadmehr profile

Mastering Table Relationships in Relational Databases: The Role of Primary and Foreign Keys

#database #programming #sql
6
Comments
3 min read
UUID in PostgreSQL
franckpachot profile

UUID in PostgreSQL

#postgres #sql #database
70
Comments 7
5 min read
To UUID, or not to UUID, that is the primary key question
mcadariu profile

To UUID, or not to UUID, that is the primary key question

#postgres #sql #database #performance
21
Comments
8 min read
PySpark & Apache Spark - Overview
ramakrishnan83 profile

PySpark & Apache Spark - Overview

#python #pyspark #dataengineering #sql
Comments
3 min read
Elasticsearch: An Introduction To The Database And Heart Of The Elastic Stack
kwan profile

Elasticsearch: An Introduction To The Database And Heart Of The Elastic Stack

#elasticsearch #nosql #sql
1
Comments 1
4 min read
Understanding and Optimizing Parallel Queries in PostgreSQL
namsi profile

Understanding and Optimizing Parallel Queries in PostgreSQL

#database #postgres #sql #data
Comments
2 min read
Database .NET Review
gamesover profile

Database .NET Review

#database #sql
3
Comments
5 min read
SQL Notebook I Wish I Had Crafted Sooner in My Coding Path
dplata profile

SQL Notebook I Wish I Had Crafted Sooner in My Coding Path

#sql
1
Comments
1 min read
Shift Left For DevOps: Enhancing Service Ownership in Databases
adammetis profile

Shift Left For DevOps: Enhancing Service Ownership in Databases

#sql #monitoring #devops #postgres
Comments
8 min read
Understanding SQL: The Language of Relational Databases
bshadmehr profile

Understanding SQL: The Language of Relational Databases

#sql #programming #database
1
Comments
3 min read
Out of Range statistics with PostgreSQL & YugabyteDB
franckpachot profile

Out of Range statistics with PostgreSQL & YugabyteDB

#postgres #yugabytedb #sql #database
1
Comments 1
7 min read
FIRST_VALUE Function In SQL Server
rashtech profile

FIRST_VALUE Function In SQL Server

#sql #datascience #beginners #data
5
Comments
2 min read
Normalização em Banco de Dados: Estruturando Dados com Eficiência e Integridade
ikauedev profile

Normalização em Banco de Dados: Estruturando Dados com Eficiência e Integridade

#database #mysql #sql #programming
3
Comments
2 min read
Unlock Complex Time Series Analysis in SQL with Range Queries
greptime profile

Unlock Complex Time Series Analysis in SQL with Range Queries

#database #sql #timeseries #greptime
Comments
6 min read
YugabyteDB bulk inserts with function: faster with SQL compared to PL/pgSQL
franckpachot profile

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

#yugabytedb #postgres #distributed #sql
Comments
4 min read
Relational Database Management Systems (RDBMS): Benefits and Limitations
bshadmehr profile

Relational Database Management Systems (RDBMS): Benefits and Limitations

#database #postgres #sql #programming
1
Comments
3 min read
loading...