What you will find in this article:

• Description of IPCAD daemon that pretends as a Cisco router and provides aggregated network statistic
• Example of materialized views in ClickHouse database
• ipcad2ch utility that will help you to organize accounting of network traffic

Earlier we used image sprites to optimize network load of the sites. Now comes an era of vector graphics and particular SVG. I tried to use patterns that were familiar to me from previous lives and I could not. That’s why…

There was a task in the backlog to update the footer design of the corporate site. Recently we found time for that. It was one of the simplest things that could be done I thought. But this task took over a month for four people and that is why…

I was faced with problem to make fast search over 300k table on multiple columns for thrird party integration. This is not so big volume for modern databases, especially if you have multiple replicas, but I didn’t want even this small load on my core servers. I decided to index data for this problem in separate microservice. From previous projects I wanted to use Sphinx, but discovered that this project literally dead. Last commit was near a year ago. It is bad decision to use inactive projects in long perspective. Other option is Elasticsearch, very complex and heavy thing. Looks overkill for that small problem. Luckily Google picked up an article about Manticore search engine in Chrome app at phone. It is active clone of Sphinx with a number of functions that parent project should have but don’t.