search

kjk / dbworkbench

Database workbench for Mac and Windows
MIT License
5 stars 1 forks source link

Getting targeted users emails #100

Open thellimist opened 8 years ago

thellimist commented 8 years ago

We can get emails by commit meta github API provides. We can query for postgresql/mysql related repos get their /user/repo link and use curl -i "https://api.github.com/repos/thellimist/EZPods/commits" to get the user who did the commit. We can have a mail list of targeted users which can be useful in the feature.

https://api.github.com/search/repositories?q=language:plpgsql&sort=stars&order=desc https://api.github.com/search/repositories?q=mysql+language:javascript&sort=stars&order=desc

thellimist commented 8 years ago

Github auth user: 30req per min. Without auth: 10req per min. I not positive but sending request over tor could make the rate limiting infinity.

Optimisticly we can get 1.8k mails in one hour with authed requests

kjk commented 8 years ago

I'm not sure if spamming people is the best way to advertise a product.

thellimist commented 8 years ago

The usage shouldn't be spamming. In appropaite times sending 1 email per user would generate a good amount of money in the future.

On Mon, Dec 28, 2015, 10:00 Krzysztof Kowalczyk notifications@github.com wrote:

I'm not sure if spamming people is the best way to advertise a product.

— Reply to this email directly or view it on GitHub https://github.com/kjk/dbworkbench/issues/100#issuecomment-167615052.