Robby on Rails

a million mysql users: I’ve never had a problem with it. postgresql users: Yes, that’s why you’re still a mysql user.

When will PostgreSQL evangelists learn that “good enough” is good enough for 99% of web apps (i.e. low- to medium-traffic, simple data, basic CRUD)?

People calling MySQL a “toy” is a counter-productive argument because it seems to imply that, if it works for you, your hard work must amount to a “toy” project.

I prefer Postgres by leaps and bounds, but if MySQL works for you, good for you.

I suppose the real issue here is whether MySQL is your choice because its popular or it fits your functionality level, and whether that matters.

If I need a lightweight database I tend to go towards SQLite. If I need robust features straight away, I gravitate towards Postgres. MySQL can handle either cases though.

I think the larger concern for MySQL users should be the dual license nature. What do you do when you want your product to go public? Do you need to buy a license. Currently not, when its a database backing a client server application but what if Sun changes their mind? Do you think your small start up, university, or non profit has the legal staff to challenge Sun’s? This is what scares me away from MySQL. With the availability of Postgres, I have a robust alternative that in many capacities meets or exceeds the functionality of MySQL, without the license issue.

MySQL is a thin veneer above a set of decent technologies. Sleepycat (berkeley db) and Innodb were actually written by people that did know what they were doing. When MySQL tried to implement ACID, they simply couldn’t do it, they’re were a bunch of script kiddies that have risen off the backs of a talented few.

Anyhow Innodb and Sleepycat are now owned by Oracle. Whereas the MySQL ‘brand’ and it’s veneer (some installers and an SQL parser) were bought by Sun for US$1Bn. Smell something wrong here? I certainly no longer own any shares in Sun.

I still don’t understand, why use a system that is guaranteed to fail in such a way as to cause you hard to trace support issues? Job for life? Are you those types of people that just patch things up by hacking the database, think no more of it and go to fix the next error on some other system sitting on top of MySQL? If ‘good enough’ is the benchmark by which you develop software, go ahead and use MySQL, otherwise use a proper database.

I also appreciate postresql, but in fact mysql has many users.

Hi,

I have switched my Rails app from MySQL to PostgreSQL because of the license, and because Postgre has many features which I don’t use yet, and which will keep me busy on rainy weekends.

With my very own mediocre benchmarks, I tend to see that Postgre is slightly faster than MySQL.

My take on it:

Despite superior performance, licensing, and features, PostgreSQL is just a very awkward name for software. I bet it if was called “Moo” or something like that it would be adopted very quickly by the Rails and open-source community.

How exactly do you say “PostgreSQL”? It looks like gibberish.

Umm, you say post-gres-Q-L, thought everyone knew that. I believe there’s still debate going on about whether the name should be changed, but seriously, that’s such a silly point to make compared to everything else.

At our self-training video on demand website we are happily using PostgreSQL with our Rails 2.2.2 application. However using the correct Ruby gem for PostgreSQL can be tricky, here is the correct command to type: sudo gem install pg

We pronounce “post-gre-S-Q-L”.

I’m switching from mysql to postgresql in part due to to the licensing and ownership mess, the botched “release” of 5.1, and due to the influence of the Enterprise Rails book by Dan Chak, which could be one of the best Rails/Postgres resources out there. I also don’t like the arguments between sun’s marketing and monty widenus. It’s totally unprofessional

By licensing mess, I mean the dual gpl/commercial license, and by ownership I don’t lie the fact Oracle owns InnoDB. Also, I think MySql stores database metadata in myisam tables, which is bad

China Supplier Fiancing Modern Bar Design China Sourcing LED Pour Bar Stool Merchant Cash Advance Merchant Accounts

Definitely agree with what you stated. Your explanation was certainly the easiest to understand. I tell you, I usually get irked when folks discuss issues that they plainly do not know about. You managed to hit the nail right on the head and explained out everything without complication. Maybe, people can take a signal. Will likely be back to get more. Gucci Sunglasses

Definitely agree with what you stated. Your explanation was certainly the easiest to understand. I tell you, I usually get irked when folks discuss issues that they plainly do not know about. You managed to hit the nail right on the head and explained out everything without complication. Maybe, people can take a signal. Will likely be back to get more.

While this subject can be very touchy for most people, my opinion is that there has to be a middle or common ground that we all can find. I do appreciate that youve added relevant and intelligent commentary here though. Thank you!

Thank you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information.

Having a tool to allow others at PA to see what is in my queue and in some cases, respond on my behalf… has been needed

Thank you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information. Limousine Service New York

Very well written article indeed, it really helps me with my programming skills, thank you so much for sharing such information with us, i hope we will see more from author in the future. Postcard Printing

I am happy to find this post very useful for me, as it contains lot of information. I always prefer to read the quality content and this thing I found in you post. Thanks for sharing

it is interesting,god bless you!

FTYTRY

RTERTERT

