Introduction We had developed a simple and easy to use Django app for a small mission hospital in remote town in the state of Bihar, India. Usually we host our apps on AWS ec2, but unstable internet in the hospital and total cost of ownership turned out to be a challenge. We had to deploy it locally. So we decided to do it on a Raspberry Pi 3 Model B+ we had procured for another project.

Python is the easiest language to learn and the second-best language for every thing else. It’s an interpreted, dynamically typed and almost reads like pseudocode. It’s widely used by a variety of people for lots of different purposes. I was one of those guys who learned python so that I could use it to login to cisco routers, collect and analyse logs automatically without my intervention every time. Bertrant Russel sure had an influence on me.

Aggregations in SQL are used to get useful insights from large set of data by doing some operations on it. Different scenarios of aggregations are, Aggregate the entire result set into 1 single value. eg: max value of a column Aggregate the entire result set into 1 single row. eg: max and min values of a column. Note that ALL the columns in this row have to be aggregates Aggregate the entire result set into a subset of rows, with one row for each unique value for column specified by group by clause.

This post is a collection of notes & nippets related to administering a postgres database. Securing connections via SSL This post gives detailed instructions on how to enable SSL for postgres using Letencrypt certificates for internet facing databases. The post is written for postgres 11, so if you are using a different version, make sure to update 11 in the postgres path to your version. It works like a charm and thank you Logan Marchione, 🙏

This is the new home for my blog. Welcome Hugo, the world’s fastest site for building websites. May be I could learn go also along the way. 99% of the technical knowlegde I have has been acquired from blogs, github and stackoverflow. It’s time to give back to the community. Hoping that I would be of help to someone down the road. The hugo theme used is Even. The reason to choose it is that there are no images required and ofcourse the GitHub stars.