3,016 karma · joined March 16, 2015
Definite is ETL, a data warehouse and BI in one app.
Previously founded SeekWell (https://seekwell.io/), acquired in 2021.
twitter: https://twitter.com/thisritchie
email: mike@definite.app
meet.hn/city/us-Philadelphia
I personally don't think there's anything wrong with doing it (i.e. shipping a feature quickly that a customer needs), but writing a blog post about it is questionable.
0 - https://github.com/deepseek-ai/smallpond
1 - https://www.definite.app/blog/smallpond (overview for data engineers, practical application)
Something like "where do we store temporary files the agent creates?" becomes obvious if you have a sandbox you can spin up and down in a couple seconds.
1. DuckLake is the best datalake spec and their team is improving on the extension rapidly.
2. With DuckDB WASM, you can make apps that would normally have 2 to 3 second latency for network calls work in < 200ms.
We use it as our built-in datalake at Definite and couldn't be happier with it.
https://github.com/anthropics/skills/blob/main/document-skil...
There are many edge cases when writing / reading Excel files with Python and this nails many of them.
https://github.com/anthropics/skills/blob/main/document-skil...
I was dealing with 2 issues this morning getting Claude to produce a .xlsx that are covered in the doc above
The "modern data stack" market excluding of data warehouse / data lake is pretty small. Fivetran is biggest one and still under $500M in revenue, so they're acquiring other parts and starting to offer their own datalake (managed Iceberg).
Snowflake started offering fivetran-like connectors a couple years ago and I expect they'll double down there. Same with Databricks. Microsoft has Fabric now, but the reviews have been terrible (my experience included).
I think they'll each ultimately have a full data stack.
If you don't want to wait, we built a modern-data-stack-in-a-box at Definite (https://www.definite.app/).
On one hand, a ton of people are using it to build AI workflows.
On the other, it's never been easier to build a similar workflow in Python with Claude Code or other tools where you get infinite flexibility, version control, and more flexibility on hosting.
We're betting on the later at https://www.definite.app/. Our agent writes pure Python with pre-built integrations into stuff like Hubspot, Salesforce, Attio, Stripe, Postgres, etc.
e.g. if I built a basic LLM chat app with Qwen3 600m + Cactus, whats the total app size?
Putting it together (podcast‑only)
Ads (STM only): 0.85 – $0.95M
Memberships: $1.5–$2.6M/yr
Working estimate (gross, podcast‑only): $2.3M – $3.7M per year for ads + its share of memberships. Mid‑case lands near $2.9M/yr gross; after typical platform/processing fees and less‑than‑perfect ad sell‑through, a net in the low‑to‑mid $2Ms seems plausible.
---
Quick answers
How many listeners: 175K downloads per episode, ~1.4–2.1M monthly downloads, demographics skew U.S., median age ~36.
How much revenue? $2.3M– $3.7M/yr gross from ads + memberships attributable to the STM show
I looked into years ago and couldn't find a satisfying answer, but GPT-5 went off, did an "unreasonable" amount of research, cross referenced sources and provided an incredibly detailed answer and a believable range.
0 - https://x.com/thisritchie/status/1944038132665454841
1- https://docs.anthropic.com/en/docs/agents-and-tools/tool-use...
SELECT id, body
FROM docs
WHERE body ~* E'(?x) -- x = allow whitespace/comments
(?:\\m(?:dr|rev(?:erend)?)\\.?\\M[\\s.]+)? -- optional title: Dr., Rev., Reverend
( -- name forms
(?:\\mmartin\\M[\\s.]+(?:\\mluther\\M[\\s.]+)?\\mking\\M) -- "Martin (Luther)? King"
| (?:\\mm\\.?\\M[\\s.]+(?:\\ml\\.?\\M[\\s.]+)?\\mking\\M) -- "M. (L.)? King" / "M L King"
| (?:\\mmlk\\M) -- "MLK"
)
(?:[\\s.,-]*\\m(?:jr|junior)\\M\\.?)* -- optional suffix(es): Jr, Jr., Junior
';1 - https://pydantic.dev/articles/building-data-team-with-pydant...