Help with a music listings website but I need help designing the models

1
Databases
I want to create a music listings website. Venues and musicians can have their own profile. I want some of my users to be able to create listings. The people who create the listings could be a mus...
Chris Oliver replied

setup Postgres user fails

8
Databases
Hi, I'm following the Deploy Rails guide I'm now a the part where Postgres gets installed. I successfully installed Postgres, but when I try to create a new Postgres user with: createuser --...
shakycode replied

could not connect to database postgres

2
Databases
I'm trying to install postgresql but I'm running into an error when I try to create a user: createuser: could not connect to database postgres: could not connect to server: No such file or dir...
shakycode replied

Capistrano deploy removes tables from database.

3
Databases
I use capistrano to deploy my Rails app to my VPS, but after every deploy when I visit my page I get an error. The log says: I, [2014-11-04T08:20:16.659289 #12482] INFO -- : Started GET "/" for...
shakycode replied

Why is my Sqlserver so slow??

0
Databases
I'm using Rails 8 with gem "activerecord-sqlserver-adapter", "~> 8.0", ">= 8.0.1" gem 'tiny_tds', '~> 3.0.0', I have have a postgres db on Render and my company has s Sqlerver db on Azure...
Beavidy posted

Activerecord adapter for sqlserver is loaded AFTER connection attempt is being made (?)

0
Databases
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...
Mark Hapke posted

How do I modify the query used to eager load associations

0
Databases
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...
mchwalek posted

Transactions

2
Databases
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...

How we can use Like queries for searching on encrypted data? I used default Active Record Encryption

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

How do I manage business hours for a store?

8
Databases
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...
Solved

ibm Iseries AS/400 DB2

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

Cómo actualizar PostgreSQL 13.12 a 13.14

0
Databases
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 ...
Isaac Rodríguez Varela posted

Rails 7 and postgres 15

9
Databases
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 ...
Randy Medina replied

Anyone using Litestack + SQLite in Production

2
Databases
How's it going? Any gotcha's worth sharing? Any special configs to getting it set up with hatchbox?
Rich Smith replied

How do I have 2 users associated with a model

0
Databases
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...
dwedigital posted

Storing measurements for users in metric and english measurement systems

1
Databases
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...
Chris Oliver replied

No value provided for option '--orm' Error

2
Databases
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...

Database connect

0
Databases
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 - ...
RubySnug posted

Anyone have any brilliant solutions for connecting to Snowflake.

0
Databases
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...