Best way to store Badge criteria?

Rules.

You create events in the system, and use rules within an event stream processor.

Specifically, say you have a badge “made 10 posts”. You don’t run “select count(*) from posts where user = :user” for every post. Rather, you have a simple rule that watches each post come by, and “count them”, storing the rules state in the user profile.

That way “made 10 posts” is as cheap as “made 1,000,000” posts.

This also makes the system much more extensible.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)