similar to: large file storing in postgres sucks?

Hi, Anyone got any cool tricks for converting a Rails site (in this case, a typo installation) from a mysql database to a postgresql database? I''ve got it almost working -- I''m doing a SQL dump from mysql and loading it into postgres. However, mysql does booleans as a tinyint with 0 = false and 1 = true. When I try to import that into a postgres database that expects booleans

What are the practical differences between using postgres and postgres-pr to connect rails to a postgres database? I realize the -pr version is pure ruby, while the other is a set of c bindings, but, does that result in performance, reliability, or feature differences? Any information appreciated. Colin Freas -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi, I have been using myisam tables in mysql with rails because my client will soon want fulltext searchable content, however when I migrated my development db from schema.rb all of the tables generated were innodb. I understand that I can override this, but also like the transactions and foreign keys of innodb. So 2 questions really: 1. are transactions in activerecord dependent on innodb or do

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

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

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

Hi all, I''ve been offered a short-term contract here in the North of England - around 3 months work, but with RoR I think it will take considerably less time - and am just curious what market rates were right now. I''ve been offered a little under ?1k/week which seems ''right'' for a PHP coder doing this kind of work, but should I be hitting for more, or is

Is ruby on rails supports aspell spell check ? Is there any links for spell check for rails application ? All links I gone through are discussing about php but not ruby on rails? Plzzzzzzzzzz give me reply .... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this

Hello all I am wondering how rails handles case sensitivity in databases. If I do a Person.find_all_by_name("tim") in mysql I would expect to get tim, TIm, and Tim. Do I only get tim in postgres? How do other people deal with this? Do you resort to find_by_sql for all your postgres queries to get case insensitive results?

Where is the best place to solicit bids on a mid-size web app? (budget ~$15,000) What is the appropriate protocol for posting RoR RFPs? Thanks! Taylor -- Posted via http://www.ruby-forum.com/.

Hi all, I''m trying to run a Story Runner integration test that uploads a file through Attachment-fu. I''ve tried various ways of specifying the file data, from custom mocks: class MockFile < Struct.new (:original_filename, :read, :content_type); end fdata = MockFile.new "test_upload.txt", "Test Upload", "text/plain" to

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''] =

Which postgresql gem or library are people using on windowsxp for rails? And what do I put in the yaml file? Warren -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060427/e68daff3/attachment.html

Hi there I''m considering Rails for a new web-application planned to be built from scratch. The application has an extensive web front, and in fact most of the application is interfaced through that front and engaged through clients'' HTTP requests (i.e. the conventional way web-applications and "dynamic web-sites" work). However, some essential parts are supposed to

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

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

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, using --- (3 dashes) at the end of a string that is textilized, results in a single hr tag without any text. This seems weird to me. Am I overlooking something? >> av = ActionView::Base.new >> av.textilize("sometext ---") => "<hr />" Cheers, Jan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are

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

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: