HNHacker News
TopNewBestAskShowJobs

mjirv

1,361 karma · joined June 21, 2014

Software and analytics engineer

https://delphihq.com

submissionscomments
mjirv··on What true thing do you believe that few people agree with you on?
It’s interesting that Sam’s answer to the question is something basically every mainstream economist agrees with[0].

(Which to be fair does fit some definitions of “few people”)

[0] https://en.wikipedia.org/wiki/Solow%E2%80%93Swan_model

mjirv··on UBI Does Not Require Tax Rates of 40 to 60 Percent
If UBI is paid for by taxes, the money supply hasn’t changed.
mjirv··on DBT Cloud increase Team plan price by 100% and limit features at the same time
It’s (mostly) for data analytics teams, not software engineers.

They use it to transform raw data in their data warehouses into views/tables that people can use for analysis.

mjirv··on Ways to get around ChatGPT's safeguards
If I were OpenAI, I’d do it so that people will have to find increasingly creative exploits, which we can then also patch (and keep patched for future models).

Long term they’re really worried about AI alignment and are probably using this to understand how AI can be “tricked” into doing things it shouldn’t.

mjirv··on Show HN: Delphi – A Natural-Language-to-SQL AI for the Modern Data Stack
Ha good to know!
mjirv··on AskEdith – Natural language interface for databases
Yes, this is a great point. To a first approximation, whether users trust the results is the only thing that matters for this kind of tech, imo.
mjirv··on AskEdith – Natural language interface for databases
Awesome! I suspect that natural language will soon be the default way we interact with data, so I’m excited to see this. There’s just such a clear need for something like this and the technology is finally ready.

