We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
RailsConf 2023 - Beyond CRUD: the PostgreSQL techniques your Rails app is missing. Shayon Mukherjee
Learn PostgreSQL techniques to boost your Rails app's performance and concurrency. Discover advisory locks, optimistic concurrency control, and more to optimize your database management and ensure correct updates in the presence of concurrent updates.
- Advisory locks can help reduce contention between concurrent updates in a PostgreSQL database.
- Optimistic concurrency control can be used to ensure that updates are persisted correctly, even in the presence of concurrent updates.
- Skip locks can be used to avoid acquiring locks during concurrent updates, reducing contention.
- Pessimistic locking can be used to lock individual rows in a database, but this can lead to contention and slow query performance.
- RailsConf is a conference on Ruby on Rails and related technologies.
- Sidekiq is a Ruby gem that provides a scheduling system for Ruby applications.
- Rufus Scheduler is a Ruby gem that is used by Sidekiq to schedule jobs.
- Tines is a no-code automation platform for security teams.
- PostgreSQL is a relational database management system that is widely used.
- Concurrency control is important for ensuring that updates are persisted correctly in a database, even in the presence of concurrent updates.