HN user

mjirv

1,361 karma

Software and analytics engineer

https://delphihq.com

Posts137
Comments109
View on HN
www.reuters.com 9mo ago

A16Z-backed data firms Fivetran, dbt Labs to merge in all-stock deal

mjirv
117pts43
turso.tech 11mo ago

Replacing Kafka with SQLite?

mjirv
7pts2
privatebank.jpmorgan.com 1y ago

Fifty Days of Grey

mjirv
2pts1
news.ycombinator.com 1y ago

United States Digital Service Renamed to United States Doge Service

mjirv
5pts2
www.bbc.com 1y ago

Russia warns against 'hypotheses' after Azerbaijan Airlines crash

mjirv
7pts4
www.rilldata.com 1y ago

Data Talks on the Rocks 4 – Alexey Milovidov, ClickHouse

mjirv
3pts0
www.bbc.com 2y ago

Audio captures Baltimore dispatchers' response to bridge collapse [video]

mjirv
1pts0
www.delphihq.com 2y ago

Show HN: Delphi – Build customer-facing AI data apps (that work)

mjirv
3pts2
www.nbcnews.com 2y ago

A Boeing passenger jet's nose wheel fell off just before takeoff

mjirv
33pts19
venturebeat.com 2y ago

Microsoft releases Phi-2, a small model that outperforms Llama 2, Mistral 7B

mjirv
20pts1
cloud.google.com 2y ago

Google releases new Unicorn model in Vertex AI

mjirv
2pts0
twitter.com 2y ago

OpenAI employees tell board to resign

mjirv
2pts1
www.bbc.com 2y ago

Climate scientists are working with indigenous tribes

mjirv
2pts0
www.cnn.com 2y ago

United flight descends 28,000 feet in 8 minutes for ‘pressurization issue’

mjirv
21pts23
joecarlsmith.com 3y ago

Predictable updating about AI risk

mjirv
1pts0
cube.dev 3y ago

AI-powered conversational interface for the semantic layer

mjirv
11pts1
twitter.com 3y ago

Listen to live air traffic control radio mixed with lofi hip hop

mjirv
4pts1
www.bbc.com 3y ago

Officials investigate latest close call at US airport

mjirv
2pts0
www.bbc.com 3y ago

High-altitude object shot down over Alaska, US says

mjirv
8pts0
www.nytimes.com 3y ago

What Does Sustainable Living Look Like? Maybe Like Uruguay

mjirv
6pts1
astralcodexten.substack.com 3y ago

Even More Bay Area House Party

mjirv
311pts177
twitter.com 3y ago

CA high-speed rail is Exhibit A for how America can’t build big things anymore

mjirv
57pts75
delphi-30c19f.webflow.io 3y ago

Show HN: Delphi – A Natural-Language-to-SQL AI for the Modern Data Stack

mjirv
2pts2
github.com 3y ago

Show HN: Atlas – Open-source Mixpanel/Amplitude alternative

mjirv
10pts0
designer.microsoft.com 3y ago

Microsoft Designer

mjirv
46pts18
www.bbc.com 3y ago

After chess, cheating rows rock poker and fishing

mjirv
110pts226
healthapiguy.substack.com 3y ago

The previously undiscovered Bible of API companies

mjirv
1pts0
www.businessinsider.com 3y ago

Amazon is secretly testing another virtual care venture

mjirv
1pts0
github.com 4y ago

Show HN: Product Analytics in SQL with dbt

mjirv
8pts2
www.youtube.com 4y ago

BBC TV Coronation of Queen Elizabeth II (1953)

mjirv
2pts0
GPT-4.5 1 year ago

Do you have results for gpt-4? I’d be very interested in seeing the lift here from their last “big one”.

Out of curiosity, I googled several of the pubs he mentioned. All but one* was still around.

*I found a pub called the Ranelagh, but it’s not in Pimlico, so I assume it’s a different one. It was the one he described as “really terrible,” so no big loss, I suppose.

Addendum: the other interesting thing I noticed was the ones he derided as having been “modernized” in the 1960s were also newly renovated today, with airy, Scandinavian, 2020s aesthetics. Presumably because unlike the traditional pubs, the 60s style became dated pretty quickly.

Mixtral of experts 3 years ago

Current OpenAI job postings top out at $385,000 for full stack engineers which is 98th percentile in the US (and less for San Francisco).

The €80k is the start of the Mistral salary range. €100k is the top, which would put you in the top 1% of earners in France.

Three out of every four desk workers report working in the 3 to 6pm timeframe, but of those, only one in four consider these hours highly productive.

It’s nice to see some data on this. A lot of people talk about a 4-day workweek, but personally I think a 6-hour work day would be better.

At least in white-collar jobs, I think most people could fit the same amount of productivity into fewer (focused) hours.

Plus a day that’s roughly 9-3 instead of 9-5 would have the benefit of being aligned with school schedules (at least here in the US) and make things easier for working parents.

DALL·E 3 3 years ago

Interesting that they don't have the watermark on the "DALL-E 3" images.

Apache Pinot 1.0 3 years ago

Sure, I understand why you’d want real-time. I guess the OLAP part is the one I’m not sure about here.

Most of these use cases seem more “pull all data for a specific user/post/company” and less “do analytical queries on millions+ of column values.”

Apache Pinot 1.0 3 years ago

Potentially dumb question, but why does “who viewed my profile” (the feature mentioned in the post as the original use case at LinkedIn) require a realtime OLAP datastore anyway?

Cube (https://cube.dev) is a good one.

Others include AtScale[0], dbt's MetricFlow[1], Google's Looker[2] (also a BI tool but powered by a semantic layer), and Propel[3].

[0] https://atscale.com

[1] https://www.getdbt.com/product/semantic-layer

[2] https://cloud.google.com/blog/products/data-analytics/introd...

[3] https://www.propeldata.com

They're kind of an updated version of OLAP cubes if you're familiar with those.

Typically semantic layers sit on top of a data warehouse, let you define metrics using code or a UI, and provide APIs or SQL connectors so that you can query them.

Yeah, similar to what you and the other commenter from Definite said, we (Delphi)[0] find semantic layers way better for this kind of work than just going straight to a database/data warehouse.

One thing you really need with LLMs is consistency. Text-to-SQL kind of lets the LLM do whatever it wants - join tables that shouldn't be joined, define aggregates one way in one query and another way in the next.

Because semantic layers define how tables should join, measure definitions, etc., they mean people get consistent results from one query to the next, which builds trust in the LLM.

Cube (which was mentioned in another comment and has a great open-source semantic layer) has a good article about that here: https://cube.dev/blog/semantic-layer-the-backbone-of-ai-powe....

[0] https://delphihq.com

The average human cannot program, not even a little.

The average human cannot summarize (for example) Anna Karenina from memory.

OpenAI arguably already has AGI. GPT-3/ChatGPT is much better than the average human at coding, text summarization, etc. (“system 2” cognitive tasks).

Not the OP, but:

Oftentimes data teams have those data sources in the warehouse already (or a process for ETLing new ones in).

Copying data only once means lower costs (maybe) and fewer inconsistencies.

Plus if they’ve done work to join/clean/transform the data in the warehouse they can take advantage of that for product analytics without having to reinvent the wheel in ChartBrew or Mixpanel.