zlacker

[parent] [thread] 6 comments
1. DaiPlu+(OP)[view] [source] 2024-08-24 16:16:31
The first-page of the paper has 13 co-authors listed - but all with the same affiliation ("Google, Inc") - so this is ultimately a single-vendor making a unilateral proposal to break with the past - which means I'm confident this proposal won't be gracing the pages of the ISO/IEC 9075 (ISO SQL) standards in my lifetime - no matter how badly we all need QoL improvements to SQL.

...okay, if I dial-back my feelings of resignation to mediocrity, then I'll admit that Google probably does have enough clout to make this go somewhere - but they'd need to add this to all their database offerings (BigQuery, Spanner, Firebase's SQL mode) and contribute patches to Postgres and MySQL/Maria - maybe after Microsoft relents a decade later to add it to MSSQL we'll maybe start to see Oracle's people refer to it vaguely as a nice-to-have they'll implement only after they start losing more blue-chip customers[1].

Also, it's giving me M (Excel PowerQuery) vibes too.

-------

[1]For context, Oracle's DB lacked a `bit`/`bool` column type for the past 40 years until last year. People had to use `char(1)` columns with CHECK constraints to store '0'/'1' - or worse: 'T'/'F' or 'Y'/'N' (see https://stackoverflow.com/a/3726846/159145 )

replies(2): >>0cf861+S3 >>bhawks+S9
2. 0cf861+S3[view] [source] 2024-08-24 16:46:40
>>DaiPlu+(OP)
>… People had to use `char(1)` columns with CHECK constraints to store '0'/'1' - or worse: 'T'/'F' or 'Y'/'N'

If you are truly blessed you get to see all of these in a single database. Also “Yes”/“No” with that specific casing.

replies(2): >>DaiPlu+m5 >>orthox+49
◧◩
3. DaiPlu+m5[view] [source] [discussion] 2024-08-24 17:00:53
>>0cf861+S3
Not to be outdone: https://thedailywtf.com/articles/what_is_truth_0x3f_
◧◩
4. orthox+49[view] [source] [discussion] 2024-08-24 17:32:39
>>0cf861+S3
"Check constraints make the database run slower, just don't generate any values other than YN in the application layer"

You can guess how many foreign keys that database had.

replies(1): >>datadr+fi
5. bhawks+S9[view] [source] 2024-08-24 17:39:12
>>DaiPlu+(OP)
And to be fair it is not like any database implementations implement the entire spec, or that the spec itself is nearly as long as the C++ but still very underspecified.

Piped SQL fits in perfectly with the overall SQL pot-luck buffet! I for one welcome Google to the table, enjoy the language that works everywhere and nowhere but is the best there is.

◧◩◪
6. datadr+fi[view] [source] [discussion] 2024-08-24 18:39:11
>>orthox+49
Must have been super fast though
replies(1): >>DaiPlu+3K
◧◩◪◨
7. DaiPlu+3K[view] [source] [discussion] 2024-08-24 22:08:27
>>datadr+fi
Not just fast, it's web-scale

https://www.youtube.com/watch?v=b2F-DItXtZs

[go to top]