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.
Session Budgets or Driver Caps: A Debate for Agent SQL Exploration

Session Budgets or Driver Caps: A Debate for Agent SQL Exploration

Comments
7 min read
The refund arrived after the payout, so the fix was two nullable columns and no code

The refund arrived after the payout, so the fix was two nullable columns and no code

Comments
4 min read
DMS Database Design

DMS Database Design

Comments
2 min read
SQL: Find the Top 2 Orders for Every Customer Using Window Functions

SQL: Find the Top 2 Orders for Every Customer Using Window Functions

Comments
3 min read
How to Easily Convert JSON and Excel Files to SQL Insert Statements

How to Easily Convert JSON and Excel Files to SQL Insert Statements

Comments
1 min read
Stop Hardcoding Your .NET Data Provider

Stop Hardcoding Your .NET Data Provider

Comments
8 min read
Start and End Dates of the Longest Rising Period

Start and End Dates of the Longest Rising Period

5
Comments 1
6 min read
SQL Pagination

SQL Pagination

Comments
13 min read
Custom Fresh v2.1.0: Take Control of Laravel Database Resets

Custom Fresh v2.1.0: Take Control of Laravel Database Resets

Comments
1 min read
Designing the Data Model for Tracking Brands in LLM Answers

Designing the Data Model for Tracking Brands in LLM Answers

Comments
6 min read
Data Cleaning Broken Down

Data Cleaning Broken Down

Comments
6 min read
My Crypto Dashboard Updates Itself 96 Times a Day. Here's How I Built It.

My Crypto Dashboard Updates Itself 96 Times a Day. Here's How I Built It.

1
Comments
7 min read
New Percentile and Median Absolute Deviation Aggregations in Manticore

New Percentile and Median Absolute Deviation Aggregations in Manticore

Comments
3 min read
Querying CSV and Parquet exports inside a SQL IDE with DuckDB

Querying CSV and Parquet exports inside a SQL IDE with DuckDB

Comments
2 min read
Fix It in the Model or Fix It in the Source?

Fix It in the Model or Fix It in the Source?

Comments
9 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.