MarkusWinand

1,995 karmajoined January 17, 2014On HN

Autor, Trainer, Coach.

All about SQL:

https://winand.at/ https://use-the-index-luke.com/ https://modern-sql.com/

Recent submissions

SQL /* comments */ can be nested modern-sql.com
1MarkusWinand7modiscuss
Without Overlaps Constraints in SQL modern-sql.com
1MarkusWinand7modiscuss
Adieu Apache Derby, Welcome DuckDB modern-sql.com
3MarkusWinand8modiscuss
Group by all: A popular, soon-to-be-standard SQL feature modern-sql.com
2MarkusWinand10modiscuss
Survey on performance optimization for database systems (2023)researchgate.net
1MarkusWinand1ydiscuss
The ANY_VALUE Aggregate Function: New in SQL:2023–and a better feature from 1999 modern-sql.com
2MarkusWinand2ydiscuss
GPT in 500 Lines of SQL explainextended.com
9MarkusWinand2ydiscuss
Pspg: Unix pager designed for work with tables github.com/okbob
7MarkusWinand2ydiscuss
SQL:2023 has been released iso.org
270MarkusWinand3y133 comments
SQL’s Merge: When Then Rules to Do Insert, Update or Delete modern-sql.com
2MarkusWinand3ydiscuss
SQL: 2023 is finished: Here is what's new peter.eisentraut.org
2MarkusWinand3ydiscuss
Michael Kay about XSLT, XML, and software business (2022)youtube.com
4MarkusWinand4ydiscuss
Log4Shell-like security hole found in popular Java SQL database engine H2 nakedsecurity.sophos.com
3MarkusWinand4ydiscuss
Graph Pattern Matching in GQL and SQL/PGQ arxiv.org
2MarkusWinand4ydiscuss
Evolution of tree data structures for indexing: more than it sounds erthalion.info
7MarkusWinand5ydiscuss
Is it time to modernize the PostgreSQL Core Team?postgresql.fund
2MarkusWinand5ydiscuss
Blaze-Persistence: Use Modern SQL Like Native JPA modern-sql.com
2MarkusWinand5ydiscuss
Lifting some of JPAs limitations to use more modern SQL modern-sql.com
2MarkusWinand5ydiscuss
Java and SQL, Stronger Together modern-sql.com
2MarkusWinand6ydiscuss
Background on PartiQL and the Volcano Model winand.at
1MarkusWinand6ydiscuss
SQL Successor, Cloud Wars, Volcano Model – Big News in Databases winand.at
2MarkusWinand6ydiscuss
SQL Performance Explained, the tuning book for developers, is free today sql-performance-explained.com
70MarkusWinand6y13 comments
Modern Data Practice and the SQL Tradition tselai.com
286MarkusWinand6y221 comments
Oracle DB 19c improves JSON standard conformance modern-sql.com
3MarkusWinand6ydiscuss
New in SQL: Graph and Stream Processing, Multidimensional Arrays winand.at
1MarkusWinand7ydiscuss
New in the SQL Standard: Multidimensional Arrays, Graph and Stream Processing winand.at
2MarkusWinand7ydiscuss
A Close Look at the Index Include Clause of SQL use-the-index-luke.com
1MarkusWinand7ydiscuss
MySQL 8.0.16 released: finally honoring CHECK constraints mysqlserverteam.com
1MarkusWinand7ydiscuss

All submissions and comments on Hacker News.