2018 in review: 5 most viewed posts of this year on my blog
Tags: docker, git, sql, yearinreview
Published: 2018-12-25 09:24:16

I have never done this in the past 11 years of blogging, this time it is going to be different. I am listing the 5 most viewed posts from this blog in 2018. All posts are not from 2018 but they have been viewed more than the others. I am using my Google Analytics stats to compile this list. So, here I present the most popular blog posts of 2018 on [Geshan.com.np](https://geshan.com.np/):

![](https://cdn-images-1.medium.com/max/2000/0*Y6igymikxMcz71zo.jpg)

## 1. [You Can Do It in SQL, Stop Writing Extra Code for That](https://geshan.com.np/blog/2018/12/you-can-do-it-in-sql/)

This post was published just 10 days back but I garnered a lot of views. The post highlights:
> *Use SQL to do math like sum, average etc. Utilize it for grouping one to many relational values like getting categories of product. Leverage SQL for string manipulation like using CONCAT_WS for concating first name and last name. Exploit SQL to sort by a custom priority formula.*

![](https://cdn-images-1.medium.com/max/2000/0*IfDUlk_CmA9BYoL9.jpg)

## 2. [4 Ways Docker Changed the Way Software Engineers Work in Past Half Decade](https://geshan.com.np/blog/2018/12/4-ways-docker-changed-the-way-software-engineers-work-in-past-half-decade/)

Another post from this December that got pretty popular in past weeks. This post is about how docker has changed software engineering in the past 5 years. The post can be summarized as:
> *With Docker, you ship the whole stack not only your code. Allocate minimum required resources to containers then scale them horizontally. With containers security generally already comes baked In. With Docker and Kubernetes you can get zero downtime and faster deployments leading to business profit.*

![](https://cdn-images-1.medium.com/max/2000/0*PuGJgA9uDY2vG2sC.jpg)

## 3. [How to Use Docker Compose With Virtual Hosts and Shared Services (Like Db) for Dev Environment](https://geshan.com.np/blog/2017/05/how-to-use-docker-compose-with-virtual-hosts-and-services-like-db-for-dev-environment/)

This is another post about Docker, it is from May 2017. This piece was also able to gather a good amount of views. The post advocates:
> *Use docker and docker-compose with external_links to reuse services like a database across multiple projects. Using Ngnix proxy with virtual hosts can simplify multi-project setup and operation.*

![](https://cdn-images-1.medium.com/max/2000/0*wgmDukslQi2Mro76.jpg)

## 4. [3 Simple Rules for Less or No Git Conflicts](https://geshan.com.np/blog/2016/04/3-simple-rules-for-less-or-no-git-conflicts/)

This is a post about git from 2016. It also got many hits this year probably due to some search engine traffic. Mainly the post can be summarized at
> *Keep your changes small. Rebase your working branch with main branch often. And, review pull requests faster and merge them to main branch.*

![](https://cdn-images-1.medium.com/max/2000/0*XZPyL7VaERZD_yzR.png)

## 5. [Don’t Code Your Microservice Like a Monolith, Keep It Maintainable Not Over-engineered](https://geshan.com.np/blog/2018/10/dont-code-your-microservice-like-a-monolith/)

This is a post from Oct this year about Microservice and how to not code it like a Monolith. This post was also able to get some views from different sources. The post mainly advocates:
> *Microservices are small software systems. You can safely ditch MVC. Say no to ORM and also not take the design pattern baggage for microservices. Focus on code performance, readability, and maintainability not some old rules and patterns. Those patterns were made when people were not doing microservices.*

![](https://cdn-images-1.medium.com/max/2000/0*NaD_qVniicrk67JZ.jpg)

## Conclusion
> *Looks like docker has been a popular topic for this year. Probably I would blog more about it next year too. I have started cross-posting my posts to [Dev.to](https://dev.to/geshan) and medium publications like [FreeCodeCamp](https://medium.freecodecamp.org/@geshan) and [HackerNoon](https://hackernoon.com/@geshan). I hope these posts help more and more people.*

---

*Originally published at [geshan.com.np](https://geshan.com.np/blog/2018/12/2018-in-review-5-most-viewed-posts-of-this-year/).*