PostgreSQL 17: JSON_TABLE(), MERGE with RETURNING, and Updatable Views
It’s time for a new Postgres release! PostgreSQL 17 shipped a few weeks ago, with lots of new features to explore.
Software Engineer, Author, Consultant
It’s time for a new Postgres release! PostgreSQL 17 shipped a few weeks ago, with lots of new features to explore.
This is Part 1 of my recap of Rails World 2024, a phrenetic two-day conference in Toronto, Canada, September 2024, with 1000+ attendees.
Solid Cache is a relatively new cache framework that’s available as a Ruby gem for Ruby on Rails. In the next major version of Rails, version 8, it’s becoming the default cache backend.
Why Solid Queue? Background jobs are commonly used in Ruby on Rails apps to perform any work possible outside of an HTTP request. A classic example is sending an email notification. Sending email from a background job places the latency...
In this post, you’ll learn a recipe that you can use to “shrink” a large table. This is a good fit when only a portion of the data is accessed, the big table has become unwieldy, and you don’t want...
Welcome to Madison Madison+ Ruby 2024 was held August 1st & 2nd in Madison, WI, following a 5 year hiatus. Despite being in the Midwest and being a smaller regional conference, attendees came in from all over the US and...
Readers are sharing that they’ve received their copies of the book on social media. I love to see these.
PostgreSQL uses a complex system of locks to balance concurrent operations and data consistency, across many transactions. Those intricacies are beyond the scope of this post. Here we want to specifically look at queries that are waiting, whether on locks...
This post will look at the basics of PostgreSQL Savepoints within a Transaction.
In this talk attendees will learn how Ruby on Rails and PostgreSQL can be used to create scalable SaaS applications, focusing on schema and query design, and leveraging database capabilities.