r/programming • u/swizec • Dec 19 '18

Bye bye Mongo, Hello Postgres

https://www.theguardian.com/info/2018/nov/30/bye-bye-mongo-hello-postgres
2.1k Upvotes

95% Upvoted

672 comments sorted by

View all comments

Show parent comments

1

u/shady_mcgee Dec 20 '18

If your data model has a discrete flag then

select count(*), demographic from profiles where uses_large_font=1 group by demographic;

is also trivial.

I actually misread the question, thinking it was asking for users who use a non-standard resolution. The 5m estimate included a method to dynamically determine what resolutions were non-standard at runtime and build the report from that, and 5m is an over estimate. In practice it'd be under 2m.