I have a model with a jsonb field where responses from a third-party service are stored. The response changes periodically; some fields are added, some disappear. I want to generate a CSV from a sample of records. To do this,…
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 have a database table holding 500k records. I need to load these records, do an API call, fetch data from this API endpoint, and save new data back to the database. I tried to do it like this (simplified…
I am using mongodb for first time. I have below models class Legacy::User include Mongoid::Document has_many :customers field :username, type: String end class Legacy::Customer include Mongoid::Document belongs_to :user field :user_id, type: String end When I run below query it doesn't…
I have a scenario where I have a table users with information about the users in the system. This table currently has about 70 columns - out of these 70 columns, 4 are related to the user's address. Now, I…
I have a model Item with the corresponding database table items where is currently about 240,000 records. I need to generate statistics from the data in the items table on my dashboard. Currently, I am trying to do it this…
I'm trying to configure a Rails 7.1.3/Turbo 2.0.5 app locally to try out broadcasts_refreshes for a simple model. On the view template that tries to turbo_stream_from this model, I'm getting websocket errors, indicating that it is trying to connect. Here…
I finally managed to deploy my Rails app to a DigitalOcean server. In the end of the deployment log, there were these two lines: ... -----> Shutting down old containers in 60 seconds =====> Application deployed: http://myapp-prod.packer-6481b5fa-xxxx-yyyy-zzzz-a2621ac2dcee:3000 http://test:3000 The first…
I have a script that runs for a few minutes as a job on the cluster in the production environment. There are between 0 and 100 such jobs, each with 1 script per job, running at the same time on…
I'm developing an application for a horsemanship school so they can organize their classes and see who booked a class and whatnot! In the display of all the classes, I've created to help users choose the day they want to…