I’ve been a software developer, doing coding for about 9 years now, a few years ago I’ve always dream about having excellent, perfect the code quality that readable, maintainable, no stupid bugs, etc… yet here I am, at this point, experiencing the same thing over years, over time, then I think I get to the conclusion I want to share with you.

This is about my personal experience in google cloud cost, I make the title simple, but it’s not about overall “Google Cloud Cost” whatsoever. So people make mistakes. Including me, yeah. But I am grateful I learned a lot. I involved in a project that uses google cloud. The compute engine, the load balancer, the storage, and CDN, etc. I was the one who manages the budget, then I made a mistake, I didn’t know what I was doing. We should count the most basic yet pricey thing on the web development: Bandwidth.

I was learning google cloud lately. I learn to setup compute instance with custom disk size, setup instance group, ssl certificate and successfully, i guess, running the load balancer.

Sure we need the versioning for our microservices, its also apply for grpc services. I current working on service that used by another several service. My service periodically evolved and updated so I think its good practice to give it version, keep the code base tracked for update and deprecation.

My first post this 2020. One of those things I want to write is that what I learn from sharing session from work combined with a few experiences about database MySQL.

I just learn about microservices. Then I got this kind of problem. Distributed data management problem. Its actually simple, I think, but this is kind of new problem I faced because I never focus on backend before. Then here it is I will just write it down.

This is part of my pet projects. I need to create web app which the state is depends on the subdomain. Similar with wordpress or blogspot blog. e.g mysite.wordpress.com or mysite.blogspot.com. This is how I do it.

A lot of drama at work, this time I need to backup the Amplitude logs events to S3. The dumb idea, I think I can just export the all amplitude events to my local machine, and upload it to S3. And not, so dumb idea, I think, we can do it all at once: Streaming.

I was need to move solr installation from one server to another. I can not do any reindexing from the beginning because its fairly large collection, about 15 million and I don’t know how much time will it takes to do it from beginning. So I need to move the index data as well.

How do you do Group By in SQL ? (or MySql) ? This post is note about my experience writing query in sql, There is worth-to-note something about ‘Group By’, there is may be better way to do it.