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.
DMS Database Design

DMS Database Design

Comments
2 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
SQL Pagination

SQL Pagination

Comments
13 min read
dbForge 2026.2 Makes Its AI SQL Assistant Free: Here’s What Developers Get

dbForge 2026.2 Makes Its AI SQL Assistant Free: Here’s What Developers Get

3
Comments
4 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
SQL Query Execution Order: Why Your Query Doesn't Run Top-to-Bottom

SQL Query Execution Order: Why Your Query Doesn't Run Top-to-Bottom

Comments 1
4 min read
Supabase RLS for SaaS Billing: Keep Stripe Subscription Status Server-Side

Supabase RLS for SaaS Billing: Keep Stripe Subscription Status Server-Side

Comments
2 min read
Architecting an Air-Gapped Local RAG Pipeline: SQL Server to ChromaDB

Architecting an Air-Gapped Local RAG Pipeline: SQL Server to ChromaDB

Comments 1
2 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
Optimizing High-Volume Financial Ledger Queries in PostgreSQL

Optimizing High-Volume Financial Ledger Queries in PostgreSQL

Comments
2 min read
ALTER COLUMN failed because one or more objects access this column

ALTER COLUMN failed because one or more objects access this column

Comments
4 min read
It passed every constraint. It was still wrong.

It passed every constraint. It was still wrong.

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