similar to: Date formats

I''m in the process of upgrading my existing Rails 2.3.8 app to Rails 3.0.3. One problem that I have encountered is how to make rails 3 read/write date/time data into the DB in localtime. In Rails 2.3.8, commenting out the ActiveRecord timezone settings did the trick, however in Rails 3, that doesn''t work as the default is now UTC. I have tried setting the config.time_zone to

I need advice about What is the best practice to scale RoR project ? My current stack is: - Ruby 1.9.3 - RoR 3.2.8 - Redis DB for caching and some hot data - PostgreSQL - Resque for background jobs I am expecting a highload for my project for several month. And I need to change my architecture. Primarily, I want to change my backend architecture. I read about highload

Here is the following from my console: >> Time.now => Mon Sep 22 11:33:34 +0200 2008 >> Time.now.utc_offset => 7200 >> TimeZone[Time.now.utc_offset] => #<TimeZone:0x11aea90 @tzinfo=nil, @utc_offset=7200, @name="Athens"> >> Time.now.in_time_zone(TimeZone[Time.now.utc_offset]) => Mon, 22 Sep 2008 12:34:22 EEST +03:00 (I am in Spain - CET - and

Rails 2.3.2, Ruby 1.9.3 I want to get all records for one month from charges table. recs = Charge.where(["date >= ? and date < ?", t.beginning_of_month, t.next_month.beginning_of_month]) and this transforms into this query on PostgreSQL SELECT "charges".* FROM "charges" WHERE (date >= ''2012-03-31 22:00:00.000000'' and date <

gem install pg give the following error, please help how can i solve this Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native extension. /home/saravanan/.rvm/rubies/ruby-1.9.3-p194/bin/ruby extconf.rb checking for pg_config... yes Using config values from /usr/bin/pg_config checking for libpq-fe.h... yes checking for

Hello everyone, I am using rails 3.2.8. I want to change time zone to New York time. I changed following, but didn''t work #config/application.rb config.time_zone = ''Eastern Time (US & Canada)'' config.active_record.default_timezone = ''Eastern Time (US & Canada)'' If am wrong please clarify. Thank You! -- You received this message

Friends, So there I was, minding my own business, trying to make my rails app timezone aware (DST, as well), since it''s all about the timing with this one. There are a number of excellent articles that I''ve been working off of, in particular this one internet archived version of Scott Barron''s very useful article on the subject that is no longer available at the

Hello, I am running into a little issue. There is a considerable time difference between the time that the console is giving me and the time I am seeing in the created_at and updated_at column in the DB. The difference is about 5 hours. I don''t think the problem is in the DB, but I could be wrong. Am I missing something obvious? Any clues? -- You received this message because you are

Hi! I have a table with visits with a visited_at: attribute which is a datetime field. They seem to be stored as UTC. Now I want to count all visits each day and return something like: { 2013-01-01: 8, 2013-01-02: 4, 2013-01-07: 9, ... } So, I did it like this which kind of works...: def self.total_grouped_by_day(start_date, end_date) visits = where(visited_at:

I get these errors : gem install pg -- --with-pgsql-include-dir=''/usr/include/pgsql'' -- with-pgsql-lib-dir=''/usr/lib/pgsql'' Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native extension. /usr/bin/ruby extconf.rb --with-pgsql-include-dir=/usr/include/pgsql -- with-pgsql-lib-dir=/usr/lib/pgsql

Hello, Using rails 2.3.9 and ruby 1.8.7 I am trying add time zone in the site according to user''s time zone (selected by the user from the drop down of time zones)Code is done as follows, but time zone is not getting saved in the database. IN Application Controller before_filter :set_time_zone def set_time_zone Time.zone = current_user.time_zone if current_user end IN View

When i try it start my ruby server i get a error that looks like rails server Could not find pg-0.12.2 in any of the sources Run `bundle install` to install missing gems. I dont know what to do Thanks for all the help -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this

I''ve got a javascript that provides me with the timezone for the client. I want to use this to set Time.zone so that all my times stored in the database are displayed in the timezone for the client. So really simplistically var timezone = jstz.determine_timezone().timezone Time.zone = timezone.olson_tz obviously this can''t be done. I''ve taken a look on the web and can

I sent this earlier but I don''t think it ever came through. Sorry if this is a reposting. When using :priority_zones for time_zone_select in a manner described by the API docs for ActionView::Helpers::FormOptionsHelper I''m getting errors. Here is an API docs example: time_zone_select( "user", ''time_zone'', TimeZone.us_zones, :default =>

please help me in this... I am unable to install pg gem file [root@vdimc04 ~]# gem install pg -v ''0.12.0'' /usr/local/lib/ruby/1.9.1/yaml.rb:56:in `<top (required)>'': It seems your ruby installation is missing psych (for YAML output). To eliminate this warning, please install libyaml and reinstall your ruby. Fetching: rake-compiler-0.8.1.gem (100%) Fetching:

On Thu, Sep 3, 2015 at 6:45 PM, Kostya Serebryany <kcc at google.com> wrote: > Did you build the Postgres code with -fsanitize-coverage=... ? Yes: CC = clang CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -g -O0 -fsanitize=address

Does anyone know the best way to track time zone information. There doesn''t seem to be much documentation on this. So far it seems like a simple db field like create table accounts ( id int unsigned not null auto_increment, name varchar(50) not null, time_zone varchar(50) not null, ... primary key (id) ) and a class like class Account < AR ...

Hi all, I installed Rails 3.0 + PostgreSQL 8.4. Installed the gem postgre-pr I added " gem ''postgres-pr'' " to my Gemfile I defined my database.yml with: # PostgreSQL 8.4 development: adapter: postgresql encoding: unicode database: testdb pool: 5 username: test password: ****** I run rails server which starts, but application environment returns this error:

I want to store, retrieve and handle all times inside my app in just one Timezone. => "New Delhi" for that I''ve set in my application.rb file, config.time_zone = "New Delhi" When i create a record like Event.create(:when => DateTime.new(2011, 5, 7, 16, 0, 0)) it creates an event record in my mysql db (local) with "when" field as "2011-05-07

Hello All, I am using JRuby in Linux Ubuntu 10.10. In Rubymine IDE, I am getting as "Install Missing Gems" link. After clicking on that link, I am getting this error :- Installing pg (0.14.1) with native extensions Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension. checking for pg_config... yes Using config values from /usr/bin/pg_config