This guide details a production-grade, Infrastructure as Code (IaC) pattern for deploying the Crunchy Data Postgres Operator (PGO) on Kubernetes with Ansible. It's designed for experienced engineers managing their own infrastructure on platforms like K3s, not for those using managed cloud database services like RDS or Cloud SQL.

By wrapping PGO's Helm chart and cluster definitions in Ansible, you create a version-controlled, repeatable, and automated system. By the end, you will have a complete playbook that deploys PGO and provisions a Postgres cluster with production-ready, S3-backed backups.

Directly accessing Kubernetes services from outside the cluster can be a security and convenience nightmare. Tedious port-forward commands and exposed proxies are risky. This post details how I built a better solution: a secure, automated VPN tunnel into my cluster using WireGuard and Ansible, giving me direct, private network access to my K3s cluster.

For all of you who already signed up for Sheetty, you may have spotted a new menu item:

What’s this little thing, you may be wondering? This is your entrance to a magic world of Teams.

Our server has root access with a password.

ssh root@x.x.x.x

It’s default, it’s how it’s been provisioned.

It’s not good.

This week is a bit less technical. Building a product does not mean programming 20h a day. There are a lot of activities not related to tech. One of those is giving people a chance to get to know you better.

That’s a difficult topic to talk about, so I’m glad you’re here 🙏

Bon dia! Com estàs? It’s been long two weeks. There was no post last Friday, because I was in Mallorca and I saw chickens.

But this week, we are back with another issue número tres. A lot was done, but even more still lies ahead. As usual, we added some QoL and pushed Teams closer towards completion.

Let’s roll 🎲👉!

This week started off with permission management. Many tricky questions arose during the implementation and we tried to answer them as simply as possible. Besides this, a row of QoL improvements, like fuzzy search or smoother quick actions navigation, were implemented. All right, let’s crack this ice cream box open.

Just build it and they will come. Except they won’t. And if you, like every other person on the planet, missed the evolution of the time tracking industry, brought about by consultingcockpit.com, the Weekly Sheetty Scoop is a record of that journey filled with challenges and achievements, problems and solutions, questions and decisions that took place along the way. Week by week.

GRAN Software Solutions is a German company that designs and builds modern back-end solutions. We work with large automotive clients and others to restructure and create new solutions. We also develop and offer SaaS tools to help us and others in our daily work.

One such tool we built for ourselves and others is a time-tracking application called Sheetty.

I’m a software developer and a freelancer. Tracking time is something I’m doing every day.