|
you could use a closure to hide private variables. don't, though
|
# ¿ Oct 21, 2022 21:04 |
|
|
# ¿ May 12, 2024 19:48 |
|
i wonder if someone went thru the history of this thread and counted up the number of python issues that wouldn't have existed in a language with static typing, what % of the posts would that be
|
# ¿ Nov 15, 2022 00:07 |
|
numpy sucks, pandas sucks, gotta use it but it'll break so who tf knows don't use mysql ever, replace with postgres, everything will work fine then
|
# ¿ Dec 9, 2022 06:56 |
|
sql in bigquery is kind of weird, the language is not as flexible as in postgres, there are queries you just can't write. that's because under the hood it is not really a rdbms, it is more like a column store built on a giant map-reduce cluster. the sql-ish interface is just a facade. and most rdbms optimization techniques don't apply to bigquery either, for example there are no indexes if you write good clean sql in bigquery you may never notice its rough edges. part of this actually has to do with google's cost model. it is possible to construct some syntactically correct sql that bigquery will refuse to run, because it is inefficient in a way that you are not being appropriately billed for. postgres will just let you run the nasty query
|
# ¿ Jul 25, 2023 21:07 |
|
the biggest one i remember, this was a few years ago, was: "Correlated subqueries that reference other tables are not supported unless they can be de-correlated, such as by transforming them into an efficient JOIN" postgres would have just let me write the inefficient correlated subquery, because when the postgres sql grammar says "you can put any subquery here", they mean it. whereas bigquery is more like "you can put a subset of all subqueries here, specifically the ones that fit my execution model" the other issues were more like hitting resource limits, i remember having issues calling a complex function in a select, etc
|
# ¿ Jul 26, 2023 00:21 |
|
|
# ¿ May 12, 2024 19:48 |
|
yes but i want to embed all of my logic in the regex don't you see?
|
# ¿ Mar 5, 2024 06:04 |