Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
snidane
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
14 ms
·
61.
▲
by
snidane
4y ago
Labor shortage is a wage shortage is a housing shortage is an urban land shortage. When housing is so expensive, why would low wagies bother if they can't afford a rent. They end up on the street regardless of working. Housing shortage
62.
▲
by
snidane
4y ago
> Take real-time products, for example. Most businesses have little use for true real-time experiences. But, all else being equal, real-time data is better than latent data. Only if you stare at a chart on a dashboard. If you do serious
63.
▲
by
snidane
4y ago
Crypto is just what you get in a zero interest rate world. That's how it started (fear of money inflation). With interest rates in steady state rates, people would choose wisely if it's better to stash money into a regular savings
64.
▲
by
snidane
4y ago
Good. Finally one positive impact crypto has on the world. After it all crashes, hopefully these rust coders will find their way into traditional finance and tech and displace C++.
65.
▲
by
snidane
4y ago
Many times non-technical project managers were useless. Just overpaid glorified secretaries trying to take meeting notes, often losing valuable information in translation. It made sense to rebrand to other job titles so as not to attract th
66.
▲
by
snidane
4y ago
Issues in real estate and land markets stand behind the biggest societal problems that the human population is experiencing in early 21th century. There is no economical school or theory which covers real estate and land markets. All contem
67.
▲
by
snidane
4y ago
I don't understand why "some logs used for plotting metrics have near-zero debugging value (e.g. a log line that just includes the timestamp and the message "event x occurred"). Those kinds of logs should be fully conver
68.
▲
by
snidane
4y ago
I am not very educated in this area, but I wonder why move away from the concept of metrics extracted from logs to discarding logs and storing just the metrics? Don't metrics have to be defined first? I assumed you'd first do a bi
69.
▲
by
snidane
4y ago
Why 200 years, an not say few million years? Used to be more CO2 and plants liked it better. Definitely grew higher back in those days. I suspect the answer 200 because it is assumed these days that CO2 produced since 1800 is all man made.
70.
▲
by
snidane
4y ago
If the rock dust captures so much CO2, what will the plants breathe?
71.
▲
by
snidane
4y ago
Clickhouse implements an explicit SEMI join. It can be called semi or any, it doesn't really matter. It's just another join modifier [OUTER|SEMI|ANTI|ANY|ASOF] https://clickhouse.com/docs/en/sql-
72.
▲
by
snidane
4y ago
It does make sense for semi-joins. I care about the key, not the value. Random order is also a valid order.
73.
▲
by
snidane
4y ago
It's easier not to mess up table based filters using explicit semi-join operators (eg. in, not in, exists) instead of using regular joins because joins can introduce duplicates. Give me 'any join' operation - ie. just select
74.
▲
by
snidane
4y ago
Array notation is great, but only for single array operations and for dense array operations. The moment you need to run complex group bys and store non-contiguous data efficiently, it gets awkward pretty quick. On the other hand, operation
75.
▲
by
snidane
4y ago
It's called "land" because it is one of the three original factors of production in classical economics - labor, capital and land. Labor is energy, Capital is accumulation of energy. Land is any natural opportunity. Domains,
76.
▲
by
snidane
4y ago
Unlikely that georgist system would get adopted gradually. It never worked in history. Denmark georgist party (Justice party of Denmark) never got a strong popular support. When they got some attention and implemented georgist policies, ves
77.
▲
by
snidane
4y ago
Your assessment is correct. The fact that implementing such a simple scheme as LVT would lift up many societal issues suggests that the entire problem that it aims at is the society's bottleneck. From system design we know that no matt
78.
▲
by
snidane
4y ago
From Henry George wikipedia page: > Commentators disagreed on whether it was the largest funeral in New York history or the largest since the death of Abraham Lincoln. The New York Times reported, "Not even Lincoln had a more glorio
79.
▲
by
snidane
4y ago
Georgists divide into two categories. They define land differently, or emphasize different aspects of it. 1. Left wing georgists. Land = resource needed for human life. Humans cannot fly, therefore land is a life necessity. Food grows on la
80.
▲
by
snidane
4y ago
Allow referencing columns defined previously in the same query would make duckdb competitive for data analytics. Without that one has to chain With statements for just the tiniest operations. select 1 as x, x + 2 as y, y/x as z;
81.
▲
by
snidane
4y ago
It looks as far from a data oriented language as it can be. It's yet another algol, specifically javascript/typescript variation. How does it help with joins, group bys, pivots, explodes, etc? No mention of those, just some javasc
82.
▲
by
snidane
4y ago
It's a maximally open question which turns into a guessing game where you are trying to match what the interviewer has on their mind at a given point. Some of them just want you to collect requirements, which makes them feel smart beca
83.
▲
by
snidane
4y ago
Houses lose value by depreciation. In few decades the value is zero, then becomes negative - the price of demolition for the next project. What gains value over time is land. Poeple only think they invest in houses, but they are fooling the
84.
▲
by
snidane
4y ago
What matters is prioritization and momentum. You're gonna get more people aligned if you focus on things that other teams happen to be working on at the same time. If you decide to work on something else when there is a huge infrastruc
85.
▲
by
snidane
4y ago
The modern Agile sweatshop is the one that manages by deadlines using timeboxed sprints. Not very agile by definition, yet the term stuck and people better find a new one.
86.
▲
by
snidane
4y ago
kdb and similar systems have had it for years. https://code.kx.com/q4m3/2_Basic_Data_Types_Atoms/#253-date-... Float is an imprecise transformation from text to a binary fixed size representation. I don't see
87.
▲
by
snidane
4y ago
Nitpick about date formats. 2013-02-27 is the current standard, but more so as a result of "this is how we've done things" and not "this is the best way to do it". The hyphens make the notation ambiguous with substr
88.
▲
by
snidane
4y ago
Urban sprawl is an expansion of a single city as the land in its center rises. It applies to both small and large cities and it doesn't mean people moving from a larger city to a smaller one, unless the smaller city's area overlap
89.
▲
by
snidane
4y ago
Isn't the typical big data sql task IO bound? Vectorization only works when you have a table stored in an optimized columnar format and compute an run a function over a column or to combine multiple columns. The moment you throw in gro
90.
▲
by
snidane
5y ago
Covid vaccines got the emergency authorization and still keep it because there "is not" an adequate drug for covid. It totally makes sense from pharma to prevent discovery of a functioning drug because they found a better cash cow
More ›