I have a table containing weather information for various locations. Each location is identified by an identifier station_id, and each kind of information is identified by a string (e.g. wind_speed, humidity,...). Here is a simplified example. first_time and last_time are…
I have a database table cars that has close to 500k records. I was facing issues with long loading times to load data from this table. @cars = Car.order('created_at DESC').paginate(page: params[:page], per_page: 100) It took anywhere between 30-40 seconds to…
I'm working an events feature, and I'm running into a rather involved query. Here's the models for reference: class Event < ApplicationRecord has_one :party belongs_to :host, foreign_key: :host_id, class_name: 'User' belongs_to :convention, optional: true has_many :join_requests ... end I'm looking…
When running this ActiveRecord migration on the test (not production) database, large changes in db/structure.sql appear. This is reproducible. The changes are: A small number of the expected changes based on the migration code (as desired). A large number of…
I have the below Model structure class Transaction belongs_to :company belongs_to :user end class Company belongs_to :address end class User belongs_to :address end classAddress has_many :companies has_many :users end I want to query all transactions and get both company address…
We need to order a list of room numbers. You can think of the units being numerically ordered, with the possibility of a letter in front as a prefix, e.g 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,…
In a rails app, i have a 3 models, Room, User and UsersRoom which is an association table between Room and User. I want to query for a Room related to multiple users. If i do: Room.includes(:users_rooms).where(users_rooms: { user_id: user_ids }…
Rails 7 MySQL 8 I have a model Author, with an attribute book set as a JSON. The book JSON structure: book => { 'title', 'pages', 'publication_date'} } I have an array of titles: titles = ['Tree','Ice','Pulp'] I tried: authors…
I am getting duplicate and sometimes unordered results with doing a LEFT OUTER JOIN. I think the issue is that there are many artwork_colors that can match the WHERE condition. But I just want the artwork's artwork_color with the highest…
I'm struggling to understand why I'm unable to call .where on the results of what looks to be an ActiveRecord query. I'm dipping down into SQL a bit to create virtual columns for matching. We have two models: Organization and…