Skip to main content
How can I improve query time in SQL ? (PostgreSQL)
Databases • Asked by Boris Bresciani
Hi, I have 4 models: ``` class Match < ApplicationRecord belongs_to :tournament scope :next, -> { where('date > ?', Time.zone.now) } end ``` ``` class Tournament < Ap...
2
posts

ibm Iseries AS/400 DB2
Databases Solved • Asked by Manuel Martinez
I'm trying to connect using some of the gems:sequel, dbi, ibm_db, jdbc-as400-adapterWithout success, does anyone have the same problem?
6
posts

TinyTds::Error (closed connection): when using Apache/Passenger
Databases • Asked by William Jones
When I start my application using Puma on port 3000 everything works as expected (no error). When I try to access the application after starting Apache, using the default port 80, I get the error "...
5
posts

Gem for Master-slave Replication
Databases • Asked by Sean
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 ...
1
post

How to do a incremental backup
Databases • Asked by Nithil
Hey, taking a full backup every day will be huge, so thinking of doing a full backup once in a month & incremental backups every day or so. I would like to know the best solution to achieve this.
1
post

Should Categories be it's own resource or model attribute?
Databases Solved • Asked by Ariff Munshi
Hey guys, I have a question on database design. Say I have a Post model that has/belongs to a category (out of about 20 categories or so). I am thinking of two options that have their own merits.1....
5
posts

How to perform bulk update in rails?
Databases • Asked by Srinivasa Varma
Hi there, Here is the problem in more detail. I tried to perform bulk update on rails model, but ended up with normal save method. I have some number of records and i wanted to update their valu...
2
posts

How do I improve these relationships (Rails Association question) ?
Databases Solved • Asked by Ignacio Alonso
Im trying to make a project to practice more kinds of associations would you kindly help me understand this? The basic idea is to have a betting game where one user generates a new bet that can ...
2
posts

Design a store credit schema
Databases • Asked by gafemoyano
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...
1
post

NameError (undefined local variable or method `fetch_records' for ....
Databases Solved • Asked by Victor Nizeyimana
Hi, I'm getting this wierd error. ``` NameError (undefined local variable or method `fetch_records' for #): app/controllers/admin_controller.rb:69:in `block (2 levels) in comments' app/con...
4
posts

Subscribe to the newsletter

Join 20,000+ developers who get early access to new screencasts, articles, guides, updates, and more.

    By clicking this button, you agree to the GoRails Terms of Service and Privacy Policy.

    More of a social being? We're also on Twitter and YouTube.