similar to: postgresql ruby rails connector ?

How do I best migrate the data? For small databases I can text-edit the dump file from MySQL. The postgresql compatibility switch doesn''t help on mysqldump. Any ideas. Can MySQL export CSV that postgresql can import ? W Fred -------------- next part -------------- An HTML attachment was scrubbed... URL:

I have a weird problem with creating a new record when using PostgreSQL. From inside script/console ... >> entity = Entity.new >> entity.first_name = "Foo" >> entity.last_name = "bar" >> entity.save Throws an exception due to the following SQL error: duplicate key violates unique constraint. The application was working fine before and suddenly

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

Hey, all! I''m having a url problem that seems like I''m going to overcomplicate it if I don''t just ask what I''m doing wrong... My situation is that I''m testing to see if a visitor is accessing a controller via SSL, and if not, redirect to the same controller via my secure address. This really only amounts to replacing http with https, and so I did the

I have many "edit" actions in my project. If the url is like http://localhost/project/3/edit and someone enters http://localhost/project/3333333/edit the edit action will fails because it cannot find a project with id of 3333333. To combat this I am adding to every action like edit: rescue redirect_to :action => ''index'' flash[''errors''] =

Hiall, If I have say 10 tables that i would like to wrap up in 1 view to manipulate data inside these tables, do I then need 10 model.rb files for all 10 tables plus 1 for the view, or do I just need 1 model.rb file for the view ? cheers Martin

Hey all, I am curious about how Rails interacts with SCHEMAs in PostgreSQL. From the generate command, is it possible to setup a scaffold for a table not in the public. schema in PostgreSQL? As a test, I tried, ./script/generate scaffold Manage.Form Manage.Form No dice. Any suggestions? -Robby -- /*************************************** * Robby Russell | Owner.Developer.Geek * PLANET ARGON

Hi, In Debian/testing (mysql-5.0.20, ruby1.8, rails 1.1.0) Im trying to follow up the fourdaysonrails tutorial, and when putting: validates_uniqueness_of :category, :message => "Already exists" in /myapplication/app/model/category.rb I get: NoMethodError in Categories#create undefined method `category'' for #<Article:0x407f6418> RAILS_ROOT:

I can''t decide between a2hosting.com, successfulhosting.com, site5.com (which offers 11gb of disk space for $8.77/month -- I''ll never use it), planetargon.com (which offers 1 gb for $11/month), or railsplayground.com (which offers a gigabyte practically for free). Any experiences you''d like to share? Only a2 and planetargon list their gems on their web sites. All of

I''ve been working with rails for a while now. Rails is the second web framework I''ve tried. It blows the doors off catalyst (perl''s best framework). I even just wrote my first plugin (broomstick). Ruby''s ability to meta-program blew me away with it''s ease of use. I''ve been so impressed with the helpers that rails uses to make a lot of

I thought I understood how to grab the session id but in the following code I am getting null for the session id: @foo = Foo.new(:session_id => session[:session_id], :test_id => @test.id) -- Posted via http://www.ruby-forum.com/.

As I, like many people, are coming to ruby in the rails era, I''m curious about how Ruby Web Dev was done prior to rails. Any veterans want to share their insights? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060518/20cde24d/attachment.html

Is there a functiaon to take the IP address of person who submits to a form example: <input id="user_ip" name="user[ip]" type="hidden" value="<%= some_ip_call %>" /> -- Posted via http://www.ruby-forum.com/.

Hello. Where is there an Agile Messageboard? On the first part of the Depot example, a price field shouldn''t be an integer right? (it should be more of a float since a price has decimals) Dominic Son -- Posted via http://www.ruby-forum.com/.

Hi, I''m not sure if this is a postgres issue or not, but I''m using Postgres 8.1. I have (in my functional tests) the following code: upload = fixture_file_upload(''/files/podcast.mp3'', ''audio/mpeg'') post :create, :product => valid_product, :media => { :image => upload } And then in the controller: blob = Blob.create :data

I''ve been reading the RoR tutorials and wiki help stuff, but I''m stuck. :( I''ve got RoR installed properly and get the "Welcome aboard! You''re riding the rails." I have an "article" controller, "article" model, and both an "article" and "articles" views (one is a remnant, I think, and no longer needed) (the

with this post; with a query with multiple tables, I am trying to return results that are null in one table; I am trying to do something like this; class NumbersFeedLink < ActiveRecord::Base has_many :numbers_sent_feed_link end class NumbersSentFeedLink < ActiveRecord::Base belongs_to :numbers_feed_link end sent = NumbersFeedLink.find(:all, :order => [

It seems like half the people on this list are writing a book on Ruby or Rails. For all the hints I''ve seen strewn across the list I have yet to see one that will focus on test-driven development for either Ruby or for Rails. If anyone is looking for a topic, please consider this. I''ve been trying to wrap my brain around the TDD process, but its way of thinking is

Remember James McGovern and his articles about Rails and enterprise? Well... Check this one out where he "puts his money where his mouth is" http://duckdown.blogspot.com/2006/04/ruby-community-proved-mcgovern-wrong.html -- -------------- Jon Gretar Borgthorsson http://www.jongretar.net/

Did a quick search, but didn''t come up with anything definitive. So what does everyone think is the best low maintenance and most hassle free way to go for deployment? Is lighttpd still everyone''s choice? I remember seeing one that was a pre-packaged environment with apache I think. Anyway, just about to deploy an app and thought I''d ask suggestions - want to see