HNHacker News
TopNewBestAskShowJobs

ttz

470 karma · joined August 24, 2019

barely passable backend developer.
submissionscomments
ttz··on Fun with Red Star OS
anyone know how get that miller column KFinder app outside of installing RedStar? Don't actually think anything exists like that for Linux (minus Elementary File Manager)
ttz··on Pfeilstorch
Whatever concept you can think of, it is likely that there is already a German word for it ;)
ttz··on China unveils 600 kph maglev train
> It's more accurately a common law problem. European states with Napoleonic law appear to avoid the cost spiral.

Asking out of genuine interest - do you have any ideas as to why this might be?

ttz··on Building a data team at a mid-stage startup
Funnily enough, this is what I did, except I built an app where I write the queries as "pre-built" parameterized ones (sanitized, of course).

People still do a bunch of stuff in Excel, though, and every once in a while, it breaks, and I have to dig through the mess. Excel is great when it's just for yourself and you can manage it... it's a pain when others have to figure out someone else's.

ttz··on Building a data team at a mid-stage startup
> MBA types

I chuckled. Then cried, because at least his MBA types can use SQL. My MBA types use Excel.

OT: Good article. Like and agree with the push for centralizing data first, then building outwards so external teams can move towards self-service.

ttz··on Survey shows people no longer believe working hard will lead to a better life
> far above even surgeons or lawyers or engineers, who work very hard and are just as smart as the ultra-rich

I've been seeing this assumption float around quite a bit around HN. Where is this coming from? Where is this belief that "ultra-rich" or "having interest in money" implies intelligence?

Not saying one way or the other. Just genuinely curious.

ttz··on If your product helps people, it is your moral duty to promote it
I think if you've got good evidence that it is actually effective, it is "net better" to promote its usage.
ttz··on Learn R Through Examples (2020)
To add: in my experience, programmers who denigrate R think of it as a software engineering language. Not all programming languages are meant to be languages for building large scale applications. Programming is not just about building business applications, it's about getting a computer to do things.

And R excels at doing statistics and data science. If you keep that mindset, I believe many will find that its an excellent programming language.

ttz··on The Query Your Database Can’t Answer
Am I misreading something here?

> Namely, you can’t write a query whose result updates every time the underlying data change

Yeah, you can. With triggers. Or just a plain old view.

ttz··on Pupil Size Is a Marker of Intelligence
Intelligence is a precisely defined and precisely measurable notion, so of course we can precisely correlate it with physical measurements [/sarcasm]
ttz··on America has a drinking problem
Emptiness, in some cases. Imagine living a life of poverty, or being trapped in a situation you realize you don't have the tools or privilege to escape (having to care for many dependents, no time to go to school, or can't afford to pay for it because you're trying to scrape enough for rent).

Having no direction or hope for a better future (perceived or real) has driven people I've known to alcoholism.

Not an excuse. Just a perspective.

ttz··on In Mexico, cartels are hunting down police at their homes
> fight trafficking

The message the cartel is sending to those who are trying to do exactly this seems like a strong deterrent.

Not saying it's a bad idea. But there is ample evidence of police not being paid enough and accepting "bribes" (I use quotes here because I think the negative connotation is unfair, somewhat, when a lot of this happens simply because they don't make enough in the first place - it's a different moral worldview when you're trying to support your family), so I don't know if it would be easy to stop them from being "corrupted", or "paid off", especially if the service is compulsory.

I think in general, the issue is super complicated, and if there were a simple panacea or idea, it would have been tried by now. I honestly don't know what can be done to stop the cartels with the amount of economic clout they have and how entrenched they are in all aspects of society.

There's a great line in Narcos (apologies for using a show, but I really think it's a very applicable line); a colonel was asked what he needed to stop Escobar, and he said "Incorruptible men".

Incorruptible men are very hard to come by. Incorruptible men who don't fear their families being slaughtered are probably even harder to come by.

ttz··on SQL Query Optimization: Understanding Key Principle
the key principle to query optimization is understanding your data, considerate indexing, and keeping your statistics up to date. not avoiding slow JOINs and doing denormalization.

super, super, super bright people who have been working on this stuff for longer than some devs have been alive write the query planner logic. the query planner relies on good statistics to run optimally. indexes on stuff you might care to query about help it even more.

but truly understanding your data helps you reason and think like the planner might. how many rows will this subquery return on average? how many will the planner think there is? if these two answers are really off, then planner might choose a bad plan. so maybe you can rewrite your query a little bit - rethink an approach to getting the same result, but in a way that the planner will choose a better plan. maybe use an EXIST vs an IN.

