Hi all i am trying analyze which DataBase is good for ROR if the application is huge. After goggling i found the following DB used in ROR 1) MONGO DB 2) MYSQL 3) POSTGRESQL 4) SQLITE 5) ORACLE apart from above list any other DB are used for ROR and my Questions is from the above which DB is more faster to fetch queries and to maintain Big DB. Cheers, Kp -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/9O6GmiXFBawJ. For more options, visit https://groups.google.com/groups/opt_out.
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 DataBase is good for ROR if the > application is huge. After goggling i found the following DB used in ROR > > 1) MONGO DB > 2) MYSQL > 3) POSTGRESQL > 4) SQLITE > 5) ORACLE > > apart from above list any other DB are used for ROR and my Questions is > from the above which DB is more faster to fetch queries and to maintain Big > DB. > > > > > Cheers, > Kp > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/k-ErZz3fcmIJ. For more options, visit https://groups.google.com/groups/opt_out.
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
wrote:>
> Hi all i am trying analyze which DataBase is good for ROR if the
> application is huge. After goggling i found the following DB used in ROR
>
> 1) MONGO DB
> 2) MYSQL
> 3) POSTGRESQL
> 4) SQLITE
> 5) ORACLE
>
> apart from above list any other DB are used for ROR and my Questions is
> from the above which DB is more faster to fetch queries and to maintain Big
> DB.
>
>
>
>
> Cheers,
> Kp
>
>
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/3vLOC25BBXUJ.
For more options, visit https://groups.google.com/groups/opt_out.
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 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 wrote: >> >> Hi all i am trying analyze which DataBase is good for ROR if the >> application is huge. After goggling i found the following DB used in ROR >> >> 1) MONGO DB >> 2) MYSQL >> 3) POSTGRESQL >> 4) SQLITE >> 5) ORACLE >> >> apart from above list any other DB are used for ROR and my Questions is >> from the above which DB is more faster to fetch queries and to maintain Big >> DB. >> >> >> >> >> Cheers, >> Kp >> >>-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/kIl-ZZ5kly8J. For more options, visit https://groups.google.com/groups/opt_out.
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 treading in deep water - you''ll have no chance to even look at the code. That said, it''s ultimately up to you. Do some research, spec out your system, and I''m sure you''ll choose the right one (or you''ll figure out pretty quickly if you didn''t). Pasha On Thu, Sep 13, 2012 at 4:17 AM, Kashif Umair Liaqat <kulking370-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote:> 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 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 wrote: >>> >>> Hi all i am trying analyze which DataBase is good for ROR if the >>> application is huge. After goggling i found the following DB used in ROR >>> >>> 1) MONGO DB >>> 2) MYSQL >>> 3) POSTGRESQL >>> 4) SQLITE >>> 5) ORACLE >>> >>> apart from above list any other DB are used for ROR and my Questions is >>> from the above which DB is more faster to fetch queries and to maintain Big >>> DB. >>> >>> >>> >>> >>> Cheers, >>> Kp >>> >>> -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To view this discussion on the web visit > https://groups.google.com/d/msg/rubyonrails-talk/-/kIl-ZZ5kly8J. > > For more options, visit https://groups.google.com/groups/opt_out. > > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
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 <kulking370-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote:> 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 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 wrote: >>> >>> Hi all i am trying analyze which DataBase is good for ROR if the >>> application is huge. After goggling i found the following DB used in ROR >>> >>> 1) MONGO DB >>> 2) MYSQL >>> 3) POSTGRESQL >>> 4) SQLITE >>> 5) ORACLE >>> >>> apart from above list any other DB are used for ROR and my Questions is >>> from the above which DB is more faster to fetch queries and to maintain Big >>> DB. >>> >>> >>> >>> >>> Cheers, >>> Kp >>> >>> -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To view this discussion on the web visit > https://groups.google.com/d/msg/rubyonrails-talk/-/kIl-ZZ5kly8J. > > For more options, visit https://groups.google.com/groups/opt_out. > > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
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 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 <kulki...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<javascript:> > > wrote: > >> 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 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 >>> wrote: >>>> >>>> Hi all i am trying analyze which DataBase is good for ROR if the >>>> application is huge. After goggling i found the following DB used in ROR >>>> >>>> 1) MONGO DB >>>> 2) MYSQL >>>> 3) POSTGRESQL >>>> 4) SQLITE >>>> 5) ORACLE >>>> >>>> apart from above list any other DB are used for ROR and my Questions is >>>> from the above which DB is more faster to fetch queries and to maintain Big >>>> DB. >>>> >>>> >>>> >>>> >>>> Cheers, >>>> Kp >>>> >>>> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby on Rails: Talk" group. >> To post to this group, send email to rubyonra...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<javascript:> >> . >> To unsubscribe from this group, send email to >> rubyonrails-ta...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/rubyonrails-talk/-/kIl-ZZ5kly8J. >> >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/9iqVj_NiFzgJ. For more options, visit https://groups.google.com/groups/opt_out.
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 it aswell. MongoDB - is a NoSQL database and can come in very handy when you have a lot of documents to store. It scales very well as you can just add new nodes on the fly. Oracle - I don''t have any experience with that one. As you can see it is not possible to answer your question just based on "which DB is faster and (whoch one) can maintain a big DB". You have to be more specific on what kind of data you want to store. Do you have highly connected data? Then you might want to take a look at a graph database like Neo4j. Do you have a lot of unstructured data with varying attributes? Take a look at MongoDB. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
@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 <pashamur-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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 treading in deep water - you''ll have no chance to even look at the > code. > > That said, it''s ultimately up to you. Do some research, spec out your > system, and I''m sure you''ll choose the right one (or you''ll figure out > pretty quickly if you didn''t). > > Pasha > > > On Thu, Sep 13, 2012 at 4:17 AM, Kashif Umair Liaqat <kulking370-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org > > wrote: > >> 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 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 >>> wrote: >>>> >>>> Hi all i am trying analyze which DataBase is good for ROR if the >>>> application is huge. After goggling i found the following DB used in ROR >>>> >>>> 1) MONGO DB >>>> 2) MYSQL >>>> 3) POSTGRESQL >>>> 4) SQLITE >>>> 5) ORACLE >>>> >>>> apart from above list any other DB are used for ROR and my Questions is >>>> from the above which DB is more faster to fetch queries and to maintain Big >>>> DB. >>>> >>>> >>>> >>>> >>>> Cheers, >>>> Kp >>>> >>>> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby on Rails: Talk" group. >> To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To unsubscribe from this group, send email to >> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To view this discussion on the web visit >> https://groups.google.com/d/msg/rubyonrails-talk/-/kIl-ZZ5kly8J. >> >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit https://groups.google.com/groups/opt_out. > > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
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 = $5,800 up to the top end Enterprise Edition = $47,500 There are probably other charges and taxes to pay and you will need a skilled database guy to make the most of it. Whats the point paying thousands of dollars for a product and then not using it to its full potential. Unless you have money to throw away :) As to MySQL, at the moment it looks like Oracle is starting to close that up too, or at least make it less open source friendly. You might want to give it a wide berth until the dust settles on this one. There are drop in replacements for MySQL such as MariaDB. Utilise MySQL skills and tools without lock in from Oracle. Postgres is good, we use it exclusively. Sqlite is good for small things but when it gets large I believe (but have no first hand experience) starts to show its limitations. Perhaps others with better experience could comment here. The advantage of MySQL and PostgreSQL is that tools exist to replicate and shard the database should things get too large for a single database server, these tools do not exist for Sqlite. MondoDB is a document based solution and not a relational database so its use would depend on if your data is better suited to the relational model or the document model. We found that inserts into MongoDB were significantly slower than PostgreSQL and so was not suitable for our needs, pity really because it would have been a better fit for the data. But we update the data far more often then we read it. If your data is really a document model then you might also look at eXist, an XML database. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.