3 ms·
Certainly you can implement this same pattern without Redis. Triggers in Postgres would be a reasonable way to do it. I didn't say you can't do this in Postgr
by samstokes 14y ago
Certainly you can implement this same pattern without Redis. Triggers in Postgres would be a reasonable way to do it. I didn't say you can't do this in Postgres, I said you can't do it with COUNT().
It does indeed sound like they're storing every click: that's precisely why using aggregate functions would be expensive.
- guywithabike 14y agoYou absolutely can do it without COUNT. Just increment a counter value, the same way they're doing it in Redis.
- pestaa 14y agoWhy was this downvoted? Adding 1 to any number field is just as an atomic operation as incrementation is in Redis.
- samstokes 14y agoPresumably it was downvoted (not by me) because it's refuting a claim I didn't make: samstokes: I said you can't do it with COUNT() guywithabike: You absolutely can do it without COUNT Then we agree.