anecdotally, I've seen some devs struggle with queries and data because they think that one approach will always work, because they think that it's always the algorithm that matters. but when it comes to data - it's the data that matters.

ttz··on [dead]
>If everyone prioritized wealth equally, then the overall statistics would show higher IQ correlating with more wealth.

This seems like unjustified conjecture. There are so many variables at play in determining the ability to gain wealth; if I'm "high IQ" (rolling my eyes at this term) and want to gain wealth, but I have to care for my ailing mother, or raise four children on my own, will I succeed?

One can make a lot of money on YouTube without needing a formal education, and I struggle to see how you would measure the "IQ" of the successful YouTube stars.

Isn't there a flawed assumption that you need a high paying job that requires high IQ to amass wealth?

ttz··on Using PostgreSQL as a Data Warehouse
In my experience (which doesn't mean I'm disagreeing with your experience), it's not that upper mgmt doesn't recognize the value of BI - they just don't want to invest in it. They want their cake without having to pay for it. It can be hard to find a place with mgmt that really understands that investing in developer velocity and good infrastructure pays way more dividends in the long term than constant short term "promise X, deliver X*0.8 to make customer think they got what they want, and repeat to get the contract".

But yeah, we could complain on and on about all the problems of shortsighted management... it's a tale as old as time.

ttz··on Using PostgreSQL as a Data Warehouse
> It’s well worth it to make the BI team go through an API, even spend the effort on a well-designed one to give them a nice experience doing so.

In an ideal world yes. But sometimes, the engineering team wants nothing to do with the data itself, and so the BI team is often left to do what they can with what they have in order to do their job at all.

Being a data engineer, both sides of the coin often fall on me, and so I understand the difficulties on both side. Almost always (anecdotally, so take with grain of salt), the problem lies with upper management because they aren't willing to invest the time to actually build a proper infrastructure in place; the focus is on building features to satisfy clients, without much thought on how this can affect the overall internal system, and so both sides have to rush to do things without thinking how it affects the other side. However, it likely won't change because at the end of the day, the client is happy - whether or not this is a "unfortunate reality" of business/tech, is a discussion for another day.

ttz··on Using PostgreSQL as a Data Warehouse
So if engineering team uses an ORM, pushes a massive API change that renames columns and removes others, and drops FKs, and leaves it as a change item in a release list in an access controlled repo without notifying anyone, it's BI team's fault the DW ETL breaks?

IMO it's not fruitful to throw blame on teams or call them unskilled. Usually, everyone is trying their best to do their job, and things that make this not happen should be seen as "how can we improve/fix this" - better communication is almost always the solution.

ttz··on Tani Adewumi is now a chess master
Fair point. I was specifically comparing "regular" stream calculus vs a special "gifted" class (in the elitist, "my parents have more money" sense) ; I see now you were thinking more of "a subsidized opportunity for people in disadvantaged situations to be exposed to higher level mathematics", in which case, I agree with you.
ttz··on Tani Adewumi is now a chess master
If you're gifted/have qualities that will enable you for success, I struggle to see how not taking advanced calculus will be to your detriment, or affect your ability to be noticed.

Ramanujan read a bunch of textbooks. He certainly did not have the luxury of advanced calculus courses (which isn't even a good representation of research mathematics). He's one of the greatest mathematical geniuses of all time.

ttz··on Maxwell’s Demon Continues to Startle Scientists
Maxwell was - to put it mildly - a pretty bright guy.
ttz··on How to deal with difficult people on software projects
Reading some of the comments here (and the vitriol), am I wrong in thinking that this site was meant as a joke? Because I totally read it as such...
ttz··on Elizabeth Holmes trial delayed because she’s pregnant
If Holmes and Sunny walk, then it will be the Nth time we are reminded how broken the criminal justice system is with regards to white collar crime...
ttz··on Four times I felt discriminated against for being a female developer
I'm quite aware of the etymology of the word "slave". Why is that relevant at all to this discussion?

It's about socioeconomic and class status. There are lots of poor white communities that suffer serious oppression and missed opportunities too, but that's not the point of my post, or why I found your post disgusting. There are lots of rich East Asian people who've never had to do any manual labor in their life, or worry about their infant not being able to eat; just as there are East Asians who watched as Japanese soldiers tore the infants from their pregnant mother. Or German/Russian Mennonites who watched as Slavic peoples(as you call them) come in and murder their village. The common denominator here is class, power, and social status, not race.

Are you saying that the rich and poor have equal human experience? Please, answer that point first, instead of redirecting into this tired anti-"white guilt" narrative.

ttz··on Four times I felt discriminated against for being a female developer
Oh please. Spew this BS elsewhere to people who are actually gullible enough to not see through this rhetorical regurgitation.

Human experience is not universal. Try going back in time and be a slave. Or a victim of the Nanjing rape. Tell me, with a straight face, that you can truly understand the pain and suffering those people went through. You think a royal family member can understand what it is like to be whipped and denied all manner of opportunity?

Frankly, this comment disgusts me.

ttz··on Google’s approach to Black schools explains why there's few Black engs in Tech
Yes, if they said they were going to.

> whats wrong with our politics

Lobbyists, the need for fundraising by officials putting them in the pockets and interests of corporations and entities... do we really want to go there? Corporations and entities have incredible influence in politics; to not acknowledge this would be disingenuous. Politics is driven by money, idealism be damned, and Alphabet has a lot of this. Why shouldn't one expect them (well, their subsidiary, Google) to back up what they said?

To be fair, I also understand where you're coming from. I'm from a privileged socioeconomic class, from a tech industry perspective. So it's easy for me to say "I don't want to get into the politics because it doesn't affect me; all I want is reasonable search results and for them to leave me alone". We have (or were able to earn because we had the resources) the baseline privileges and advantages in life that enable us to have this attitude. But some groups still don't, and it's my belief (and hopefully, society's someday) that we should effectively (not just rhetorically or trivially) give them the pathways to level the playing field.

