MarkusWinand

7 ms·

1.
SQL /* comments */ can be nested(modern-sql.com)
1 points by MarkusWinand 7mo ago|0 comments
2.
by MarkusWinand 8mo ago
INSERT ... ON CONFLICT has fewer surprises in context of concurrency: https://modern-sql.com/caniuse/merge#illogical-errors Besides portability, there is IMHO nothing against INSERT ... ON CONFLICT if it does what you
3.
Without Overlaps Constraints in SQL(modern-sql.com)
1 points by MarkusWinand 8mo ago|0 comments
4.
Adieu Apache Derby, Welcome DuckDB(modern-sql.com)
3 points by MarkusWinand 9mo ago|0 comments
5.
Group by all: A popular, soon-to-be-standard SQL feature(modern-sql.com)
2 points by MarkusWinand 11mo ago|0 comments
6.
Survey on performance optimization for database systems (2023)(researchgate.net)
1 points by MarkusWinand 2y ago|0 comments
7.
The ANY_VALUE Aggregate Function: New in SQL:2023–and a better feature from 1999(modern-sql.com)
2 points by MarkusWinand 3y ago|0 comments
8.
GPT in 500 Lines of SQL(explainextended.com)
9 points by MarkusWinand 3y ago|0 comments
9.
Pspg: Unix pager designed for work with tables(github.com)
7 points by MarkusWinand 3y ago|0 comments
10.
by MarkusWinand 3y ago
> Making a pretty diagram where all the behaviours from various DBMSs are listed is left as an exercise to the author. :) It's there already! It's in the chart as footnote "b": Outer reference must be the only argumen
11.
by MarkusWinand 3y ago
No question, such a query should not be written. That's probably the reason why this odd behavior, which is even different in various DBMSes, is not causing everyday problems.
12.
by MarkusWinand 3y ago
> SQLite also ignores size restrictions on text columns; [...] requires a trigger. I'd go for CHECK constraints first: https://www.sqlite.org/lang_createtable.html#ckconst > Procedural SQL [...] Choose your inves
13.
by MarkusWinand 3y ago
The existing implementations (Oracle DB, SQL Server, MariaDB, Big Query) come with their problems too. I was a big fan of the new features when it came out in 2011, but pratically there is an unsolved elephant in the room: It doesn't c
14.
by MarkusWinand 3y ago
Fair point, looks suspicious on first sight. I've checked my tests briefly: It's accepted as table and column name. As mentioned in footnote [0] I haven't checked different contextes yet. Can you tell me: what kind of identif
15.
by MarkusWinand 3y ago
Author of the website here. All charts on modern-sql.com are backed by tests. I also keep them up-to-date by running them for new releases when they appear.
16.
by MarkusWinand 3y ago
I wonder why you are so focused on SQL:2011? Since then there was SQL:2016 and now there is SQL:2023. Also, which features in particular are you missing in PostgreSQL? Merge was added with PostgreSQL 15 a year ago: https://modern
17.
by MarkusWinand 3y ago
> The standard is not generally available. Most of us will never learn what is in it. It also not aimed at users, but at implementors. Funny enough, they don't read the standard either ;) But more seriously: Some implementations are
18.
by MarkusWinand 3y ago
I recently covered MERGE on modern-sql.com: https://modern-sql.com/caniuse/merge There I also look at limitations of some implementations and problems such as not reporting ambiguous column names — just guessing what y
19.
by MarkusWinand 3y ago
The rationale behind the width is more the ease of reading than anything else: https://en.wikipedia.org/wiki/Line_length But thanks for the feedback. There is a rework pending anyway.
20.
by MarkusWinand 3y ago
I'm studying the SQL standard for years now and compared to other standards that I know (XSLT, a little CSS, decades ago POSIX, C and C++) the SQL standard is really hard to make sense of. You might overestimate the value of having acc
21.
by MarkusWinand 3y ago
> It comes down to how you plan to shard data and distribute queries when data doesn't fit on a single node. A problem everbody would love to have but pretty much nobody actually has.
22.
by MarkusWinand 3y ago
This is one of the questions I try to answer at https://modern-sql.com/
23.
by MarkusWinand 3y ago
That particular one is already available in PostgreSQL 15. https://modern-sql.com/caniuse/unique-nulls-not-distinct
24.
by MarkusWinand 3y ago
Fixed. I wonder why Google sent me to http...
25.
by MarkusWinand 3y ago
Luckily pretty much nobody needs the standard documents. It's actually my aim at https://modern-sql.com/ to make the relevant information more accessible — in particular including support-matrices ("Can I Use&quot
26.
by MarkusWinand 3y ago
The major news are: - SQL/PGQ - A Graph Query Language - JSON improvements (a JSON type, simplified notations) Peter Eisentraut gives a nice overview here: https://peter.eisentraut.org/blog/2023/04/04&#x2
27.
SQL:2023 has been released(iso.org)
270 points by MarkusWinand 3y ago|133 comments
28.
SQL’s Merge: When Then Rules to Do Insert, Update or Delete(modern-sql.com)
2 points by MarkusWinand 3y ago|0 comments
29.
SQL: 2023 is finished: Here is what's new(peter.eisentraut.org)
2 points by MarkusWinand 3y ago|0 comments
30.
Michael Kay about XSLT, XML, and software business (2022)(youtube.com)
4 points by MarkusWinand 5y ago|0 comments

More ›