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.
Think in Sets: Writing High-Performance SQL the Declarative Way
cristiansifuentes profile

Think in Sets: Writing High-Performance SQL the Declarative Way

#sql #database #postgres #sqlserver
Comments
2 min read
Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques
cristiansifuentes profile

Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

#sql #database #dataengineering #analytics
1
Comments
2 min read
Working with JSON in PostgreSQL, MySQL & SQL Server
cristiansifuentes profile

Working with JSON in PostgreSQL, MySQL & SQL Server

#sql #database #json #datamodeling
1
Comments
2 min read
Querying the Past: Temporal Tables in SQL Server and PostgreSQL
cristiansifuentes profile

Querying the Past: Temporal Tables in SQL Server and PostgreSQL

#sql #database #sqlserver #postgres
2
Comments
2 min read
Materialized Views in SQL: Supercharging Read Performance
cristiansifuentes profile

Materialized Views in SQL: Supercharging Read Performance

#sql #database #dataengineering #backend
Comments
2 min read
Behind the Scenes: Reading SQL Execution Plans Like a Pro
cristiansifuentes profile

Behind the Scenes: Reading SQL Execution Plans Like a Pro

#sql #database #backend #indexing
Comments
3 min read
How to check the same status of data in each row within a group with esProc
esproc_spl profile

How to check the same status of data in each row within a group with esProc

#programming #devops #sql #esproc
6
Comments
2 min read
Top 10 AI Reporting Tools in 2025
janeksmietanek profile

Top 10 AI Reporting Tools in 2025

#ai #sql #datascience
10
Comments
8 min read
Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd
konstantinas_mamonas profile

Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

#database #sql #programming #performance
8
Comments
4 min read
Optimizing SQL queries for your AI Agents.
sten profile

Optimizing SQL queries for your AI Agents.

#ai #sql #python #database
6
Comments
4 min read
Building Weekly Historical Insights with SQL Server, Python, SQLite, and Power BI
jayesh_korade_48247a5b646 profile

Building Weekly Historical Insights with SQL Server, Python, SQLite, and Power BI

#python #sql #sqlite #powerfuldevs
Comments
1 min read
How to Self-Host PostgreSQL (with Monitoring)
therealfloatdev profile

How to Self-Host PostgreSQL (with Monitoring)

#sql #postgres #monitoring #devops
1
Comments
2 min read
Azure SQL Database vs. SQL Managed Instance: A Developer’s Guide to Choosing the Right Service
krupa_bhimani_1119cab2abc profile

Azure SQL Database vs. SQL Managed Instance: A Developer’s Guide to Choosing the Right Service

#azure #sql #database #cloudcomputing
1
Comments 2
3 min read
Basics of Animal Tracking Databases: Crafting the Schema
mcb77 profile

Basics of Animal Tracking Databases: Crafting the Schema

#animaltracking #gps #sql #postgres
Comments
4 min read
Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs
cristiansifuentes profile

Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs

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