90 karma · joined June 30, 2017
> PostgreSQL has a single master and multiple read replicas, Elasticsearch has horizontal scalability via sharding.
> if you have a large data set search and search relevancy is critical to your application (for example, in e-commerce), using a dedicated search engine like Elasticsearch is going to perform better
I love the mentality of "default to using Postgres for everything, and specialize when you need to." In this case, it looks like you'll need to evolve text search out of Postgres the moment your dataset gets into the millions, which roughly matches my experience.
Question - what is your root goal? Are you convinced video processing is the best way to achieve this?
> "Being able to comment on character-level granularity is cool!" This is something that I really like too - I'd go so far as to say PR titles, file names, etc, nearly everything should be commentable.
Have you checked out graphite.dev? Its iterating rapidly and incorporating a lot of what Phabricator and Gerrit did well.
I've been working with some peers on a better code review tool since hearing about Phabricator shutting down: https://graphite.dev/
It syncs all data to GitHub while offering things like a review queue, gif reactions, stacked diffs, etc - all inspired from Phabricator.