Open source RDBMS (relational database management system) when used in conjunction with the Ruby on Rails framework.
1
vote
0answers
35 views
Rails: Update a column with the value of a column in another table
I have basically the following code:
ModelA.join(:modelB).update_all('modelA.column = modelB.column')
That fails with:
ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: missing ...
0
votes
1answer
17 views
Compare only the times of two timestamps in postgres
In PostgreSQL, I need a way to determine if the current time is within the hours of operation of a certain model with an opens_at and closes_at timestamp. What would be a valid Postgres way of doing ...
0
votes
0answers
33 views
Radio button selection Rails - Across partials
I am trying to allow the user to pick one of the predictions out of the 7/8 (which are loaded with the predictions partial) as a double match (double points for anyone interested). I can't get it to ...
1
vote
1answer
31 views
Too many database connections created in rails 2.3.18 application
We have many models like the below one.
class User < ActiveRecord::Base
create_connection
def create_connection
# we have used this ...
0
votes
0answers
42 views
digital ocean(ubuntu) - how many rails apps can be hosted in a 512mb plan (including others like nginx, postgres etc) [closed]
I am setting up some rails apps on digital ocean basic plan of 5$ per month offering 512mb memory. I just installed basic things like git, vim, nginx, postgres(along with contrib), rvm and now just ...
-1
votes
0answers
46 views
Heroku keeps telling me my application fails
So I am trying to push my site to heroku for the first time and some things have gone wrong. First was the postgres DB stuff so I added the gem for pg in the production group but it continues to say ...
-1
votes
0answers
29 views
Deploying to Heroku issues Rails 3.2
So i had an app that i initially developed in SQLITE and converted over to POSTGRESQL and it works fine locally. When I try to deploy to Heroku my web dynos crash when I try to visit my application. ...
1
vote
2answers
67 views
rails - does postgres or rails automatically validate that a datetime column can only have datetime object?
I have a rails 4 form in which a user inputs a string that represents a datetime:
<%= f.text_field :time_frame, class: "calender_pop" %><br />
No where in my code am I converting the ...
1
vote
0answers
31 views
Populating rails Database from Amazon RDS data
I currently am working on an inventory application(rails 4.0 on Heroku using PostgreSQL). I also have a database that tracks my sales on Amazon RDS using Sql Server 2008. I'd like to figure out a way ...
1
vote
2answers
66 views
PG::UndefinedTable: ERROR: relation «productsrules» does not exist
I'm having this issue with one of my PG DB table. I have a table, whose name is "hproducts_rules". This is supposed to have a "belongs_to" relation with the "hproducts_matchs" table.
This is my ...
0
votes
0answers
31 views
hstore on Heroku: can't iterate over hash members
I have an hstore attribute called properties. The following code puts a line break between each attribute before outputting it to the view.
def item_properties_to_string(item)
return nil unless ...
0
votes
0answers
44 views
Rails 4 polymorphic, self-join or ancestry?
I've got a Venue structure to create where you are able to place different types of components under different locations in the same Venue so the structures are like this:
Main Hall -> Conference ...
2
votes
2answers
41 views
Importing CSV into Postgresql with duplicate values that are not duplicate rows
I am using Rails 4 and postgresql database and I have a question about entering in a CSV dataset into the database.
Date Advertiser Name Impressions Clicks CPM CPA CPC CTR
10/21/13 ...
0
votes
0answers
109 views
postgresql gem with ruby 2.0.0-p353 on mac wont suceed
I'm trying to bundle a new rails app using Postgres.
I get this error each time I try to bundle.
Errno::EACCES: Permission denied - /usr/local/var/rbenv/versions/2.0.0- ...
0
votes
0answers
61 views
Rails select NoMethodError in Messages#new
I'm trying to put on a select box the Users who will receive the message.
What we have is one table named Messages, one named Users and one named Friendships, on message table we have user_id (sender) ...
Community Bulletin
Related Tags
ruby-on-rails × 304
ruby × 158
postgresql × 104
ruby-on-rails-3 × 87
activerecord × 73
pg × 62
heroku × 58
ruby-on-rails-4 × 43
rails-activerecord × 28
sql × 21
ruby-on-rails-3.2 × 20
heroku-postgres × 20
rake × 18
postgresql-9.1 × 14
database × 12
hstore × 12
pg-search × 11
mysql × 11
rspec × 11
postgresql-9.2 × 10
rails-migrations × 9
gem × 8
postgis × 6
sqlite × 6
more related tags
Hot Network Questions
- Idiom or word for a very crowded place
- I need a program where the user inputs an array of doubles and the program outputs the array sorted
- Is this of any real importance to the mathematical scientific community?
- Is it appropriate to request letters of recommendation from professors a second time?
- Write a function that tells you which TWO of its lines has been removed
- a small halo symbol
- Did Amazon remove copies of 1984 from Kindles?
- Mathematical research published in the form of poems
- Automate apt-get update and upgrade
- How could disabling 'Hide File Extensions' in Windows make a system more secure?
- Looking for proof of no solution to 4-variable quadratic diophantine equation
- I named a folder the character for space, and now that I've switched over to Windows I need to rename it
- How do I write an adding function?
- Does the shovel do anything?
- Show that a number is not an integer
- Can We Decide Whether Small Computer Programs Halt?
- How construct `print` works?
- Can two PhD students publish without involving their supervisors?
- Is it possible to "cook" pasta at room temperature with low enough pressure?
- Apache2 VirtualHost IfPort?
- Shortest code to print a smiley face
- Password security
- 9 Hole Challenge
- magic and men in lord of the rings
