Now You Can Run Ruby Inside Your Database

A new tool, plRuby, lets developers write and execute PostgreSQL database functions directly in the Ruby programming language, leveraging existing skills.

A new open-source extension for PostgreSQL called plRuby is now available, allowing developers to write database functions directly in the Ruby programming language. According to PostgreSQL News, this tool acts as a procedural language handler, integrating Ruby code so it can be stored and executed inside the database just like native SQL functions. This development bridges a significant gap for the large community of developers who use both Ruby and PostgreSQL, particularly those working with frameworks like Ruby on Rails. It provides a way to leverage existing programming skills for tasks that traditionally required learning PostgreSQL's own procedural language, PL/pgSQL.

The mechanism behind plRuby involves it acting as an intermediary between the PostgreSQL execution engine and a Ruby interpreter. When a database function written in Ruby is called, PostgreSQL passes the request and any arguments to the plRuby handler. The handler then executes the Ruby code, giving it access to the full power of Ruby's expressive syntax and its extensive standard library. The result is then passed back to PostgreSQL. This enables developers to create not just simple functions but also complex set-returning functions, triggers that react to data changes, event triggers, and even full procedures with transaction control, all without leaving the familiar environment of the Ruby language.

This matters primarily because it enhances developer productivity and lowers the barrier to writing sophisticated database logic. For teams with deep expertise in Ruby, plRuby eliminates the need for context switching between different languages and paradigms. Instead of writing application logic in Ruby and then rewriting or translating complex data operations into PL/pgSQL, developers can now use a single, consistent language across more of their stack. This can lead to faster development, code that is easier to maintain and review, and a more unified skillset within a development team, ultimately making it simpler to build powerful, data-intensive applications.

From a business and architectural standpoint, plRuby makes the already popular combination of PostgreSQL and Ruby even more compelling. By enabling complex logic to run directly within the database, it can significantly improve application performance for certain tasks by reducing the amount of data that needs to be transferred over the network between the application server and the database. This can lead to lower latency and a more responsive user experience. For companies, this translates into a more efficient use of development resources, a faster time-to-market for new features, and a more scalable and performant technology stack, reinforcing PostgreSQL's position as a highly versatile and developer-friendly database.

This release is part of a broader trend in the database world. PostgreSQL has long been known for its extensibility, supporting other languages like Python (PL/Python) and Perl (PL/Perl). The addition of plRuby caters to one of the largest remaining language communities not previously supported natively. This reflects a strategic shift across the industry to meet developers where they are, providing them with tools that integrate seamlessly into their existing workflows. By embracing popular programming languages, databases like PostgreSQL become more accessible and powerful, fostering innovation and solidifying their role as the foundation of modern applications.

plRuby significantly boosts productivity for developers who use both Ruby and PostgreSQL. It allows them to write complex database logic, like triggers and procedures, using a familiar language, reducing the learning curve of PL/pgSQL and speeding up development.

For businesses, this can lower development costs and accelerate product timelines. By enabling more logic to run inside the database, it can also improve application performance, making the popular Ruby/PostgreSQL stack even more efficient and attractive.