MarkusWinand

10 ms·

31.
Log4Shell-like security hole found in popular Java SQL database engine H2(nakedsecurity.sophos.com)
3 points by MarkusWinand 5y ago|0 comments
32.
Graph Pattern Matching in GQL and SQL/PGQ(arxiv.org)
2 points by MarkusWinand 5y ago|0 comments
33.
by MarkusWinand 5y ago
See also: https://winand.at/conferences/past Includes an updates version of the first slideset: https://modern-sql.com/slides/ModernSQL-2019-05-30.pdf
34.
Evolution of tree data structures for indexing: more than it sounds(erthalion.info)
7 points by MarkusWinand 6y ago|0 comments
35.
Is it time to modernize the PostgreSQL Core Team?(postgresql.fund)
2 points by MarkusWinand 6y ago|0 comments
36.
by MarkusWinand 6y ago
What Does ‘2ndQuadrant’ Mean?: https://www.2ndquadrant.com/en/what-does-2ndquadrant-mean/
37.
Blaze-Persistence: Use Modern SQL Like Native JPA(modern-sql.com)
2 points by MarkusWinand 6y ago|0 comments
38.
Lifting some of JPAs limitations to use more modern SQL(modern-sql.com)
2 points by MarkusWinand 6y ago|0 comments
39.
by MarkusWinand 6y ago
The polymorphic view as I would like them would enable us to re-use entiere <query expressions> (i.e. "subqueries") applied to different data sources (i.e. "tables"). E.g (made-up syntax) CREATE TEMPLATE VIEW
40.
by MarkusWinand 6y ago
Not only the grouping sets alone, the chaining of them. E.g. GROUP BY tenant , GROUPING SETS ( (year, month) , (year) ) is equivalant to GROUP BY GROUPING SETS ( (te
41.
by MarkusWinand 6y ago
Thx, updated.
42.
by MarkusWinand 6y ago
The most important code management tool SQL has are views and the WITH clause. https://modern-sql.com/use-case/literate-sql Something like "polymorpihc" views would be extremley useful, but is not there yet (
43.
by MarkusWinand 6y ago
> for instance the order of conditions in the where clause matter if you want to leverage a multi-column index Ups, if this is you take away, then I've done something wrong. Let me correct that: The order of columns in an index
44.
Java and SQL, Stronger Together(modern-sql.com)
2 points by MarkusWinand 6y ago|0 comments
45.
Background on PartiQL and the Volcano Model(winand.at)
1 points by MarkusWinand 7y ago|0 comments
46.
SQL Successor, Cloud Wars, Volcano Model – Big News in Databases(winand.at)
2 points by MarkusWinand 7y ago|0 comments
47.
SQL Performance Explained, the tuning book for developers, is free today(sql-performance-explained.com)
70 points by MarkusWinand 7y ago|13 comments
48.
Modern Data Practice and the SQL Tradition(tselai.com)
286 points by MarkusWinand 7y ago|221 comments
49.
Oracle DB 19c improves JSON standard conformance(modern-sql.com)
3 points by MarkusWinand 7y ago|0 comments
50.
New in SQL: Graph and Stream Processing, Multidimensional Arrays(winand.at)
1 points by MarkusWinand 7y ago|0 comments
51.
New in the SQL Standard: Multidimensional Arrays, Graph and Stream Processing(winand.at)
2 points by MarkusWinand 7y ago|0 comments
52.
by MarkusWinand 7y ago
You are mixing two concepts here: 3VL and how most aggregates work in SQL: the drop NULL values before doing their work. That's why the first BOOL_AND example only sees one value, thus returning true.
53.
by MarkusWinand 7y ago
> What SQL lacks (in this case), but the relational model not, is the ability to nest relations as easily as JSON. SQL has nested relations since SQL:2003[1] (called multisets). They are not widley supported and frankly speaking I don&#x
54.
by MarkusWinand 7y ago
WITH is supported by all major SQL brands in the meanwhile. https://modern-sql.com/feature/with#compatibility
55.
A Close Look at the Index Include Clause of SQL(use-the-index-luke.com)
1 points by MarkusWinand 7y ago|0 comments
56.
MySQL 8.0.16 released: finally honoring CHECK constraints(mysqlserverteam.com)
1 points by MarkusWinand 7y ago|0 comments
57.
by MarkusWinand 8y ago
Very well spotted! I've just fixed that. One of my test cases was binding that paramter as 'numeric' rather than 'interger'. The other DBs didn't care about that.
58.
by MarkusWinand 8y ago
Welcome. But db-engines.com is not my site (but also run by Austrians ;)
59.
by MarkusWinand 8y ago
In principle yes, it is even mentioned in footnotes of the matrix (2, 3).
60.
by MarkusWinand 8y ago
Since you ased about indexing in particular, here is my site about indexing: https://use-the-index-luke.com/ You might also want to follow my other project: https://modern-sql.com/

More ›