2,609 karma · joined October 28, 2012
twitter.com/frasergeorgew
george at fivetran dot com
It’s a deterministic subset of Python. This means that if you have complex or repetitive configurations, you can use loops and functions to structure them. But it’s impossible to write an infinite loop or recursion.
Meanwhile, cortical column fans (including neuroscientists!) engage in a motte-and-bailey argument, where the bailey is “the cortex is divided into columns that represent an intermediate level of modularity” and the motte is “neurons on top of each other usually have similar firing properties”.
The idea of cortical columns isn’t like the 6-layer-cortex. The cortex just isn’t organized into little column-shaped modules. It’s true that if you record two neurons right on top of each other, they’ll have a similar receptive field/preferred direction/…. BUT there is no consistent horizontal organization of neurons into columns. There’s whisker barrels, which reflect the way rat and mouse whiskers work, and there’s ocular dominance columns, which are a totally different thing at a different spatial scale. But there’s no global organizing principle that should be called “cortical columns”. It’s a lovely idea that would be great if it were true—-it would be so much easier to understand the brain if there were a common unit of organization larger than a neuron but smaller than a brain! But it’s not so.
SELECT dimension, measure
FROM table
WHERE filter = ?
GROUP BY 1
You can save a lot of compute time by creating a materialized view [1] of: SELECT dimension, filter, measure
FROM table
GROUP BY 1, 2
and the query optimizer will even automatically redirect your query for you! At this point, the main thing we need is for BI tools to take advantage of this capability in the background.[1] https://docs.snowflake.com/en/user-guide/views-materialized....
As long as you're willing to give up stereopsis, and you have only 1 viewer on each side, I think you could accomplish this type of immersive telepresence with an ordinary TV + software.
[1] https://www.youtube.com/watch?v=Ufp8weYYDE8 [2] https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4934608/
- Only one recipe.
- Vetted to be high quality.
- Gets straight to the point.
The internet is amazing but for a lot of domains books are way better.
Federated data systems, like what is described in this post, are a kind of “nerd trap.” They’re fascinating and people keep building them, but they have little real world utility. Everyone is either big enough where it’s worth it to build a real data warehouse, or small enough that they shouldn’t be messing around with complex data infrastructure.
https://onlinelibrary.wiley.com/doi/full/10.1002/soej.12475
But the same research group found that BLM protests did not:
https://www.nber.org/papers/w27408
It's possible that both are true, but it's a bit suspicious that these findings are so well-aligned with the probable political associations of the authors.