similar to: OT: good admin gui postgresql on OSX?

Hi, Some controller filters: before_filter :require_logged_in, :only => [:create, :new, :confirm] before_filter :init_players, :only => [:create, :new, :confirm] The first one, you guessed it, redirects a user if he''s not logged in. Now when I hit this page and I''m not logged in, the 2nd filter gets executed and throws an error, because it depends on the user

Is there any reason to avoid using postgresql for small web apps? That is, is it''s overhead so large that the lighter MySQL will work substantially better for small apps on small machines? Or are they very similar in performance and configuration? I''ve used MySQL but postgresql has its appeals and I''m wondering if I need to keep MySQL around at all. On the other

I just installed on my up to date FreeBSD 5.4 box. I'm a little confused as to whether or not there are things I need to configure or not. I went to go through the docs, and it was talking about using a file named "config" as a template, and modifying from there. Well that file didn't exist anywhere on my machine, or in the source I downloaded. In fact, looking in the Wine CVS

Hi all! I am quite new to rails, and I would like to know if there is a tutorial, or if someone can tell me how to use rails with stored procedures and views. Any help would be appreciated. Thanks to all -- ------------------------------------------- Gioachino Bartolotta

I've been fighting to get the latest source of pgadmin compiled on Centos 5 64-bit. I obtained gnu-c++ (so it was happy with g++). It then complained about wxWidgets, so I obtained the source for that, compiled and installed, and ./configure for pgadmin saw wxWidgets and was happy with that. Go to make... It complains that some header file is missing. A google search reveals limited

I''m getting errors whenever the user chooses, for example, April 31st ( since there is no 31st in April, navicat freaks out ), there MUST be a method that ruby has that would allow me to validate a date before I submit to navicat. I haven''t been able to find anything online about it either, it''s probably something simple, I just can''t figure it out. Thanks

I'm use RPostgreSQL to access data on a Postgres server. I would like to keep my SQL statements in external files, as they're easier to write and debug in pgAdmin, then I use readLines to bring them into R and feed to dbGetQuery. Here's the problem. When I create a SQL script with pgAdmin, then load it in R, the ensuing script fails when I feed it to dbGetQuery. When I inspect the

G''day everyone, I''ve got Rails up and running, but am having trouble finding a stable MySQL client for OSX. I was looking at the ''Creating a weblog in 15 minutes'' screencast from rubyonrails.org - what MySQL client is David using? I''ve found the MySQL clients (Administrator / Query Browser) to be highly unstable and rather pathetic under OSX. If

Hi, I just moved from 1.08 to 1.10 and now have one example failing, which, under 1.08, passed. Is the due to a change in behaviour? Here''s my spec (removed some passing examples) require File.dirname(__FILE__) + ''/../spec_helper'' describe "A user" do before(:each) do @user = User.new @valid_user = User.new( :email =>

Hi, I''m looking to create a ruby script that loads a bunch of records and manipulates these. Where do I start? I got this to begin with: #!/usr/bin/env ruby require File.dirname(__FILE__) + ''/../config/boot'' players = Player.find :all But it complains about a DB connection. How do I set this up? Jeroen

To Whom It May Concern: I have an ActiveRecord-based application (non-Rails). Life was grand until I upgraded ActiveRecord yesterday, after which point I was getting TONNES of these errors from my app and in PostgreSQL''s logs: FATAL: terminating connection due to administrator command According to Google searching, this happens when an external process sends PostgreSQL SIGINT or

Hi, Just thought it was weird that Ruby doesn''t automatically cast ints to floats. Seems so un-rubyish irb(main):006:0> 12/16 => 0 irb(main):007:0> 12.to_f / 16.to_f => 0.75 Jeroen

Hi, Is there an easy way of querying an active record for a maximum column value? I need to do queries like: SELECT MAX(salary) FROM employees TIA, Jeroen

Hi, Whenever I restart mongrel on my production server, the first request in my browser always fails, I get this error: Processing Base#index (for 83.xx.xx.xx at 2006-09-03 16:08:47) [GET] Session ID: f1918346d193e19a70c3230286e5ce1a Parameters: {} TypeError (superclass mismatch for class Stats): /app/models/stats.rb:1 stats.rb:1 just contains a normal A/R line: class Stats <

A couple of questions please: What is the benefit of having more than one Mongrel/Rails instance on the same machine, could one instance not serve as many requests as say three instances? Is Mongrel Cluster a Apache add-in (like mod_*) or a separately running load balancer which runs on a separate port, I could not work it out from the sample Apache config... |# Redirect all non-static

Hi, Are there any recommendations as to what is currently the most stable setup is for mongrel & apache? I read somewhere (probably here) that you should avoid using PStore for sessions. Are there any more of such recommendations? Also, what is currently the safest version of mongrel to use in production? Jeroen

Hi, I wrote a little helper that calulates someone''s age based on his/her date of birth. def age(dob) diff = Date.today - dob age = (diff / 365.25).floor age.to_s end It works fine, but it''s not completely accurate as it just takes the average days in a year. It should be able to calculate this more accurately, right? I can''t work it out

Hi, Is there a way to test if a certain (local) variable has been initialized? I''d like to do something like if isset(myvar) and myvar.true? #some code else #default behaviour end I have a lot of shared views that I call with params such as { show_pager => true Instead of having to explicitly say show_pager => false it should be possible to make false a default value, right?

Hi, Disclaimer: I''m pretty sure this isn''t a mongrel issue, as I''m pretty sure I had the same problem back in the lighty-fastcgi days.. After a postgres restart, my rails apps crash with this error: ActiveRecord::StatementInvalid (PGError: FATAL: terminating connection due to a dministrator command server closed the connection unexpectedly This probably

Hi, I''m trying to include a partial in an email template but it throws me this: undefined method `controller_path'' for SupportMailer:Class Extracted source (around line #12): 11: 12: <%= render :partial => ''footer'' %> I guess email views are a little different from normal ones as they don''t seem to have a access to a proper controller (?)