Tagged Questions

2
votes
0answers
28 views

Cancel Rails DB connection

I am writing an app that uses Server Side events with ActionController::Live. It is using the puma app server. A method in the Messages controller stays alive while the user is connected waiting for ...
1
vote
0answers
36 views
+50

Rails/Postgres query rows grouped by day with time zone

I'm trying to display a count of impressions per day for the last 30 days in the specific users time zone. The trouble is that depending on the time zone, the counts are not always the same, and I'm ...
1
vote
0answers
40 views

Calling PL/pgSQL Stored Procedures from Ruby on Rails

I am working on a project where I am the database designer/admin in a PostgreSQL environment. The leader has decided to use Rails for the application logic and recruited a Rails programmer. The Rails ...
0
votes
0answers
17 views

Using a database for CKEditor uploads

How can I use a CKEditor field in a Rails app and have image uploads stored in a PostgreSQL database table rather than a file system? I am finding the rails-ckeditor documentation and many CKEditor ...
0
votes
0answers
38 views

update query not updating in postgresql

Not updating postgresql database when update_all using @change_stat = Notification.where("fb_id = ? AND active = ?",@current_user.fb_id,true) @change_stat.update_all(:active => false)
0
votes
0answers
18 views

Heroku Deployment : Discourse Assets precompile

Hi I'm actually trying to deploy discourse on Heroku. I'm following the step by step guide here Basic Heroku deployment I'm facing a problem when I try to rake assets:precompile (I'm precompiling ...
0
votes
0answers
21 views

Timestamp breaks sqlite3 import to postgresql

I have a rails app that I used Sqlite3 for the db, but am now switching to use Postgresql. Per this excellent post, I have set up the postgresql databases, and am now importing the sqlite3 db's to ...
0
votes
0answers
24 views

Heroku + Rails 3.2 + PostgreSQL = NoMethodError: undefined method `result' for #<NoMethodError:..>

NoMethodError: undefined method `result' for #< NoMethodError: ...> Stack trace refers to this place: def current_income return @current_income if defined? @current_income if ...
0
votes
0answers
12 views

rake db:setup not work with Postgres and Postgis ERROR: could not access file “$libdir/postgis-1.5”: No such file

In Ubuntu, i try to run rake db:setup to install a Rails application, but i have several times this message ERROR: could not access file “$libdir/postgis-1.5”: No such file Finding in the files, i ...
0
votes
0answers
17 views

Rails postgis adapter makes lot of queries in table “geometry_columns”

I'd like to optimize my Rails 3.2.13 application that's currently using postgis through activerecord-postgis-adapter gem. The problem is that when I make a query in a table, even if there are only ...
0
votes
0answers
11 views

How to search tags by act_as_taggable_on with pg_search in Rails + Postgresql?

I'm trying to set up a search form that allows users to search for objects based on their name or any associated tags that were created with the acts_as_taggable_on gem. I think I found a piece of the ...
0
votes
0answers
46 views

Bulk data load to Heroku Postgres from flat files

UPDATE AT THE BOTTOM I have large amounts of data to load to an Heroku Rails app. Flat files are supplied by the user, and the plan is to upload them to S3, copy to Heroku ephemeral storage, and ...
0
votes
0answers
21 views

rails s error libpq.so.5: wrong ELF class: ELFCLASS64

I am getting the subject error. It seems the error has something to do with the postgres libraries not being 64 bit, but other than that I can't figure it out. Bundle install runs alright, but when I ...
0
votes
0answers
36 views

Rails + Postgresql to_json order isue

Hi Im exporting json to a file with rails, however I can't get the order to be right. I user this code but it produces json with the opposite order. class TojsonWorker < ApplicationController ...
-1
votes
0answers
33 views

Rails Movies Database API

I am currently creating a Rails Movie app, there is a Movies controller with obviously models and views etc.. So that my app can be the app i need it to be, I will need my database to have a ...

1 2 3 4
15 30 50 per page