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.
BigQuery Machine Learning
cmcrawford2 profile

BigQuery Machine Learning

#bigdata #machinelearning #googlecloud #sql
2
Comments
5 min read
Introduction to PL/SQL
pinky057 profile

Introduction to PL/SQL

#database #sql #plsql #oracle
2
Comments
2 min read
Como manipular variáveis locais utilizando SQL Server
tiagoeuzebiocordeiro profile

Como manipular variáveis locais utilizando SQL Server

#sql #sqlserver
Comments
2 min read
Tips and Tricks for Tuning PostgreSQL Thread Cache Performance
shiviyer profile

Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

#postgres #sql #mysql #database
1
Comments
3 min read
New Database IDE
webdbapp profile

New Database IDE

#database #opensource #sql #nosql
1
Comments
3 min read
Inner Join in SQL: A Comprehensive Guide
dbvismarketing profile

Inner Join in SQL: A Comprehensive Guide

#sql #join
Comments
10 min read
OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services
sabareh profile

OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

#sql #database #datascience
3
Comments
8 min read
Partitioning and Clustering on BigQuery
cmcrawford2 profile

Partitioning and Clustering on BigQuery

#dataengineering #sql #googlecloud
3
Comments 1
3 min read
How come there are tens of thousands of tables in a database
esproc_spl profile

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

#programming #sql #esproc #development
7
Comments 1
5 min read
Get list of tables in mysql
caresle profile

Get list of tables in mysql

#sql #database #mysql #mariadb
Comments
1 min read
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
14
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?
luca1iu 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
33
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
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
API completa em Golang - Parte 7
wiliamvj profile

API completa em Golang - Parte 7

#go #braziliandevs #sql #api
54
Comments 5
22 min read
UUID in PostgreSQL
franckpachot profile

UUID in PostgreSQL

#postgres #sql #database
68
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
9 min read
PySpark & Apache Spark - Overview
ramakrishnan83 profile

PySpark & Apache Spark - Overview

#python #pyspark #dataengineering #sql
Comments
3 min read
Unveiling the Power of Window and Ranking Functions in SQL
ridhiarora profile

Unveiling the Power of Window and Ranking Functions in SQL

#discuss #sql #productivity #learning
6
Comments
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
loading...