Stories by MarkusWinand

Adieu Apache Derby, Welcome DuckDB

Group by all: A popular, soon-to-be-standard SQL feature

Survey on performance optimization for database systems (2023)

The ANY_VALUE Aggregate Function: New in SQL:2023–and a better feature from 1999

GPT in 500 Lines of SQL

Pspg: Unix pager designed for work with tables

SQL:2023 has been released

SQL’s Merge: When Then Rules to Do Insert, Update or Delete

SQL: 2023 is finished: Here is what's new

Michael Kay about XSLT, XML, and software business (2022)

Log4Shell-like security hole found in popular Java SQL database engine H2

Graph Pattern Matching in GQL and SQL/PGQ

Evolution of tree data structures for indexing: more than it sounds

Is it time to modernize the PostgreSQL Core Team?

Blaze-Persistence: Use Modern SQL Like Native JPA

Lifting some of JPAs limitations to use more modern SQL

Java and SQL, Stronger Together

Background on PartiQL and the Volcano Model

SQL Successor, Cloud Wars, Volcano Model – Big News in Databases

SQL Performance Explained, the tuning book for developers, is free today

1
2
3