Cool idea although idk about the risk factors one — this seems like its cherry picked a few projects with contributor agreements and decided theyre high risk when there are so many more projects with the same structure.

I’m always confused by this — if it’s against the law and the companies are still doing it why not try an enforcement mechanism instead of publishing a report every year? 100% of the long distance routes “failed” Amtrak’s own metrics.

I mean I guess, but why not just use a lucene based system?

Keeping it in Postgres avoids needing to denormalize the data, which is a big pain point. ParadeDB pg_search is based on Tantivy, a Lucene-inspired library, so in some ways it allows you to both benefit from a Lucene-based system and also keep it in Postgres

Because that's another thing to set up, operate and pay for.