News for hackers. Stuff that matters.

A comment on Ask HN: Free tool to schedule and receive SQL emails?.

Re:Ask HN: Free tool to schedule and receive SQL emails? by viraptor on Wednesday October 12, 2016 @11:17PM (#12698195)
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...)
[ Parent | on HN ]
Re:Ask HN: Free tool to schedule and receive SQL emails? by bruno2223 on Wednesday October 12, 2016 @11:26PM (#12698227)
But how to send the result of this SQL query in a beautiful table format in email's body?

It would be nice to have HTML tags with CSS style.

I am thinking in build an easy tool to do that, really similar to your solution using cronjob, but more fancy and easy to ready on email (also with an .csv attached with all data)

What do u think?

[ Parent | on HN ]
Re:Ask HN: Free tool to schedule and receive SQL emails? by flukus on Wednesday October 12, 2016 @11:28PM (#12698234)
> But how to send the result of this SQL query in a beautiful table format in email's body?

The same way. But get cron to invoke a ruby/python/bash script or program to get the output you want.

[ Parent | on HN ]
Re:Ask HN: Free tool to schedule and receive SQL emails? by flukus on Wednesday October 12, 2016 @11:25PM (#12698225)
Or if you're stuck on windows, the task scheduler:

https://technet.microsoft.com/en-us/library/cc721931(v=ws.11...

[ Parent | on HN ]