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.
Why We Reserve Credits Before Running an Image Editing Job

Why We Reserve Credits Before Running an Image Editing Job

Comments
3 min read
Audit Houzz data in Python before ranking firms by reply rate

Audit Houzz data in Python before ranking firms by reply rate

Comments
7 min read
Your List Endpoint Runs 101 Queries to Show 100 Orders

Your List Endpoint Runs 101 Queries to Show 100 Orders

Comments
4 min read
Extracting Column Lineage from Flink SQL Without Running a Cluster

Extracting Column Lineage from Flink SQL Without Running a Cluster

Comments
2 min read
A keep-until date for every NDIS record: modelling the 7-year retention rule in Python and SQL

A keep-until date for every NDIS record: modelling the 7-year retention rule in Python and SQL

Comments 1
11 min read
Entity Framework Core Performance: 8 Common Mistakes and How to Fix Them

Entity Framework Core Performance: 8 Common Mistakes and How to Fix Them

Comments
3 min read
Database Migrations at Scale: How to Change Production Databases Without Breaking Applications

Database Migrations at Scale: How to Change Production Databases Without Breaking Applications

1
Comments
13 min read
Query a CSV file with SQL without setting up a database

Query a CSV file with SQL without setting up a database

1
Comments
2 min read
SQL Challenge: Can You Find the Second Purchase of Every Customer Using ROW_NUMBER()?

SQL Challenge: Can You Find the Second Purchase of Every Customer Using ROW_NUMBER()?

Comments
2 min read
Text-to-SQL on Oracle: 63.7% first try, on a benchmark my bug reports helped fix

Text-to-SQL on Oracle: 63.7% first try, on a benchmark my bug reports helped fix

Comments
1 min read
Build a Full-Text Search Engine with SQLite FTS5

Build a Full-Text Search Engine with SQLite FTS5

Comments
7 min read
Why a £24,000 HubSpot pipeline shows £44,000 in Power BI

Why a £24,000 HubSpot pipeline shows £44,000 in Power BI

Comments
2 min read
Consultas OLAP sobre ocupación de estacionamientos con ClickHouse

Consultas OLAP sobre ocupación de estacionamientos con ClickHouse

Comments
4 min read
De un CSV de sensores a un modelo analítico con dbt y DuckDB

De un CSV de sensores a un modelo analítico con dbt y DuckDB

Comments
5 min read
Designing a Reliable Database for an E-Commerce Application

Designing a Reliable Database for an E-Commerce Application

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