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.
The Evolution of Data: From Codd's Tables to the NoSQL Rebellion
shubham_pandeyconnoisse profile

The Evolution of Data: From Codd's Tables to the NoSQL Rebellion

#computerscience #data #database #sql
1
Comments
3 min read
COUNT(column) vs COUNT(*) in SQL — With INNER, LEFT, RIGHT & FULL JOIN Explained
deko39 profile

COUNT(column) vs COUNT(*) in SQL — With INNER, LEFT, RIGHT & FULL JOIN Explained

#beginners #database #sql #tutorial
Comments
1 min read
Building sql-splitter: Correctness Is the Product
helgesverre profile

Building sql-splitter: Correctness Is the Product

#database #go #sql #tooling
Comments
11 min read
Ajuste de Rendimiento en PostgreSQL: Lo Que AprendĂ­ Optimizando Consultas en una Base de Datos de 10TB
synsun profile

Ajuste de Rendimiento en PostgreSQL: Lo Que AprendĂ­ Optimizando Consultas en una Base de Datos de 10TB

#postgres #performance #database #sql
1
Comments 2
8 min read
Your SQL client is a relic. Here's what a DuckDB-native IDE looks like
ruddy_ide profile

Your SQL client is a relic. Here's what a DuckDB-native IDE looks like

#sql #database #ai
Comments
2 min read
SQL Assertions, ANSI join, and ORA-08697
franckpachot profile

SQL Assertions, ANSI join, and ORA-08697

#oracle #sql #ansi #database
Comments
3 min read
Evidence Has a Free BI Tool as Code — Here's How to Use It
0012303 profile

Evidence Has a Free BI Tool as Code — Here's How to Use It

#analytics #sql #dataviz #webdev
Comments
1 min read
From Idea to Database: A Practical Guide to Database Design
junaiddshaukat profile

From Idea to Database: A Practical Guide to Database Design

#beginners #database #sql #tutorial
Comments
17 min read
Kysely Has a Free Type-Safe SQL Query Builder With Zero Magic
0012303 profile

Kysely Has a Free Type-Safe SQL Query Builder With Zero Magic

#kysely #sql #typescript #database
Comments
2 min read
Getting Started with Seal Report: Applying Dependant Filters
vladg_dev profile

Getting Started with Seal Report: Applying Dependant Filters

#sealreport #sql #analytics #tutorial
Comments
3 min read
ORMs Are a Lie We Tell Junior Developers So They Don't Have to Learn SQL
kirill_tolmachev profile

ORMs Are a Lie We Tell Junior Developers So They Don't Have to Learn SQL

#sql #orm #backend #programming
1
Comments
4 min read
A Evolução do Modelo Relacional para Objeto-Relacional
ana_lu profile

A Evolução do Modelo Relacional para Objeto-Relacional

#backend #database #oop #sql
1
Comments
5 min read
DuckDB Has a Free API: The SQLite for Analytics
0012303 profile

DuckDB Has a Free API: The SQLite for Analytics

#database #analytics #sql #python
Comments
2 min read
Hi I'm Ruddy
ruddy_ide profile

Hi I'm Ruddy

#sql #database #datascience #ai
Comments
2 min read
Meet Your New AI-Powered Senior DBA: Bridging the Gap Between Metadata and Architectural Excellence
furkiak profile

Meet Your New AI-Powered Senior DBA: Bridging the Gap Between Metadata and Architectural Excellence

#database #sql #ai #dotnet
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.