• Home

  • Episodes

  • About

  • Login
    •
    Reset

    View

    Episodes

    Sort

    Tags

    Database, Model and Scopes
    Play
    15:36 CC

    Database, Model and Scopes

    #150 Sep 9, 2018 pro
    In this episode, we take a look at some tips and tricks around the database schema and model scopes.
    rails model database
    38
    2
    Materialized Views in PostgreSQL
    Play
    13:43 CC

    Materialized Views in PostgreSQL

    #324 Nov 21, 2021 pro
    Using Scenic, you can bring the power of SQL views to your Rails application without having to switch your schema format to SQL. Scenic provides a convention for versioning views that keeps your migration history consistent and reversible and avoids having to duplicate SQL strings across migrations.
    database rails postgresql query
    8
    1
    Database Encoding
    Play
    10:32 CC

    Database Encoding

    #264 Oct 18, 2020 pro
    In this episode, we look at the encoding and some problems that an older Ruby on Rails application may face when it comes to storing emojis and how to fix them.
    database rails
    7
    1
    PostgreSQL Hstore
    Play
    12:28 CC

    PostgreSQL Hstore

    #259 Sep 13, 2020 pro
    The hstore data type is very useful in many cases, such as semi-structured data or rows with many attributes.
    database rails
    9
    2
    MySQL FULLTEXT Search
    Play
    18:59 CC

    MySQL FULLTEXT Search

    #386 Jan 29, 2023 pro
    In this episode, we look at implementing full-text search in MySQL. Using some of the built in functions of MySQL, we are able query tables and add weighted results.
    rails database mysql search
    5
    4