Curated list of episodes, bundled to help you on your learning path!
Videos of tech, infrastructure, hardware and software which non-instructional by nature.
Articles around software and tutorials.
Show your love and support while looking fancy.
Got a question or want to chat about a topic? Let's talk!
In Ruby on Rails 5.1.0, generated virtual column support was added for MySQL and MariaDB. Using generated and stored columns can leverage heavy calculations to the SQL side.
Using the paper_trail gem, track changes to model records for auditing purposes and rollback changes when required.
Continuing from Episode #87, we take a deeper dive into virtual columns in Rails 5.1 and use them to parse JSON Data Types with adding indexes to the virtual column.
When database tables get large, things can slow down significantly. In this episode, we look at a few things which helps keep databases performant and the client side responsive.
Some cases require non-auto incrementing primary keys as well as multiple master writes without id conflicts. With ActiveUUID, we can configure our table's primary key with confidence without added complexity.
N+1 queries can make an application slow. Having queries called within views can also slow down an app as well as making it less extendable.
This episode covers different tips and tricks around database migration files.
Adding indexes to your databases can increase the SQL search performance on your tables. As your application grows, migration files can become out of hand, use squasher to squish them down to a single file.
For various reasons, we may decide to move our services off of one platform onto another. This could be due to pricing, uptime or other reasons. In this episode, we look at migrating a Ruby on Rails application and database from Heroku to Fly.
In this episode, we take a look at some tips and tricks around the database schema and model scopes.