For my day
The prior dev crew there built everything on Mongo, which makes reporting . . . less than fun. Seriously, punch me in the face. Quick aside: if you really want to get MongoDB data into a SQL
I am
We use Slack at Scripted for team communication, so I wanted a crazy easy way to get good reporting into Slack WITHOUT HAVING TO SPEND A BUNCH OF DEVELOPER DOLLARS.
A few caveats:
- I love
rails, and can crank out scaffolding apps quickly - I love
SQL, and even created SQLBot.co as a testament to that love - We built our own Zapier app at Scripted to fire off important business events that we do VERY important stuff with - email, CRM, support, etc.
With all that said, here's what we did:
- Created a Zapier event to let us know when a
customer rated a piece of writing. Using Zapier, thislet's us see it immediately in Slack & create a task in our CRM to reach out (we use Pipedrive) - I created an ultra simple rails scaffolding app & deployed to Heroku to store the data so we can report on trends, etc. with the awesomeness that is SQL
- I fired up SQLbot.co to pump in reporting