(Full disclosure: I have a side project exploring something similar. Demo: https://hermes-odmf.onrender.com. See the Metrics Catalog link for available metrics; all data is from 2018)

mjirv··on The YC Summer 2022 Batch
My guess is that about 50% are repeat founders and a majority of the rest are FAANG, Ivy League, or Stanford alums.

(This is a genuine guess, not a knock on YC)

mjirv··on ISO name change for Türkiye
I was recently reading a Spanish newspaper that referred to Queen Elizabeth II and Prince Harry as Isabel and Enrique.

It was a little surprising since I’ve only ever seen the Spanish kings referred to as Juan Carlos and Felipe in English-language media, never by translations.

mjirv··on Show HN: Product Analytics in SQL with dbt
Awesome! Feel free to reach out if you have any suggestions or questions that come up as you test.

(My email is on the website in my bio, or ping me on the dbt slack if you’re there).

mjirv··on Ask HN: How to raise a seed round in a down market?
> (not nerds)

hfsp

mjirv··on Eating sea squirts may reverse the signs of ageing in mice: study
Korea and Japan, where these are eaten, are 2 of the top 3 countries for life expectancy.

https://en.wikipedia.org/wiki/List_of_countries_by_life_expe...

mjirv··on Sheryl Sandberg stepping down as Facebook COO
Thanks for sharing that video. Fascinating.

I never used Second Life, but from that video the metaverse does feel a lot like ActiveWorlds circa 2007.

mjirv··on Sheryl Sandberg stepping down as Facebook COO
> It's even more interesting that she won't be replaced.

She’s being replaced by Javier Olivan, who has been at FB forever and is the head of their Growth org.

mjirv··on ELT your data with PlanetScale Connect
Step 1: write an open-source connector for an open-source ELT tool

Step 2: paywall customers’ access to their own data so you can brand it as a premium feature/product

Step 3: ???

Step 4: profit

mjirv··on Towards Ineffective Altruism
Research around existential risk from asteroids, climate change, super volcanoes, and other natural phenomena seems extremely under-funded compared to “AI Risk.” Would “Computer Risk” researchers in the 1940s and 1950s have been able to achieve anything meaningful? Obviously not, and I think we’re in a similar position with respect to AI.

I consider myself an EA and donate to the normal GiveWell causes (mosquito nets right now, I think), as I’d suggest other small donors do. Your marginal dollar won’t make a difference to extinction risk research, and certainly not if you give it to AI research.

mjirv··on Show HN: Objectiv – Open-source product analytics infrastructure
This looks cool and I love the taxonomy and owning your own data.

But I wonder if you are trying to do too much. For example, why would I use Bach to transform my data instead of just doing it in my dbt project or wherever else I handle warehouse transforms?

mjirv··on Heresy
> Structurally there are two distinctive things about heresy: (1) that it takes priority over the question of truth or falsity, and (2) that it outweighs everything else the speaker has done.

I would amend #1 to “the adherents of the conventional view are convinced its truth is beyond question.”

Truth is actually really important, maybe the most important thing for heresy. A defining feature of heresies is that those enforcing them believe strongly that the heresy is untrue.¹

Take PG’s example of doubting the divinity of Christ. Truth isn’t secondary in that case - just the opposite. Believing it, literally, is the core feature of Christianity.

> The clearest evidence of this is that whether a statement is considered x-ist often depends on who said it. Truth doesn't work that way. The same statement can't be true when one person says it, but x-ist, and therefore false, when another person does.

This is a fallacy. Insofar as this phenomenon exists (less than people think), it’s because the belief content of the statement is different depending on who says it. There’s a common view on the identitarian left that “minorities can’t be racist because racism is about power and they don’t have any.” But a Latino professor who spends his time arguing that Black people are genetically inferior to other groups will get cancelled just as quickly as a white one.

¹Or need to be seen as believing it 100%

mjirv··on Show HN: MetricFlow – open-source metric framework
This is awesome, though I would love some more detail in the documentation.

What’s the quick pitch for why I should use this instead of Cube or dbt’s metrics layer?

mjirv··on Launch HN: Kable (YC W22) – All-in-one platform for API products
Hey, this is awesome.

I was working on a little API project this weekend[0] and struggling with how I was going to do authentication. Then I saw this post, and it took me about 10 minutes to add Kable and have it 100% working in my code.

Nice work!

[0] https://github.com/mjirv/dbt-metrics-api

mjirv··on Launch HN: Castled Data (YC W22) – Open-Source Reverse ETL
Looks great, congrats on launching!

I'm curious how you differentiate yourselves from Airbyte, which isn't really designed for reverse ETL but can be used for it. And do you ever see Castled supporting regular ETL?

Right now there is a lot of separation in the market between ETL and reverse ETL, but it seems like a pain to maintain separate tools when you could just do both in one.

mjirv··on Youth suicide attempts soared during pandemic, CDC report says
According to the CDC data, suicides were way down during the lockdown itself
mjirv··on Youth suicide attempts soared during pandemic, CDC report says
Interestingly, suicides fell sharply during the initial lockdowns in Spring 2020 but surged back in the summer and when kids went back to school.
mjirv··on Show HN: Describe SQL using natural language, and execute against real data
Very nice! I’ve been working on something similar recently: https://acolytehq.com.

Would be happy to chat and compare notes if you'd like!

mjirv··on Ask HN: Meta Question Does FAANG Become Maang or Manga?
I've always thought that comp at Microsoft is similar to Amazon (i.e. slightly lower than F/Apple/N/G). Am I wrong?
mjirv··on I am getting out of software development after 10 years of coding
I would recommend that SWEs who feel this way but still like coding try their hand at data science/data analytics/analytics engineering.

We're still early enough in the data world that it's easy to find that sense of ownership over the whole "data product." You probably won't get paid as well, although it's possible, but the pay won't be bad either.

mjirv··on Statement from Mark Zuckerberg
> If we didn't care about fighting harmful content, then why would we employ so many more people dedicated to this than any other company in our space -- even ones larger than us?

Maybe I am missing something obvious, but who is he talking about here?

mjirv··on When McDonalds Came to Denmark
Are these numbers for an average US franchise or am I misunderstanding?

If so, it would make sense that for the average franchise, doubling salary wouldn't be viable. But surely there's a distribution where some stores are much more profitable than the average, and for those stores it would. Presumably that's part of the reason why Denmark only has 80 McDonalds (about 1/3 per capita of what the US does[0]).

[0]https://en.wikipedia.org/wiki/List_of_countries_with_McDonal...

mjirv··on Show HN: Acolyte – Query your data warehouse in plain English
Interesting question. If this succeeded beyond my wildest dreams I’d expect the main impact to be on data analysts and freeing up their time to be spent on more in-depth projects rather than one-off requests.

In general I suspect AI tools like Codex will have a large impact on other technical roles like SWEs and DBAs, but I won’t try to predict exactly what that will look like.

mjirv··on Show HN: Acolyte – Query your data warehouse in plain English
Thanks, I really appreciate that feedback!
← PreviousPage 2 of 4Next →