similar to: Postgresql vs MySQL

I am going to start a project from scratch with MySQL. Is it a good idea to go ahead with MySQL 5? Is there any gotcha with that version as of today? -- fxn "We all agree on the necessity of compromise. We just can''t agree on when it''s necessary to compromise." -- Larry Wall in comp.lang.perl

Can I get some opinions on which free DB to use with rails for a virtual server that will eventually be doing lots of heavy database lifting? Not a lot of heavy duty querying per se. Think multiple simultaneous forums and blog sites and the like. I know each of the different DB possibilities such as MySQL and PostgreSQL has plus points and minus points. I''m particularly interested

After months of design and development, we''ve launched our second Rails site, http://www.fatwreck.com (assuming your DNS is updated - the pink site is the old one). The site is for legendary punk rock record label, Fat Wreck Chords and it includes a store. The old site was highly trafficked, with millions of page views per month and we expect this one to be also. So far, the server

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

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''m coming from an Oracle and SQL Server background. I''d like to use OpenSource for my next RoR project. MySQL5.x and Postgres8.1 seem to be the most popular. I''d like some comments on which would be the better choice for a production environment and why. Here are my initial concerns in order of priority: 1. Works well with RoR. ( migrations, etc) 2. Stable enough

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, 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

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

Every page of my DEPOT on Postgresql rails app now gets an error from postgres-pr about some wild left-join SQL that has nothing to do with my tables: SQL (0.000000) NameError: undefined local variable or method `errors'' for #<PostgresPR::Connection:0x3b200c0>: SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN

Is there a place I can get a list of "enterprise" Rails applications? Apparently, even though I''ve looked at the wiki and cited the examples there, there are some at my organization who still can''t find proof that Rails is usable in an enterprise setting. Would you fine folks be able to tell me about some large-scale projects that could be classified as

Here''s an alternative in-depth treatment on setting upo rails on Debian (Ubuntu, Kubuntu, ... ), may be interesting to follow through in more detail for some: The Perfect Rails/debian/lighttpd Stack... ( http://brainspl.at/pages/perfect_vps ) Victor Kane http://awebfactory.com.ar On 3/25/06, rails-request@lists.rubyonrails.org < rails-request@lists.rubyonrails.org> wrote: >

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

Reviews Wanted. I''ve read the tables of contents and haven''t yet made up my mind. Is one book clearly better than the other? Is one clearly full of bugs? Is one so much further ahead that there is no choice? Are they both so incomplete that I should just wait and only cook real food? Do trains still have dining cars? Warren Fred -------------- next part -------------- An

Not that I have your attention! :P I''ve been having a discussion with a respected colleague here: http://phpbuilder.com/board/showthread.php?t=10340411 (Rails vs. PHP) He''s basically saying that Rails won''t be able to scale because referential integrity and tranactions are done in the application rather than the database. Please read the referenced thread for much more

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

OK ... there has been an awful lot of attributing problems to the 4.4 upgrade that are not really upgrade problems. The best I can tell there is really only one major problem: 1. You need to install python-sqlite before sqlite (or at nearly the same time). To accomplish this you can do this: yum update python-sqlite sqlite Then after that, a normal yum update works fine. There are 2 other

The agile book says "You can inspect variables, set values, add other breakpoints, and generally have a good time". This is very sweet and totally useless. For example, I want to see the session variable, the cookies variable and so on. These names are unknown. I think I guess that the things that are available depend on where you put the breakpoint() call. I''ve tried a

Hi, I''m new to Ruby on Rails and am having a little difficulty working through the ''Rolling with Ruby on Rails'' tutorial. Can anyone help? I''m trying to get the cookbook application to work via a Postgresql db. But get the following error when trying to access http://127.0.0.1:3000/recipe/new Errno::EINVAL in RecipeController#new Invalid argument

I need to insert ~100k rows into the database, but using "Table.new(...).save" is painfully slow (I notice in the logs that it''s wrapping each insert in a transaction -- that can''t be fast). Any suggestions on how I can improve the speed of bulk inserts like this? Thanks ... -- Steve