First Issue of Railsmine News. Railsmine News is a collection of Ruby and PostgreSQL news and tutorial. Hope you enjoy it.

Ruby

mb-geometry - Recreational Ruby tools for geometry. This ranges from simple functions like area calculation and line intersection, to Delaunay triangulation and Voronoi partitions.

DragonRuby - DragonRuby creates toolchains that allow developers the ability to build apps and games using a programming language called Ruby.

Ruby on Rails Controller Patterns and Anti-patterns - Previously, author covered patterns and anti-patterns in general as well as in relation to Rails Models and Views. In this post, author are going to analyze the final part of the MVC (Model-View-Controller) design pattern — the Controller.

The Ruby Unbundled Series: Release Features Faster by Slowing Down - There is a saying that in order to speed up, you need to slow down. This is true in software development in that we want to control the rate at which users receive new features.

How to Implement API Key Authentication in Rails Without Devise - When it comes to authentication, Ruby on Rails is a batteries-included framework. Devise is over-kill for an API.

PostgreSQL

TOAST - TOAST is a mechanism PostgreSQL uses to keep physical data rows from exceeding the size of a data block (typically 8KB). Postgres does not support physical rows that cross block boundaries, so the block size is a hard upper limit on row size.

Getting started with QGIS, PostgreSQL and PostGIS - In this mini-tutorial, you will learn how to quickly visualize OpenStreetMap (OSM) data with PostGIS and QGIS.

Kubegres - Kubegres is a Kubernetes operator allowing to deploy a cluster of PostgreSql instances with data replication enabled out-of-the box. It brings simplicity when using PostgreSql considering how complex managing stateful-set’s life-cycle and data replication could be with Kubernetes.

Lessons Learned From 5 Years of Scaling PostgreSQL - A must read tips.

Debugging random slow writes in PostgreSQL - Understanding & mitigating randomly slow writes in PostgreSQL.

Reindexing all tables after upgrading to PostgreSQL 13 - Author reindexed all tables after the upgrade and saw index storage savings of up to 90%.

Is Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL a better choice for me? - In this post, author explains how to determine the best option between Amazon RDS for PostgreSQL and Aurora PostgreSQL for your workloads and business requirements.