Issue #64
Nexteam is sponsoring this newsletter. Sorry due to family issues this week I am late. Please tell your friends and colleagues about this publication. Thank you.
Courtesy of Unsplash
Odin
Odin Programming Language. The Data-Oriented Language for Sane Software Development.
PostgreSQL 16 Released
The latest major release of Postgres arrived a day after our previous Postgres Weekly update. However, this gives us the chance to highlight several extensions that have been updated for PG16 in the Code & Tools section below. Here are some of the standout features:
Enhanced CPU acceleration with support for SIMD on x86 & ARM architectures.
Enhanced query planner that supports parallelizing FULL and RIGHT joins.
Upgrades in aggregate function performance.
Significant enhancements in the speed of bulk data loading using COPY.
Support for logical replication from standby servers.
Broadened SQL/JSON syntax including functions like JSON_ARRAY() & JSON_ARRAYAGG().
Introduction of pg_stat_io for detailed I/O metrics.
https://postgresql.org/about/news/postgresql-16-released-2715/
Hydra 1.0 Generally Available
An open-source plugin that integrates columnar tables into Postgres, enabling efficient analytical reports without altering the database.
https://www.hydra.so/blog-posts/hydra-1-generally-available
Frustratingly simple ETL for Postgres
From Microsoft and Citus Data emerges a fresh platform devoted to the seamless transfer of data to and from Postgres. While there's a handy quick start guide available, the core concept revolves around effortlessly merging various data-stores, including Postgres, Snowflake, and BigQuery. This platform also provides real-time synchronization, tailored ETL processes, and a mechanism to execute federated queries across these data sources.
Linux Foundation Launches OpenTofu: A New Open Source Alternative to Terraform
Another episode of the Terrafomr saga with this new fork, but it seems that the originator behind the first for are in agreement with the Linux foundation so there should be only one main fork which is good.
Drupal core - Critical - Cache poisoning - SA-CORE-2023-006
In some situations, the JSON:API module in Drupal may produce error backtraces. Under certain configurations, this could result in the caching of sensitive information, making it accessible to unauthenticated users and potentially leading to an elevation of privileges.
https://www.drupal.org/sa-core-2023-006
Atlassian September 2023 Security Bulletin
https://confluence.atlassian.com/security/security-bulletin-september-19-2023-1283691616.html
GitHub Actions could be so much better
Using most of the CI/CD tool is a pain and I totally agree with the fact that these tools where designed with very little thinking about development workflow (developer experience) and it is very hard to debug. Circle CI made easy, at least, to log into the instance that is running the code and give you the possibility to debug in real-time.
https://blog.yossarian.net/2023/09/22/GitHub-Actions-could-be-so-much-better
Nix 2.18 released
https://discourse.nixos.org/t/nix-2-18-released/33249
Scaling Kafka to Support PayPal’s Data Growth
An in-depth introductory article on scaling Kafka is available, which discusses the processes for onboarding topics, configuration management, monitoring, security, and more.
https://medium.com/paypal-tech/scaling-kafka-to-support-paypals-data-growth-a0b4da420fab
How to (Right) Size a Kubernetes Cluster for Efficiency
From Akamai/Linode an examination of how to right-size Kubernetes cluster nodes is presented, including a detailed description of the CPU and memory usage by the Kubelet.
https://www.linode.com/blog/kubernetes/how-to-right-size-a-kubernetes-cluster-for-efficiency/
Streamlining Software Delivery with Jenkins: A Hands-On Guide. Part 1
I think Jenkins is a legacy CI/CD tool but it might still be useful to know the syntax of a Jenkinsfile.
From The Bullhorn, Issue #117
Introducing the New Ansible Galaxy
Over the past few months, the dedicated Red Hat Ansible team responsible for the Ansible Automation Hub and Ansible Cloud Automation Hub, both accessible via console.redhat.com, has been on a mission to elevate the galaxy_ng code base. This code base serves not only the components mentioned above but is also geared towards replacing galaxy.ansible.com with a brand-new, cutting-edge foundation.
From its inception, galaxy_ng was designed with the ambition of supplanting the aging galaxy.ansible.com while also serving as the core code base for the Automation Hub component within the Ansible Automation Platform. The enhanced galaxy is already accessible at beta-galaxy.ansible.com. We’ve been meticulously synchronizing the data to ensure it remains up-to-date.
We are thrilled to announce that we will be transitioning galaxy.ansible.com to this new codebase on September 30th. Our commitment to the next generation of Galaxy services on this unified codebase remains unwavering.
If you access Ansible Galaxy through the ansible-galaxy CLI or the new v3 API, the process is straightforward: regenerate your access token, you can immediately log in to beta-galaxy.ansible.com.
After the transition, the previous site will continue to be accessible at old-galaxy.ansible.com, serving as a read-only instance.
We warmly invite all contributors to provide their valuable feedback on forum.ansible.com, utilizing the galaxy tag.
Best regards,
The Galaxy Team
linuxserver.io
This very interesting project has Linux servers on Docker. For instance I am using a Remote Desktop solution on Ubuntu for a project.
Apache Guacamole
Apache Guacamole is a clientless remote desktop gateway. It supports standard protocols like VNC, RDP, and SSH.
We call it clientless because no plugins or client software are required.
Thanks to HTML5, once Guacamole is installed on a server, all you need to access your desktops is a web browser.
Newsletter sponsor: Nexteam
Technology, Experience, Delivered.
Thanks for reading the Infra Weekly Newsletter! Subscribe for free to receive new posts and support my work.