Talks
Speakers
Events
Topics
Sign in
Home
Talks
Speakers
Events
Topics
Leaderboard
Use
Analytics
Sign in
Suggest modification to this talk
Title
Description
PostgreSQL 9.1 introduced Foreign Data Wrappers, as an implementation of SQL/MED foreign tables, to provide transparent access to external data. Restricted to being written in C, writing FDWs can be a hard task. In this talk we will learn just enough of mruby's (the ISO-compliant version of Ruby) internals to understand how one can embed mruby in an external program (like PostgreSQL), and start writing Foreign Data Wrappers in Ruby.
Date
Summarized using AI?
If this talk's summary was generated by AI, please check this box. A "Summarized using AI" badge will be displayed in the summary tab to indicate that the summary was generated using AI.
Show "Summarized using AI" badge on summary page
Summary
Markdown supported
The video titled 'Ruby and PostgreSQL, a love story' features Franck Verrot discussing the integration of Ruby and PostgreSQL, particularly focusing on the use of Foreign Data Wrappers (FDWs) for accessing external data transparently. Franck shares his background, including his experience with PostgreSQL since 2009, and emphasizes the benefits of leveraging raw SQL for performance-sensitive operations. He highlights the need for efficient data management and how using the right tools and languages can enhance this process. Key points include: - **PostgreSQL Overview**: An introduction to PostgreSQL as a powerful relational database with an active community and the ability to handle extensive operations through raw SQL versus Active Record. - **Ruby's Role**: A discussion about the advantages of Ruby, particularly in creating Domain Specific Languages (DSLs) for tasks like data generation and business logic implementation. - **Foreign Data Wrappers**: An explanation of how FDWs allow PostgreSQL to access data from various external sources, such as NoSQL databases and HTTP calls, and the importance of understanding the relationship between local tables, foreign tables, and FDWs for seamless connectivity. - **Custom Index Access Methods**: Insights into creating and utilizing custom index access methods to optimize database performance and manage data more effectively. Franck emphasizes the significance of performance considerations when working with external data sources. - **PL-MRuby Initiative**: Franck shares his vision for an integration framework called PL-MRuby that would facilitate embedding Ruby directly into PostgreSQL's processes, allowing for dynamic data fetching via Ruby code. - **Future Outlook**: A discussion on the potential growth of integrating various technologies within PostgreSQL and the opportunities this presents for developers. Concluding, Franck encourages developers to explore the intersection of Ruby and PostgreSQL, emphasizing that this integration can open numerous pathways for enhancing data processing and accessibility in development projects. He invites further questions, particularly on optimizing foreign data access through techniques like predicate pushdown.
Suggest modifications
Cancel
