JetThoughts has been building software since 2008. Book a call, or write to sales@jetthoughts.com. You'll leave the call with a written one-page scope within 2 working days.
A 30-minute call; pick a time.
Rails 7.1 .with: Common Table Expressions in Active Record
Rails 7.1 added the .with query method, bringing Common Table Expressions into Active Record. How CTEs work, and when they make a query clearer.
Turbocharge Your Rails Apps with Smart Database Indexing
Is your Rails application running slow? Are search queries taking forever to complete? The solution might be simpler than you think.
Efficient Percentile Ranking in PostgreSQL
When analyzing data, percentiles help us understand the relative ranking of records within a dataset.
Understanding Optimistic and Pessimistic Locking in Ruby on Rails
When several people touch a database simultaneously, software conflicts can occur when more than one user tries to update the same record.
Speeding Up Slow Elasticsearch Queries With the Profile API
Learn how to optimize search performance using Elastic Search's Profile API, including tips on limiting fields and avoiding wildcard searches.
Linking PostgreSQL Tables That Share No Foreign Keys
Databases often evolve in unpredictable ways. Tables that were initially designed to operate independently might later need to be connected.
Upgrading PostgreSQL on Heroku: A Step-by-Step Guide
Upgrade PostgreSQL on Heroku with little downtime: create a follower, enable maintenance mode, upgrade and promote it, check the app, drop the old DB.
How a Large Transaction Caused DB Deadlocks, and the Fix
Recently in a project, we encountered the fact that sometimes we had a DB Deadlocks error.
Data Migrations in Rails: Problems and Possible Solutions
Data migration is a common part of working with databases, and Ruby on Rails developers have many tools at their disposal.
Rails ActiveRecord Joins vs Includes: The Difference
The main difference is that when using includes the eager loading is used.
Tell us what you need built