213 karma · joined December 15, 2024
It is important that “profit”, comes in various forms, which exchange rates are problematic to calculate (or maybe there can’t be any): not hungry, not thirsty, tastes good, not cold, feel safe, feel excited, feel righteous, feel powerful, listen to music, watch a movie, get curious, satisfy curiosity, laugh, love, sex, rock n roll.
- non standard sql
- not concise
- has limitations
- installing a function is a db migration
I had dreams. A lot of them. I still do some times.
“Normal language” functions accept/return: primitives, objects(, functions, types).
Sql functions could accept/return: scalars/primitives, a row, set of rows, a table (maybe set of tables or related rows), for aggregating functions need to group by some columns, sliding window functions need to keep track of the window.
Let’s add some kind of interfaces/traits and generics.
If we are extending current sql, then I’m certain there will be corners cases for various clauses sql clauses (select, from, on, where)
And all of that on top of basic sqls (sel/ins, checks, access controls, query execution planning)
Quite quickly c++ starts to look like an exercise in language minimalism.
Imagine well structured tables in 3rd normal form.
And then a view which joins 20 tables and creates a report with myriad of case/then expressions.
Many things can go wrong. (Wrong join conditions, duplicate rows, omitted rows, wrong formulas)
You might say that there should be no such logic in database and I understand the sentiment, but circumstances (e.g. performance) might say it’s needed.
I think same sentiment persists when alpha->”your leader” replacement is made.
(South park had interesting episode on that)
Could you elaborate what is the meaning of “alpha”? (I sense there is definition, that is being kept secret from me)
https://research.google/pubs/sql-has-problems-we-can-fix-the...
https://www.scattered-thoughts.net/writing/against-sql/ - talks about compositionality
https://www.edgedb.com/blog/we-can-do-better-than-sql (2019)
(List taken from https://lobste.rs/s/vmyk7d/composable_sql#c_layb8n)
(I very much would like any AI generated text to be marked as such, so I can set my trust accordingly)
Introducing n+1 solution/ standard may be the necessary cost of making progress, but it is possible to incur that cost without gaining anything
(at the extreme, trolling is fun activity with net negative on bigger scale)
I was fixating on the opposition of goals in the car (if car doesn’t bend/deform, then death risk increases).
Cars being on the move, makes that distinction much much more relevant
Seems reasonable that more people will be able to utilise programability of computers.
People who already created elaborate spreadsheet’s with formulas, now might start also using python/java/go for their benefit. (Eg. Accountant, might start helping with the accounting system maintenance)
All in all, my life would be miserable if I would not have regexp available in grep/sed/editor/ide/java/python, their usefulness trump any such inconveniences.
- Scope of the library is massive
- very peculiar way of writing, with lot of impressively unnecessary description of minute detail, that the reader starts counting not only sheep but also breaths until the ultimate end before finishing a sentence. (I.e. Unnecessarily verbose)
- very extensive docs describing things from various angles including references, topic based how tos and such.
(I agree that the last one is the least likely, but there is always hope)
How much value does this room provide you? If you can pay 2x, then it implies value you get is also 2x.
Third degree price discrimination is not as catchy. https://www.investopedia.com/ask/answers/042415/what-are-dif...
Really?
I mean rap songs and movies have both, as far as I can tell they are used interchangeably.
Any chance the distinction existed long time ago and now it does not anymore? (Im not from US)
Statement bordering on papyrophobia. (Seems that is a real phobia)