Markus Winand
@winand.at
SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of http://use-the-index-luke.com and http://modern-sql.com.
Ich hab den standard nie so interpretiert. Aktuell (SQL:2023) wurde es aber konfigurierbar gemacht: modern-sql.com/caniuse/F292
F292, “UNIQUE null treatment”
Explicit null treatment in unique constraints is not widely supported
modern-sql.com
October 21, 2025 at 4:40 AM
Ich hab den standard nie so interpretiert. Aktuell (SQL:2023) wurde es aber konfigurierbar gemacht: modern-sql.com/caniuse/F292
Because it is a list of lists.
September 24, 2025 at 6:22 AM
Because it is a list of lists.
My favorite change is that MariaDB got an improved implementation of the WHERE year(...) = ? rewriting. use-the-index-luke.com/blog/2024-12...
In picture: the green check mark used to be yellow, with the "a" footnote: Unconditionally rewritten — even if only a matching function-based index exists
In picture: the green check mark used to be yellow, with the "a" footnote: Unconditionally rewritten — even if only a matching function-based index exists
September 5, 2025 at 9:31 AM
My favorite change is that MariaDB got an improved implementation of the WHERE year(...) = ? rewriting. use-the-index-luke.com/blog/2024-12...
In picture: the green check mark used to be yellow, with the "a" footnote: Unconditionally rewritten — even if only a matching function-based index exists
In picture: the green check mark used to be yellow, with the "a" footnote: Unconditionally rewritten — even if only a matching function-based index exists
Https://use-the-index-luke.com/ :)
June 16, 2025 at 6:25 AM
Https://use-the-index-luke.com/ :)
Reposted by Markus Winand
SQLite can serve as a robust container format, offering transactions, indexing, and SQL querying. Compared to ZIP, it adds structure but also overhead. It's a powerful option for complex structured data files. #Databases 6/6
May 26, 2025 at 3:00 AM
SQLite can serve as a robust container format, offering transactions, indexing, and SQL querying. Compared to ZIP, it adds structure but also overhead. It's a powerful option for complex structured data files. #Databases 6/6