mfrye0

2 miesiące temudiscuss

Another point not really mentioned in here is the type of home. Buying a condo has absolutely been the worst decision of my life.

It was our first home after getting married. The condo HOA will probably go down as the most disfunctional HOA in California history - not exaggerating. It has/will cost an obscene amount of time/money that I will never get back.

mfrye0

3 miesiące temudiscuss

Interesting idea, but just about everything is failing for me. Probably the HN hug of death happening.

  Gemini generateContent request failed: { "error": { "code": 429, "message": "You exceeded your current quota, please check your plan and billing details. For more information on this error, head to: https://ai.google.dev/gemini-api/docs/rate-limits. To monitor your current usage, head to: https://ai.dev/rate-limit. ", "status": "RESOURCE_EXHAUSTED", "details": [ { "@type": "type.googleapis.com/google.rpc.Help", "links": [ { "description": "Learn more about Gemini API quotas", "url": "https://ai.google.dev/gemini-api/docs/rate-limits" } ] } ] } }

mfrye0

3 miesiące temudiscuss

Yes. Have a lawyer and there is indeed meaningful money at stake. I'm more wishing there was a simpler way to go about it though, as it's likely going to cost 6 figures when it's all said and done.

mfrye0

3 miesiące temudiscuss

I would love something like this to use with my HOA. About to start mediation and the estimate for the mediator alone is ~$20k.

mfrye0

5 miesięcy temudiscuss

Relevant data point on AWS - GCP is giving out a ton of cloud credits to startups. On average $100k in comparison to $10k-20k from AWS.

Before Claude Code, a full cloud migration could easily be a couple months. We migrated our whole stack to GCP in about a week. It's trivial to switch clouds now with K8 stack and Claude Code.

mfrye0

8 miesięcy temudiscuss

I was looking for a version of a proxy that could maximize throughput to each LLM based on its limits. Basically max requests and input/output tokens per second.

I couldn't find something, so I rolled a version together based on redis and job queues. It works decently well, but I'd prefer to use something better if it exists.

Does anyone know of something like this that isn't completely over engineered / abstracted?

mfrye0

8 miesięcy temudiscuss

Thanks for this. That makes sense.

mfrye0

8 miesięcy temudiscuss

I've been keeping an eye on this space for awhile as it matures a bit further. There's been a number of startups that have popped up around this - apart from Temporal and DBOS, Hatchet.run looked interesting.

I've been using BullMQ for awhile with distributed workers across K8 and have hacked together what I need, but a lightweight DAG of some sort on Postgres would be great.

I took a brief look at your docs. What would you say is the main difference of yours vs some of the other options? Just the simplicity of it being a single sql file and a sdk wrapper? Sorry if the docs answer this already - trying to take a quick look between work.

mfrye0

8 miesięcy temudiscuss

I was going to say the same. We're using binary vectors in prod as well. Makes a huge difference in the indexes. This wasn't mentioned once in the article.

mfrye0

9 miesięcy temudiscuss

Sorry, habit. I've been debating on exposing these publicly, but they're expensive to create. We have a public interactive demo here for now: https://savvyiq.ai/products/entity-hierarchy

Here's the live mermaid editor version for the Ikea example: https://mermaid.live/edit#pako:eNqNkV9PwjAUxb9KcxPfRrO17E_3Y...

mfrye0

9 miesięcy temudiscuss

I noticed the template too. Someone mentioned recently that's actually a good risk signal - scammers often use the same site structure across domains.

On the research, you're absolutely right. It fits that sweet spot where it's just easy / boring / tedious enough to automate with the current generation of LLMs.

mfrye0

9 miesięcy temudiscuss

Hey, good question. Yeah, we're aware of many companies that can have thousands of subsidiaries.

We found that going both up the chain and down / sideways in the chain was too much for the agent to handle - they are two distinct operations. The #1 use case was customers trying to understand the ultimate parent, so we decided to focus on that first.

We have something roughly working on subsidiaries, but it's not ready for prime time yet. It would likely be a separate API.

mfrye0

9 miesięcy temudiscuss

Thank you! Yeah, I know it's a fine balance between shipping too early and having a buggy product vs too late. I'm shipping as fast as I can now to keep that tight feedback loop going.

mfrye0

9 miesięcy temudiscuss

Interesting. So in that case, who had the biggest pain point? The sales team from being held up, or the research time under pressure to deliver?

We actually haven't explored the big consulting firms yet. I know they are often contracted to do this sort of research for companies.

mfrye0

9 miesięcy temudiscuss

