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.
SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY
rebooter_s profile

SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY

#sql #mysql
Comments
5 min read
3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)
md_pabel_fe07e07449db7326 profile

3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)

#security #sql #tutorial #wordpress
2
Comments
3 min read
Text2SQL on xxxx's of tables?
danshalev7 profile

Text2SQL on xxxx's of tables?

#sql #falkordb #opensource
Comments
1 min read
Wait, what? PK is not needed for HABTM?
tom_donarski_dev profile

Wait, what? PK is not needed for HABTM?

#database #rails #ruby #sql
Comments
2 min read
Simple vs Complex: When to Level Up Your Solutions
pepefeliblu profile

Simple vs Complex: When to Level Up Your Solutions

#architecture #complexity #engineering #sql
Comments
5 min read
Streaming SQL Engine: Lightweight Cross-Data Source Integration for Resource-Constrained Environments.
theodore_p_9749548f7dd03 profile

Streaming SQL Engine: Lightweight Cross-Data Source Integration for Resource-Constrained Environments.

#architecture #dataengineering #python #sql
10
Comments
1 min read
From Messy Wearables to Insights: Building a Personal Health Data Warehouse with DuckDB & Evidence
wellallytech profile

From Messy Wearables to Insights: Building a Personal Health Data Warehouse with DuckDB & Evidence

#sql #python #dataengineering #duckdb
2
Comments
3 min read
Stop Manually Tracing Azure Synapse Dependencies
chrhiswagat profile

Stop Manually Tracing Azure Synapse Dependencies

#database #sql #opensource #dataengineering
Comments
1 min read
PostgreSQL SQL Recap: Building Strong Foundational SQL Skills
auyeungdavid_2847435260 profile

PostgreSQL SQL Recap: Building Strong Foundational SQL Skills

#postgres #sql #beginners
1
Comments
4 min read
TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today
web_dev-usman profile

TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today

#tailwindcss #database #sql #programming
5
Comments 1
4 min read
Part 8: Databricks Pipeline & Dashboard
ktnl profile

Part 8: Databricks Pipeline & Dashboard

#analytics #dataengineering #tutorial #sql
Comments
2 min read
Part 4: Building the Bronze Layer with Auto Loader and Delta Lake
ktnl profile

Part 4: Building the Bronze Layer with Auto Loader and Delta Lake

#architecture #dataengineering #tutorial #sql
Comments
2 min read
Building a Secure E-Commerce Chat Agent with Stored Procedures
samurai-techlead profile

Building a Secure E-Commerce Chat Agent with Stored Procedures

#ai #agents #sql #llm
Comments
3 min read
ROLLUP vs CUBE: How I Finally Understood SQL Subtotals
mazinocodes profile

ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

#sql #postgres #database #beginners
14
Comments
3 min read
Indexes Aren’t Magic — How Databases Really Use Them
frozenblood profile

Indexes Aren’t Magic — How Databases Really Use Them

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