before the moss covers the thoughts...

Gmail : GUI for your backend!

Why build an app if you can use GMAIL to get data?

Often, we have a need to collect data from customers. Immediate thinking is to make an app change, push it up to store, get people to upgrade (doesn't happen!) and then pray. A little more savvy version of this is making a web app and then send the links with a uuid based customer identification.

Why not just ask users to email you the data? People know how to use email! Following snippet shows how easy it is to automate fetching the data and then sending to a script to process.

Calendar Heatmaps from Dataframes

GitHub popularized this form contrib heatmaps. Calmap makes it easy to make!

sample

Github contrib map is such a great visualization to see the activity over a year. There are several javascript versions of this that provide interactive visualizations on the data; but when you don't need interactivity and want to just visualize multiple data points over same time axis to see any trends, Calmap is a super simple library that can generate those.

Continue to see what we can make with our own data!

Remind - it does what it's name says!

Just don't forget anything - use this wonderful little Unix tool that runs on plain text.

remind is a classic command line unix utility. A very simple collection of text files hold all your reminders in a readable format. Let us make a quick cron job using this to send daily notification emails.

Are we there yet?

Scaling time triggered checks without crons crawling all over!

What often starts as simple databases for simple solutions grow when business is growing. Business requirements also grow over time — after all, there is only so much that can be supported by frequent reports being monitored by people at regular intervals to alert others about possible situations.

SQLite3 CTE tricks for time series analysis

Hands on analyze git log data with SQLite3 CTEs!

SQL has been there for ages. sqlite3 gives you a phenomenal tool to quickly load and analyse data in a language meant for that. While I’ve used it for a long time, only recently did I know about support for CTE aka Common Table Expressions.