Re: [Rails] Re: Different DataBases Used in ROR

2012-09-14 Thread Peter Hickman
Oracle is closed source, if something goes wrong you cannot look at the source and fix it yourself or submit a detailed bug request. Not everyone does this but it is an important point for some people. It also costs a lot of money. Starting with the low end processor license Standard Edition One

Re: [Rails] Re: Different DataBases Used in ROR

2012-09-14 Thread keerthi priya
@pasha what does this lines mean" you'll have no chance to even look at the code. " On Thu, Sep 13, 2012 at 2:35 PM, Pasha Muravyev wrote: > I'd suggest postgresql, for the sole reason that postgresql supports > transactional migrations, which saves so many headaches and possibly > undoing corru

Re: [Rails] Re: Different DataBases Used in ROR

2012-09-13 Thread Pasha Muravyev
I'd suggest postgresql, for the sole reason that postgresql supports transactional migrations, which saves so many headaches and possibly undoing corrupted database schemas (in the future). It's also open source as opposed to Oracle - if you get stuck with a problem on the latter, you might be trea

Re: [Rails] Re: Different DataBases Used in ROR

2012-09-13 Thread Fabian Becker
It all depends on what you need. There is no "use this DB for huge applications". Definitely don't use SQLite in production as it doesn't scale. MySQL - can scale well if used correctly and was used by Twitter for a long time PostgreSQL - is currently on the rise and a lot of gems start to support

Re: [Rails] Re: Different DataBases Used in ROR

2012-09-13 Thread Kashif Umair Liaqat
Google is the best option for this purpose. All the databases have a lot of pros and cons which cannot be covered here. You can google for pros and cons of every database. On Thursday, September 13, 2012 5:28:46 PM UTC+5, keerthi priya wrote: > > Can i get a brief explanation on Do's and Don’t f

Re: [Rails] Re: Different DataBases Used in ROR

2012-09-13 Thread keerthi priya
Can i get a brief explanation on Do's and Don’t for the each DB in my list . i mean any link where i can get all those informations. On Thu, Sep 13, 2012 at 1:47 PM, Kashif Umair Liaqat wrote: > Rajesh, I have heard that MongoDB have many limitations. Many of the > servers don't support it. Also

[Rails] Re: Different DataBases Used in ROR

2012-09-13 Thread Kashif Umair Liaqat
Rajesh, I have heard that MongoDB have many limitations. Many of the servers don't support it. Also many of the gems don't have support for it as well. Most gems support sqlite or mysql. On Thursday, September 13, 2012 1:01:29 PM UTC+5, Rajesh reddy wrote: > > Hi Keerthi, > > We have been de

[Rails] Re: Different DataBases Used in ROR

2012-09-13 Thread Rajesh reddy
Hi Keerthi, We have been developing very large web applications with MongoDB from the past 1 year. It's really cool and very easy to learn. Give it a try you can find it very interesting and easy to use Thanks, Rajesh. On Thursday, September 13, 2012 11:38:11 AM UTC+5:30, keerthi priya wrot

[Rails] Re: Different DataBases Used in ROR

2012-09-12 Thread Kashif Umair Liaqat
Oracle is the best option for what you want. If you can afford it (because it is a bit expensive) you should go for Oracle but if you want a free solution then I would recommend MySQL. On Thursday, September 13, 2012 11:08:11 AM UTC+5, keerthi priya wrote: > > Hi all i am trying analyze which Da