Help with database design and associations
I have taken a look at Polymorphic associations and STI but I don't really know if they apply to my specific use case. In my app I have the following relevant classes:class Restaurant < Applicat...
![](https://secure.gravatar.com/avatar/133fa52e10be45b3620c6ed574786534.png?default=mp&rating=pg&size=48)
I have taken a look at Polymorphic associations and STI but I don't really know if they apply to my specific use case. In my app I have the following relevant classes:class Restaurant < Applicat...
Really, if you don't use Relay, you won't need the pro version. That's the only GraphQL gem I'm familiar with, though.
Hey Robert. Thanks for the response. I've ended up just going with a triple nested form: ``` class Roast < ApplicationRecord has_many :countries end class Country < ApplicationRecord ...
Here is the case , I got users and a few other models , most of them end up doing some action with one main table that contains around 15M rows. I have an indexed foreign key between the main tabl...
I am working on an app for a real estate company. There will be 2 resources, Listings and Rentals. They will have a lot of the same data (address, beds, baths, sqft, etc.) but also different (ren...
It worked very well, thanks
ashley [5:41 PM] _“model obesity”_ excellent term, @inopinatus! This is a _software engineering_ issue not limited to Rails, for sure. It’s interesting to me that there’s never been a group o...
Hi everyone! I have to transform this spreadsheet [Spreadsheet](https://www.dropbox.com/s/w9gqasloxre9sr7/spreadsheet-mechatronics-engineer.png?dl=0) into database model. This spreadsheet is part ...
@Tabish Iqbal, do you mind showing me how the models would be set up? I don't seem to understand how the self joins would work in this case.
I've gotta store a bunch of events, which are snippets of data that contain information about a thing that happened inside the system I'm working on. I'm building out audit trail, which could poten...
I am buidling an application for real estate centered around comparing properties. I have a self referential relationship, Comps, which joins two properties and stores some additional data. Giv...
For anyone interested this post talks about how to setup multi-tenancy using uuid's and not subdomains using postgresql. http://andrewmarkle.com/2016/04/06/multitenancy-with-pundit/
Congrats Chris on getting this live. That looks like a great feature.
Try this https://github.com/zdennis/activerecord-import
Also In the first example, I simplifid too much `usage item` entity. It has more than 4 ~ 6 different column from other types of invocie items. (`subscription item`, and `proration`) So it's not r...
Awesome, thanks so much Chris!!
Hey @tabish Category’s haven't been a problem for me in the past, I’ve done about a dozen prototype applications using them, the difference with this application is the amount of different categor...
Oooh Evil Cognos... lol. I'm having to deal with data translation and import so the way I did it was to write a simple rake task using the `CSV` class that imports my data into the appropriate mod...
As Chris mentioned, you'd be better off moving to a shared database such as MySQL or PostgreSQL. This way the data persists in production. All you need to do is configure the database information...
Peter, is this in development or in production? If it's Linux and your on production you can do a `service postgresql status` to see if it it's running or a `ps aux | grep -i post` to see if there...