How to implement database views in Ruby on Rails

Question

I'm just wondering how to implement database views in Ruby on Rails. Can you guys put some working example? And thank you for every advises and examples.

Cade Roux · Accepted Answer · 2010-07-15 04:23:05Z

3

You mean client-side views on the database or views within the database?

Most relational databases support views which encapsulate a projection or other set-based operation into a virtual table:

CREATE VIEW viewname AS
SELECT *
       ,some_derived_column
FROM basetable
WHERE some_filter_criteria

Rails typically uses a pattern called Active Record to map database tables/views into Ruby for access at that layer. How you deal with it at that point is kind of wide open.

answered Jul 15, 2010 at 4:23

Cade Roux

90.1k42 gold badges186 silver badges268 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to implement database views in Ruby on Rails

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related