PowerRuby CE2 (EN)

PowerRuby Community Edition 2 was released on October 20, 2018. It is in fact the fusion of Developer Edition and Community Edition: the component covered by license key (which characterized the Developer Edition) has thus become part of the packaging of the CE2 version as option 1. This option allows the use of a gem (so called the additional modules in Ruby jargon) that allows access to DB2. The grace period is only 7 days but – for registration – you can receive a license key valid 7 years from the date of release (so until October 20, 2025).

The entire PowerRuby project is the result of an investment by the British company Dancerace Ltd to explore new possibilities for the use of IBM i architecture in the field of application development. In this sense, the heart of the operation was to implement the extensions aimed at integration to db2. I will just point out three aspects of this integration here.

The first aspect is Unicode. All web development allows you to use UTF-8 encoding uniformly, but problems can occur when you access the database. One approach would be to create all tables with text fields defined to handle Unicode. In this way we would not have enhanced a feature of DB2: DB2 for IBM i is able to convert the encoding to write and read -selectively for each field – without imposing anything on the application. It was therefore a question of offering in the definition of the fields (the so-called “migrations” of Rails) the possibility of indicating field by field a specific CCSID: and that is what we did.

The second aspect is the integration of foreign key support into the elegant logic offered by Rails’ Active Record. All definition operations are borne by the middleware Rails which also adopts here the famous concept CoC (Convention-over-Configuration)

The third very elegant aspect (for cleaning the application code) is having integrated the transaction support offered by Active Record. Multiple actions on the database can then be collected within a single Unit-of-Work with clear syntax.

The starting point to delve into is the official documentation.

Support (and license key request) is carried out through the support@powerruby.com address.

Enjoy PowerRuby CE2!

Related Posts
DB2 for i SQL – String Manipulation – POSSTR-LOCATE-LOCATE_IN_STRING (EN)

Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful Read more

DB2 for i – FAQ & Howtos (EN)

DB2 Database and SQL ... maybe the most important things on IBM i platform: here's a collection of FAQs, tips Read more

IBM i 7.4 Announcement (En)

Comes directly with the Easter egg this IBM announcement for the news of the IBM i 7.4 version, iNext version Read more

Generated Always Columns (EN)

Introduction "Generated Always Column": are columns, table fields, filled by DB2 engine: something like columns with a default value but Read more

Recent Posts

IBM i: System Management is Simpler Than You Think

If you work with IBM i, I recommend reading this insightful article by Giancarlo Lui: IBM i System Management: Simpler…

2 months ago

RPG Free and option(*convert) for paramters

In his recent article "RPG Free and option *convert" , Aldo Succi explores the *CONVERT option in the RPG language,…

2 months ago

CA Certificate Update for the European Central Bank (ECB): A Practical Guide

Updating Java and DCM Certificates for ECB Exchange Rate Retrieval on IBM i In our blog, we have previously discussed…

2 months ago

Managing Locked Display Files on IBM i: An Effective Solution

We are pleased to receive and share this "tip & trick" from Patrick Rizzi, which introduces a technique that allows…

6 months ago

Monitoring QSYSOPR Messages: SQL to Retrieve Messages and Replies

I take inspiration from a response by Michael Mayer on the Midrange.com mailing lists to someone who asked how to…

6 months ago

Why ERP is the Key to Success for Modern Businesses

Businesses are increasingly seeking tools to enhance efficiency, collaboration, and resource management. Enterprise Resource Planning (ERP) systems provide a comprehensive…

8 months ago