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.
# Understanding Data Modeling in PowerBI: Joins, Relationship and Schemas.
nyamatari_brian_c41e0c389 profile

# Understanding Data Modeling in PowerBI: Joins, Relationship and Schemas.

#dataengineering #datascience #microsoft #sql
1
Comments
2 min read
Prisma relationships, finally explained (with MySQL side by side)
edriso profile

Prisma relationships, finally explained (with MySQL side by side)

#prisma #beginners #database #sql
1
Comments 1
12 min read
How to Make xt850 Match xt 850
sanikolaev profile

How to Make xt850 Match xt 850

#database #nlp #sql #tutorial
Comments
6 min read
Modelagem de Dados no Agro: Unindo fluxo de caixa e Ganho Médio Diário (GMD) no mesmo Banco de Dados
dom1ng0s profile

Modelagem de Dados no Agro: Unindo fluxo de caixa e Ganho Médio Diário (GMD) no mesmo Banco de Dados

#python #sql #architecture #database
Comments
6 min read
I Tried to Analyze SQL Lineage Across 15 Databases — Everything Broke Until I Did This
leo_gu_475098bd7f84e326ed profile
leo gu

I Tried to Analyze SQL Lineage Across 15 Databases — Everything Broke Until I Did This

#database #sql
Comments
3 min read
Elasticsearch & Inverted Indices — The Death of SQL ILIKE (2026)
kaushikcoderpy profile

Elasticsearch & Inverted Indices — The Death of SQL ILIKE (2026)

#elasticsearch #sql #python
Comments
2 min read
"Table 'test.p' doesn't exist" — Understanding SQL Aliases and Default JOIN Behavior
dean_lee profile

"Table 'test.p' doesn't exist" — Understanding SQL Aliases and Default JOIN Behavior

#database #sql #leetcode #beginners
Comments
2 min read
How Databricks Genie Turns Plain English Into SQL Code
lucy1 profile
Lucy

How Databricks Genie Turns Plain English Into SQL Code

#databricks #dataengineering #sql #ai
5
Comments
11 min read
SQL Views Explained: Write Once, Query Forever
vivekdraxlr profile

SQL Views Explained: Write Once, Query Forever

#sql #database #postgres #beginners
Comments 1
6 min read
CVE-2026-21643: FortiClient EMS Critical SQL Injection — Actively Exploited, No Credentials Required
yuznumara profile

CVE-2026-21643: FortiClient EMS Critical SQL Injection — Actively Exploited, No Credentials Required

#news #cybersecurity #infosec #sql
Comments
2 min read
I Analyzed 10 Million Records in 47 Seconds Using Python + DuckDB (No Spark, No Cloud)
dattasable profile

I Analyzed 10 Million Records in 47 Seconds Using Python + DuckDB (No Spark, No Cloud)

#sql #python #dataengineering #tutorial
3
Comments 2
3 min read
Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database
dattasable profile

Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database

#sql #database #dataengineering #programming
Comments 1
3 min read
MySQL InnoDB Locking: The Silent Killer Behind Database Crashes
sriramrajendran profile

MySQL InnoDB Locking: The Silent Killer Behind Database Crashes

#mysql #database #sql #opensource
Comments 1
24 min read
PetStore: Pure Java for UI and Safe SQL Mapping
pponec profile

PetStore: Pure Java for UI and Safe SQL Mapping

#showdev #java #sql #ui
Comments
3 min read
SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro
vivekdraxlr profile

SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro

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