from Hacker News

Ask HN: Free tool to schedule and receive SQL emails?

by bruno2223 on 10/13/16, 3:00 AM with 4 comments

There is any tool to schedule a SQL query and then receive the results every day?

I need to receive an email every morning telling me if my crawlers did run fine last night. I can do this with a simple SQL query.

I am willing to build this tool (in Node.js) if this tool does not exists just yet.

* No SaaS, please. I'm looking for a self-hosted option. I do not want to give a read-only password of my database for anybody.

  • by viraptor on 10/13/16, 3:17 AM

    Why not use cron?

        mysql the_database << "SELECT ...." | mail -s "Daily report" your@email
    You can insert some formatter in between if you want. If you'd rather send emails from a proper account and not local mailer, you can use ssmtp and configure a smarthost. (http://www.cyberciti.biz/tips/linux-use-gmail-as-a-smarthost...)