Modern SQL - Markus Winand modern-sql.com

SQL’s ORDER BY Has Come a Long Way

modern-sql.com·4w4 weeks ago·Lobsters, Hacker News, r/programming

Actions for SQL’s ORDER BY Has Come a Long Way

Order-Equivalence

modern-sql.com·13w13 weeks ago·Hacker News, r/programming

Actions for Order-Equivalence

Comments Inside SQL Statements

modern-sql.com·17w17 weeks ago

Actions for Comments Inside SQL Statements

WITHOUT OVERLAPS Constraints

modern-sql.com·21w21 weeks ago·Hacker News

Actions for WITHOUT OVERLAPS Constraints

Adieu Apache Derby, Welcome DuckDB

modern-sql.com·25w25 weeks ago·Hacker News

Actions for Adieu Apache Derby, Welcome DuckDB

GROUP BY ALL

modern-sql.com·31w31 weeks ago

Actions for GROUP BY ALL

Is JSON Predicate

modern-sql.com·79w79 weeks ago·Hacker News

Actions for Is JSON Predicate

The ANY_VALUE(…) Aggregate Function

modern-sql.com·119w119 weeks ago

Actions for The ANY_VALUE(…) Aggregate Function

The Curious Case of the Aggregation Query

modern-sql.com·131w131 weeks ago

Actions for The Curious Case of the Aggregation Query

SEARCH DEPTH/BREADTH FIRST

modern-sql.com·142w142 weeks ago

Actions for SEARCH DEPTH/BREADTH FIRST

GREATEST(), LEAST()

modern-sql.com·154w154 weeks ago

Actions for GREATEST(), LEAST()

MERGE

modern-sql.com·159w159 weeks ago

Actions for MERGE

GENERATED ALWAYS AS (…)

modern-sql.com·186w186 weeks ago

Actions for GENERATED ALWAYS AS (…)

Blaze-Persistence: Use Modern SQL like native JPA

modern-sql.com·300w300 weeks ago

Actions for Blaze-Persistence: Use Modern SQL like native JPA

Java & SQL, Stronger Together

modern-sql.com·318w318 weeks ago

Actions for Java & SQL, Stronger Together

My Interview in “The Art of PostgreSQL”

modern-sql.com·343w343 weeks ago

Actions for My Interview in “The Art of PostgreSQL”

Log in to enable infinite scrolling