Ureka.Social: Improved Search Filtering & Bug Fixes

Hive SQL can be used to collect most data from hive, yes. There is also Hivemind and other systems that act as middlewear for indexing. I haven't used them for this kind of indexing myself yet though. I will probably get to it in time. Proper notifications are a higher priority at the moment.

Advertising clearly works for web 2 social networks, but it has to be done carefully.. and there is a chicken/ egg situation in the sense that you need a big audience to generate a big income.
Smart contracts offer something new here, so I am contemplating, what may work there.