Hi! I am deploying a rails 7 app (7.2.2) on ruby 3.3.5 with an AR adapter for sqlserver (activerecord-sqlserver-adapter). As of version 7.2 the adapters have to to register themselves with AR in o...

Hi, I have a classic hierarchical entity with single level of nesting ``` class Job < ApplicationRecord has_many :children, class_name: 'Job', foreign_key: 'parent_id' belongs_to :parent, op...

If I am working on a db with millions of users and i have a job that requires updating multiple tables, what is the best way to approach this? I was thinking to wrap it in a transaction but the iss...

class Propose < ApplicationRecord encrypts :email, :phone_number, :name, deterministic: true scope :search_filter, -> (params) do if params[:keyword].present? where(search_filte...

I've taken a few stabs at this over the past two months and haven't found a great solution for what seems to be a straightforward feature seen in applications such as SkipTheDishes and UberEats. G...

I'm trying to connect using some of the gems:sequel, dbi, ibm_db, jdbc-as400-adapterWithout success, does anyone have the same problem?

Buenas estimados, quisiera saber cómo actualizar la versión 13.12 a 13.14, actualmente apliqué sudo yum update postgresql13, si embargo actualizó y ahora me devuelve lo siguiente, pero sigue en la ...

I've got Postgres15 installed via Homebrew, and it's running. When I build a new Rails 7 app with: "rails new testapppg -d postgres" I can't get it to install pg (1.4.6) I see errors like "Unable ...

How's it going? Any gotcha's worth sharing? Any special configs to getting it set up with hatchbox?

I have a model that I want 2 users to have an association with. So this model would have a proposer (user) and a challenger (a different user). I am getting a bit tied up in spaghetti around whethe...

I am rebuilding an application that stores data for search and recovery divers. Previously, it was for a single team and we used the english measurement systems, however, now that the application i...

Question: I tried to set up a polymorphic model and got the following error: no value provided for option '--orm' I'm using Rails 7 and postgresql I tried most probably solutions I found and revi...

Hello and a wonderful day at all. I'm a new RVM, Ruby and Rails user and I have a problem. My problem is: I can't connect my App to a database. My System: - OS: Rocky Linux on a Hypervisor VM - ...

I am currently using ODBC connection with 'ruby-odbc' and 'Sequel' gem but I am finding it incredibly slow. Thirty-Five seconds to load 12 records while it was instantaneous with the now retired M...

I'm creating an app for my company. In that application there are a lot of addresses because for Owner, Store, Landlord, etc needs to have address. At first I was thinking to create separate model...

I'm confused about where to put code for a custom validator I wrote, should I create a nested class inside the model file? or create a new file in models/concerns? I have the code but don't know wh...

I've been working on one project that has already implemented a multi-tenant database setup using the apartment gem. and now I need to connect this multi-tenant database to my other project. I've c...

I am getting the following error: ActiveRecord::StatementInvalid (PG::InsufficientPrivilege: ERROR: permission denied for relation users.. It is definitely a role issue but I am not sure what coul...