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