Valuable information and excellent design you got here! I would like to thank you for sharing your thoughts and time into the stuff you post!! Thumbs up

I hardly ever write comments on blogs, but your article urged me to praise your blog. Thanks for the read, I will surely favorite your site and check in occasionally. Cheers.

What a excellent blog entry, Thanks for sharing it with me. Have a Great day!

I’ve surfed the net more than three hours today, however, I haven’t found such useful information. Thanks a lot, it is really useful to me.

You got a really useful blog I have been here reading for about an hour. I am a newbie and your success is very much an inspiration for me.

Nicely presented information in this post, I prefer to read this kind of stuff. The quality of content is fine and the conclusion is good. Thanks for the post.

tr y

rty rt rt y

rty rt rt y

Anyhow Innodb and Sleepycat are now owned by Oracle. Whereas the MySQL ‘brand’ and it’s veneer (some installers and an SQL parser) were bought by Sun for US$1Bn. Smell something wrong here? I certainly no longer own any shares in Sun.

ert er

I want to thank you from the core of my heart for doing such a research. Just now I completed reading your post and also find the tips to be useful. I will surely try to keep all those points in mind. I like shopping Air jordan shoes |

try

england 7 beckham white jersey

web hosting hosting services webhosting unlimited web hosting dedicated server hosting

nice post. Seo Services Seo expert search marketing pay per click web designer

gret

The haversack of a Louis vuitton bags . As for louis vuitton handbags , the designers accept their own cast value, even for their lv . louis vuitton is so abiding and accept able ability for water-proof and fire-proof.

Coach handbags have been one of the most popular items for a woman to shop for but at a great price and this is where Coach Poppy fits the bill. There are also many Coach Madison stores around the country. You want to search online to see if there is a Coach Luggage store there.

Visit the Breitling page on our website for information on the products. The Breitling Windrider are made with the essence of perfection. A catalogue of the Bentley 6.75 will give you a wide range of watches to select from in models. Bentley Motors has four popular styles of watches available in the market.

For me PostgreSQL is the best as it is one of the largest and most mature open source projects today.

PostgreSQL is great to work on as it maintains over a dozen mailing lists, as well as several user groups, an active IRC community, and international sites in multiple languages.

Your article on Ruby is very informative and fun. I enjoyed it a lot and yes Torres is the best striker in the world.

PostgreSQL is loaded with features that makes it a mature world class database including: full ACID compliance and relational integrity, MVCC, XML support and the list goes on..

Installing XCODE is a necessity if you want to have developer friendly tools installed in your system.

This article has great reference value, thank you very much for sharing, I would like to reproduced your article, so that more people would see it.

bronx dentists

If you really think about it everything that can go on the web is a toy. It’s how you use, play and fix the toy to your needs.

Great article. It is actually benefit to learn your web. The information from your site is exactly excellent, and your blog template is Simple generous. It seems never dazzled. So great.

I have been reading your posts regularly. I need to say that you are doing a fantastic job. Please keep up the great work.

This is a really good post. Must admit that you are amongst the best bloggers I have read. Thanks for posting this informative article.

since this article is from 2005 i was wondering what the status is today regarding PL/Ruby in postgreSQL? did you continue working with PL/Ruby? what is the performance when using external rubygems such as redcloth?

Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your posts. Any way I’ll be subscribing to your feed and I hope you post again soon..

That article is so interesting and makes a very nice image in my mind. That is very much helpful in nominating the board of directors.

MYSQL is great if you want a lightweight database, or even if you need robust features straight away.

I would like to thank you for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own BlogEngine blog now.

Rcmods provides you finest radio and remote control helicopters and guides for purchaser RC helicopter and chargers, battery and their almost accessories and upgrades, Electric helicopters that anyone can fly them easily.

supra trinity ns white patent shoes, supra trinity ns white patent shoes

go to the shopping

thank you

nterpriseDB want’s to hear your stor

SEO Software service offer good seo company india,seo services india, php development india, web development india, link building india, seo solution india, seo agency inda, internet marketing india at affordable price http://www.seosoftwareservices.com/web_development.html http://www.seosoftwareservices.com/seo_packages.html

Air Jordan 14,Air Jordan 14
air flight condor high black,air flight condor high black
discount Nike Air jordan Fusion 17.5,discount Nike Air jordan Fusion 17.5
discount Nike Air jordan Fusion 14,discount Nike Air jordan Fusion 14
discount aj11 nike SHARKLEY,discount aj11 nike SHARKLEY
Air Jordan Fusion 5,Air Jordan Fusion 5
Air Jordan Fusion 3,Air Jordan Fusion 3

SEO India PHP Development India link building india SEO Services India SEO Company India

Dear Sir

this post is very usefull thanks for sharing the good informaion…....................

Other belt gucci Expenses: $1,311 Total Annual Cost: $35,374 *Provided emporio armani belts by SayStudent.com and based on cartier ballpoint pen data from the 2007 College fake tiffany and co jewelry Board Trends in Higher Education