Thanks. I've been heads down on this for some time and don't have the huge network to share this with.

Regarding the product, I'm open to any and all feedback for your use case. Trying to follow the adage of "if you are not embarrassed by the first version of your product, you’ve launched too late".

And wow - just read your reddit post. I'm going to look into that for us too.

mfrye0

9 miesięcy temudiscuss

Interesting. That's actually where we started. We were doing automated research on vendors from a TPRM perspective and looking for data points around organizational security / reputation. Examples - if the company had been hacked before / how they responded, do they have a CISO, nth party vendors, are they SOC2 / FedRAMP certified, etc. Basically, predictors of risk / stability.

We realized the underlying business graph was the bottleneck though, so that's been our focus for some time. With that in place, we're now coming full circle on the risk research standpoint.

On your comment about confidence / liability, we're actually having conversations around that now and getting feedback. First step is exposing all the research and evidence directly to build trust, which is what we're doing now for the new corporate hierarchy system.

mfrye0

9 miesięcy temudiscuss

Good idea! I picked a random California Ikea entity (IKEA US RETAIL LLC) and ran it through the system. Here's the output - current goal is to get to ultimate parent.

## Summary IKEA US RETAIL LLC is a limited liability company. It is wholly owned by IKEA Holding U.S., Inc., and ultimately controlled by Stichting INGKA Foundation, a Dutch foundation that owns Ingka Group.

## Graph

  graph TD
    e2[IKEA Property, Inc.]-->e1[IKEA US RETAIL LLC]
    e3[IKEA Holding U.S., Inc.]-->e1[IKEA US RETAIL LLC]
    e4[Ingka Holding B.V.]-->e3[IKEA Holding U.S., Inc.]
    e4[Ingka Holding B.V.]-->e4[Ingka Holding B.V.]
    e5[Stichting INGKA Foundation]-->|100%, 1982|e4[Ingka Holding B.V.]

This is the permalink to the deep research result: https://savvyiq.ai/playground/entity-hierarchy/siq_31ro4EDce...

mfrye0

9 miesięcy temudiscuss

If you do this sort of thing often, I'd love to chat further. I'm basically trying to automate this sort of manual research around companies with a library of deep research APIs.

Had a show HN last week that seemed to go under the radar: https://news.ycombinator.com/item?id=45671087

We launched corporate hierarchy research and working on UBO now. From the corporate hierarchy standpoint, it looks like the Delaware entity fully owns the Estonian entity. Auto generated mermaid diagram from the deep research:

  graph TD
    e1[BuildJet, Inc.]-->|100%, 2022-12-16|e2[Buildjet OÜ]

mfrye0

9 miesięcy temudiscuss

Since it's quiet here, figured I'd share what the API actually spits out. Here's MG Motor's ownership chain (this is just the Mermaid diagram field - we return a bunch of other stuff too):

  graph TD
    e2[SAIC MOTOR UK HOLDING CO., LTD.]-->|2005-02-15|e1[MG MOTOR UK LTD]
    e1[MG MOTOR UK LTD]-->|2018|e7[MG Sales Centre Limited]
    e4[SAIC Motor Corporation Limited]-->e2[SAIC MOTOR UK HOLDING CO., LTD.]
    e4[SAIC Motor Corporation Limited]-->e3[SAIC MOTOR INTERNATIONAL UK LTD]
    e5[Shanghai Automotive Industry Corporation Group]-->|62.69%|e4[SAIC Motor Corporation Limited]
    e6[Shanghai State-owned Assets Supervision and Administration Commission Shanghai SASAC]-->e5[Shanghai Automotive Industry Corporation Group]

You can copy/paste that into any Mermaid renderer to see it visually. Pretty wild how a British car brand ends up tracing back to Shanghai's government.

Happy to run lookups for other companies if anyone's curious what their ownership looks like!

mfrye0

9 miesięcy temudiscuss

I can confirm on the performance benefits. I wanted to start with uuidv7 for a new DB earlier this year, so I put together a function to use in the meantime. Once the function is available natively, we'll just migrate to use it instead.

For anyone interested:

CREATE FUNCTION uuidv7() RETURNS uuid AS $$ -- Get base random UUID and overlay timestamp select encode( set_bit( set_bit( overlay(uuid_send(gen_random_uuid()) placing substring(int8send((extract(epoch from clock_timestamp())*1000)::bigint) from 3) from 1 for 6), 52, 1), -- Set version bits to 0111 53, 1), 'hex')::uuid; $$ LANGUAGE sql volatile;

Submissions

Show HN: Corporate Hierarchy API – Map the corporate family tree

comments