Systems Engineer currently living in Spain
Lived in 🇦🇷 🇷🇺 🇪🇦 ∙ generalist ∙ I like to learn and challenge myself
Managed vs self-managed PostgreSQL on Digital Ocean
TL;DR Managed PostgreSQL is more expensive if we consider resources being assigned (CPU+RAM+DISK), but Digital Ocean provides features that makes availability and maintainability much easier compared to self-managed. For testing and development environment, and proof of concepts, and if costs is very important, it can makes sense to choose the self-managed approach. Overall comparison Managed PostgreSQL General 1 GB RAM 1vCPU 10 GB Disk PostgreSQL 15 15€/mo PROS: Automatic updates Daily point-in-time backups High availability with automated failover (extra cost) Read-only nodes (extra cost) End-to-end security Cluster metrics and alerting CONS: Impossible to SSH into instance Some restrictions (available extensions, PostgreSQL versions, etc) Self-managed PostgreSQL General 1 GB RAM 1 vCPU 25GB Disk PostgreSQL 16 (or any version, it’s up to you) $7/mo PROS: Full control CONS: Managing a database instances requires knowledge, experience and time....
Install PostgreSQL 16 on Digital Ocean droplet
Create the droplet for the DB I haven’t used Terraform with DigitalOcean yet. To iterate more quickly I just created the droplet using the web UI. Since it’s my first time with Digital Ocean, I considered that better make some quick progress to be able to evaluate the platform, and leave automation for a second iteration. I already have my ssh public key in Digital Ocean, so bringing the droplet up was quick and easy....
Weed unnecessary Debian packages with debfoster
debfoster From the man page: debfoster maintains a list of installed packages that were explicitly requested rather than installed as a dependency. After months of use, I end up with a lot of packages that I don’t need, that I installed to build something, or just to try to solve a specific problem (that I no longer have). But it’s very difficult to keep track of those packages. Of course, we have apt-get autoremove and deborphan, but it’s difficult to whitelist packages in those tools....
Sending data from Arduino - part 3
Goal: learn about the effects on performance when packing more than a single data point per UDP packet. ...
Sending data from Arduino - part 2
Part 2: let’s learn about the performance of sending single data point per UDP packet. ...