Limiting Text Input
Play
18:41 CC

Limiting Text Input

#350 May 22, 2022 pro
User experience is important and there are little things that we can do to help improve this experience. By giving real time feedback on text inputs to approaching limits on fields, the user can modify and update their text accordingly before they submit the form. In this episode, we look at database level, model validations and limiting text input on the client side.

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.

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 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.

Multiple Databases
Play
12:33 CC

Multiple Databases

#353 Jun 12, 2022 pro
As an application grows in popularity and usage you'll need to scale the application to support your new users and their data. One way in which your application may need to scale is on the database level. In this episode, we look at reading from a replica database while writing to a primary database. We also look at structuring our application top support multiple databases; each containing their own schema.