How do I structure a Bookings table for two models?
I've primarly built out support to book a flight, and now I'm looking to offer the ability to book a hotel as well. I'm looking for some insight on the best way to model this: Currently there is...Taylor Cooney posted
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...Jacob Abraham posted
403 errors on Nginx server
Hello, I have installed ruby on rails on digital ocean with NGINX and Passanger. the site was working find but after trying to install free ssl, it goes full wrong. i was following this article...SMEHSAN posted
find_by not returning array but class insance
What am I missing please? class Choice < ApplicationRecord belongs_to :choiceable, polymorphic: true belongs_to :room_item, optional: false end create_table "choices", force: :cas...jason Mardell posted
How can I improve query time in SQL ? (PostgreSQL)
Any ?Boris Bresciani replied • Solved
TinyTds::Error (closed connection): when using Apache/Passenger
Hello Chris, I am only using Puma or Passenger, definitely not both at the same time. When using Puma I start the rails server (i.e rails s -e production) from the application directory and the pa...William Jones replied • Solved
Gem for Master-slave Replication
Hi, I'm trying to make master-slave replication(One master(write/read) and one slave(read only)) for my database(mysql 8 / rails 4.2). I researched whole day but I'm still considering which gem is ...Sean posted
How to do a incremental backup
I was using postgres database. Changed wal_level to replica, & turned on archive_mode. Then it started generating wal files, which I used to restore to point in time recovery.Nithil replied • Solved
How do I improve these relationships (Rails Association question) ?
Your `Bet` model would have two `belongs_to` associations (one for the creator and one for the backer or however you'd like to call them): ``` class Bet < ApplicationRecord belongs_to :cr...Nicholas Bayley replied • Solved
Design a store credit schema
Hi, I was wondering if anyone has some experience building a store credit system into a market place style app. Eg: Users could purchase 100USD in adavance and receive 120USD in store credits as in...gafemoyano posted
NameError (undefined local variable or method `fetch_records' for ....
Hey Chris, I found the solution. https://github.com/jbox-web/ajax-datatables-rails/blob/master/doc/migrate.md I used the old methods... Thanks for your help! and support!Victor Nizeyimana replied • Solved
How do I switch from 1 database to 1 database per client?
I believe you should consider to read this before migrate to the multi tenant way. https://influitive.io/our-multi-tenancy-journey-with-postgres-schemas-and-apartment-6ecda151a21fAry Rabelo replied • Solved
How do I convert a SQL query to rails?
Hi, I'm new to ROR. The query I created below is functioning properly. I'm trying to prepare an interrogation. But I didn't succeed. The query is as follows; @rad_check.tenant_id = SELECT gro...Emrah Yıldırım posted
Loosing my attached_images when cap deploy after switching my path so that my posts stay
Seems like this is more an Shrine.rb problem, i adressed that on SO aswell: https://stackoverflow.com/questions/52464556/after-capistrano-deploy-my-images-uploaded-via-shrine-arent-displayed-any...Sebastian replied
How do I write the correct association?
If I wanted to have a "user_type" column in my "users" table that references to another table called "user_type", how do I write the correct association in rails? For example if my user_type is 1 a...Arzee posted
Database Disconnect Error
HI,Most of the time I leave my DB management tool, like DBeaver, open on my computer. Sometimes after a long period of time I get an error because the connection has been dropped or reset. Specific...russell depp posted
What database should I use?
As Solomon David said MongoDB is one of the NoSQL database. Currently there are 150 of them (NOSQL Databases). It falls into the document store category. These categories are defined based on archi...saravanagumar replied
How to structure DB in such a way that we can create attributes dynamically in rails
Hi I am trying to create for example a contact model but currently i only know of for example first name, last name and email but would want to give the user a choice of entering more custom fields...Anand Duddella posted
Connect Rails Application to already existing MySql Database
Depending on wether you want to keep running the PHP app. If you don't, read into ActiveRecord, create your models and then write a few migrations to make sure the columns and indexes do match the ...Thomas R. Koll replied