I agree. Let's grant that SBB is more organized than DB. But given that Germany is 8 times as big as Switzerland and with 33,000 km has a significantly larger train network than Switzerland's 5,300 km, it's no surprise that trains accumulate more delays in Germany.
The only problem is that you get a non-optimal experience because Daniel Ek has decided "fairness for me, not for thee" and refuses to implement AirPlay 2 support for years now while crying that Apple is so unfair to them.
They have the highest number of registered and concurrent users of all LLM providers, the best apps and they have deals with Microsoft AND Apple.
So I would say they have a solid grip on the market, and a good position to keep it with minimal improvements.
Most users don’t care about the best LLM, they will not switch. I mean they probably are not even aware they are using OpenAI because it is just integrated into Office or Siri…
The hundreds of features things like Solr and Elasticsearch/Opensearch have. These are complex products but mostly this is a form of necessary complexity.
To be blunt, the intersection of people that know what they are doing on this front and people that choose to use Postgres for this is pretty narrow. It does happen and I've seen a few nice things built with Postgres. But mostly it's just people using the wrong tool for the job.
This is partially true. You're right that the feature set is necessary, but it's now possible to do this in Postgres.
ParadeDB pg_search bundles Tantivy, a Lucene-inspired library inside Postgres, to give users the feature set (BM25 ranking, tokenizers, faceted search, etc.) while keeping the benefits of Postgres (keep your data normalized, avoid ETL, etc.)
I’ve been using pg_search for a tranche of emails in 2+ GB PDFs converted to PDF-page-per-row. Along with some materialized views for regex extracted timestamps it has given us a means for data forensics that has been very fruitful.
Orchestrating this outside of a few Python scripts and a single instance of postgres would have taken much more work!
I used to have this same argument but apart from the few that I've used on solr, it is not trivial to have general search using it. Won't even comment on ES b/c they already target analytics better than search. I think it is worth exploring pg and other tools as all search cases are narrow/specific (ecomm, graphs, domain-specific documents etc), specially if you need facets and filtering. Also multilanguage ok to consider for a tool but products usually look for better recall at their original lang then to have same results in other languages.
For me this sounds a lot like a distinction between being intrinsically motivated (“because it is fun for me”) and extrinsic motivation (“I want to achieve something in the outside world”)
