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.
Building a Smart Bible Reading Reminder System - Personalized Push Notifications at Scale
Cover image for Building a Smart Bible Reading Reminder System - Personalized Push Notifications at Scale

Building a Smart Bible Reading Reminder System - Personalized Push Notifications at Scale

1
Comments
12 min read
XML External Entity (XXE) Injection: A Complete Guide for Developers
Cover image for XML External Entity (XXE) Injection: A Complete Guide for Developers

XML External Entity (XXE) Injection: A Complete Guide for Developers

Comments
18 min read
SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY

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

Comments
5 min read
3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)

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

2
Comments
3 min read
Text2SQL on xxxx's of tables?

Text2SQL on xxxx's of tables?

Comments
1 min read
Wait, what? PK is not needed for HABTM?

Wait, what? PK is not needed for HABTM?

Comments
2 min read
Simple vs Complex: When to Level Up Your Solutions

Simple vs Complex: When to Level Up Your Solutions

Comments
5 min read
Streaming SQL Engine: Lightweight Cross-Data Source Integration for Resource-Constrained Environments.

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

10
Comments
1 min read
From Messy Wearables to Insights: Building a Personal Health Data Warehouse with DuckDB & Evidence

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

2
Comments
3 min read
Stop Manually Tracing Azure Synapse Dependencies

Stop Manually Tracing Azure Synapse Dependencies

Comments
1 min read
PostgreSQL SQL Recap: Building Strong Foundational SQL Skills
Cover image for PostgreSQL SQL Recap: Building Strong Foundational SQL Skills

PostgreSQL SQL Recap: Building Strong Foundational SQL Skills

1
Comments
4 min read
TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today
Cover image for TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today

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

5
Comments 1
4 min read
Part 8: Databricks Pipeline & Dashboard
Cover image for Part 8: Databricks Pipeline & Dashboard

Part 8: Databricks Pipeline & Dashboard

Comments
2 min read
Part 4: Building the Bronze Layer with Auto Loader and Delta Lake
Cover image for Part 4: Building the Bronze Layer with Auto Loader and Delta Lake

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

Comments
2 min read
Building a Secure E-Commerce Chat Agent with Stored Procedures

Building a Secure E-Commerce Chat Agent with Stored Procedures

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