ttz··on Dolt is Git for Data: a SQL database that you can fork, clone, branch, merge
"Barely usable for daily tasks"

Is a pretty strong statement, especially given many tech companies use it exactly for this purpose.

Git might have a learning curve, and sure, it's not the simplest. But "barely usable" is hyperbole in the face of actual evidence.

I'm not defending Git specifically ; other SVNs are just as viable. The quoted statement seems a bit ridiculous.

ttz··on Dolt is Git for Data: a SQL database that you can fork, clone, branch, merge
Git is used prolifically in the tech industry. What on earth are you talking about?
ttz··on Why SELECT * is bad for SQL performance (2020)
Using LIMIT N is a great habit to develop to prevent yourself from hogging resources too, during exploration.
ttz··on US raises ‘deep concerns’ over WHO report on Covid’s Wuhan origins
Priors matter here, as we have no good data to actually verify or refute the issue, because Chinese gov't won't release the early data for scientific community at large around the world to analyze. So you can only rely on:

- do I trust the WHO - do I trust the CCP

I don't really trust either - but this is just my opinion, based on my interpretation of historical events and evidence. We are all adults here, we can choose to agree or disagree - that's what makes forums and free speech really work.

Some of my reasons for my choice to not trust the CCP:

The Chinese government has numerous reports of it conducting human rights abuses against Uighurs and other populations (Falun Gong, etc). There is constant state denial, but in my eyes, the evidence is compelling. Let's not play the "oh but other countries do this too" - other countries are not relevant to the issue at hand, and my opinion on them is similarly irrelevant here.

If you want to be absolutely pedantic, sure, we have no evidence to conclusively say anything - we also can't say evolution is correct, but it's the most likely theory given prior evidence. Note that my original post says that we have no smoking gun evidence (and again, I'd really want to stress, my original post was OPINION. It was meant in passing, but somehow it got the attention of people on both sides who clearly have a bone to pick).

But, in the "balance of probabilities", my priors suggest to me that I wouldn't trust the CCP. I'm not saying I'm right. I'm not saying you need to believe me. I am simply exercising my right to say my opinion, based on what I think are fairly reasonable priors given CCP track record.

CCP isn't an evil regime, which I feel like is what some of the stauncher replies in this thread feel that any criticism of the party secretly says. They've done great things for the country and its people. Healthcare, stability, infrastructure, and tried to right the wrongs of Mao and the GLF. But that doesn't mean you have to trust everything a government says. Your parents provide you with food and shelter, it doesn't mean you need to blindly believe that they are incapable of doing dishonest things.

This is also not an attack on the Chinese people, contrary to some silly posts I've seen saying "demonizing the CCP means demonizing thr Chinese people". I totally understand why Chinese people tolerate the government. When you emerged from a generation that suffered incredible rural poverty, like my own family, a government that promises you a stable paycheck, food, and housing seems reasonable to support and stay loyal to. I am fortunate enough that my father was talented and lucky enough to be able to leave for a country where we could obtain those things without needing to profess that loyalty unflinchingly.

ttz··on US raises ‘deep concerns’ over WHO report on Covid’s Wuhan origins
Down votes or up votes don't matter to me - I'm just glad (and surprised) that what I thought was basically an innocuous "IMO" comment generated so much discourse.

Isn't this the point of public forums? To encourage discussion?

← PreviousPage 2 of 3Next →