Many a times, depending on the requirements, it makes sense to store unstructured json data in database fields. PostgreSQL recognizes this requirement and provides a dedicated json field that automatically handles JSON validation. As has been outlined in theRoR Guides, it is pretty simple to take ad...
SQL Views are a handy feature that allow us to save a query whose results are computed/collated dynamically whenever the view is requested. Because the abstraction provided by a view is semantically close to a table we can leverage ActiveRecord to interface with the view through a proxy model and us...
© 2021 Gaurab Paul
Unless otherwise mentioned in specific contexts, all code is licensed under the The MIT License and all content and artwork is licensed under CC BY-NC-SA.
The opinions expressed herein are author's personal viewpoints and may not be taken as professional recommendations from any of his previous or current employers.
Header Image credit: Nikita Khandelwal