Forem

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
Cover image for 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
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
Cover image for 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
Cover image for 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
Cover image for Hi I'm Ruddy
ruddy_ide profile

Hi I'm Ruddy

#sql #database #datascience #ai
Comments
2 min read
Diagramas de banco sempre ficam desatualizados. Parei de tentar “manter” e passei a gerar.
thiago_rosadasilva_0688 profile

Diagramas de banco sempre ficam desatualizados. Parei de tentar “manter” e passei a gerar.

#webdev #ai #productivity #sql
Comments
1 min read
🚨 Why Your SQL Window Functions Betray You in Cloud SSMS vs Snowflake
Cover image for 🚨 Why Your SQL Window Functions Betray You in Cloud SSMS vs Snowflake
naveena_davay profile

🚨 Why Your SQL Window Functions Betray You in Cloud SSMS vs Snowflake

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