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.
“Do this, when that” is a very easy problem to solve. For example, sending an email when the order has been placed is perhaps few lines of code. Of course, that too gets into issues when you’ve large number of concurrent orders that choke the processing due to email being sent. …
We all have those scripts that grow over time and does incredibly useful things for internal use. Often, more than the core logic of those, we end up spending time to make emails, batch processing etc.
Useful things usually get to a point where people want to build additional systems on top of these.
APIs that generate JSON are pretty much the default standard for consuming reusable microservices. When concurrent load is controllable like in an intranet, node-red makes it very easy to build APIs. …
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.
Quick (and overly simplified) definition of CTE? This is where you can park sub-queries into expressions and use those expressions in your query. Kind of like defining views on the fly.
Let us create a new database and add a table that has just two columns, one for date and one for some entry. …
WhatsApp is perhaps the most used app on our phones. It has become as ubiquitous as a tool can get. You get added to groups, you have quite a bit of chats lying around and you also may be using video or audio calls a lot. One thing I do love about WhatsApp’s UX is that nothing gets in the way of getting core things done.
This is a short note with mockups on two things that I find missing in WhatsApp.
Forwards. Too many to require some control.
Most of us are part of many groups. Some useful, some mundane, some necessary. I am not quite sure if it is just in India, but quite a large number of people have the urge to forward whatever they get to the groups they are part of. …
Very often, we end up setting up an entirely different machine for testing our stuff. Of late, I’ve been using docker on Ubuntu 18.04 for testing individual environments for various projects I work on.
That way, when things finally make into production, I am sure that I’ve not forgotten to handle dependencies, configuration parameters required etc.
An added advantage is when you decide upon release version names. For each release, you’ve an environment with version name as environment name. …