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

5
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...

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

Learning Ruby on Rails? Join our newsletter.

We won't send you spam. Unsubscribe at any time.