Hi, I''m currently building a small rails application that needs to store web traffic information. Similar to google analytics and clicky. (but simpler) It needs to store refer domains and visitors. Integration goes through a small javascript snippet. My question is: What database server is the fastest and should I use for this app? I was thinking about SQLlite. Thanks for your time, Regards, Vincent -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Vincent Bakker wrote:> Hi, > > I''m currently building a small rails application that needs to store web > traffic information. Similar to google analytics and clicky. (but > simpler) It needs to store refer domains and visitors. Integration goes > through a small javascript snippet. > > My question is: What database server is the fastest and should I use for > this app? > > I was thinking about SQLlite.No! SQLite is not suitable for production use in Web applications, since it doesn''t handle concurrency issues well. PostgreSQL should be fast enough if set up properly; you might also consider something like MongoDB.> > > Thanks for your time, > > Regards, > > VincentBest, -- Marnen Laibow-Koser http://www.marnen.org marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
How much traffic are you expecting, how many inserts a minute? You should simply set up a test and use curl perhaps to call the api and see which database performs best. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On 04 Feb 2010, at 14:18, Vincent Bakker wrote:> I''m currently building a small rails application that needs to store > web > traffic information. Similar to google analytics and clicky. (but > simpler) It needs to store refer domains and visitors. Integration > goes > through a small javascript snippet. > > My question is: What database server is the fastest and should I use > for > this app? > > I was thinking about SQLlite.Dont use SQLite in production, it''s not designed for that, it''s more of a single user local database. I''d suggest MongoDB for your use- case, but PostgreSQL or MySQL could also be an option. Best regards Peter De Berdt -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
I recently heard about MongoDB, maybe Ill give that one a try. If I use the Mongo Wrapper does it work the same as if I where using a SQL or MYSQL database? -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Vincent Bakker wrote:> I recently heard about MongoDB, maybe Ill give that one a try. > > If I use the Mongo Wrapper does it work the same as if I where using a > SQL or MYSQL database?MySQL *is* a SQL database. Answer: I''m not sure. I suspect it would be at least a little different since the underlying DB is so different, but I''ve never used Mongo. But PostgreSQL will work just like any other SQL database. Best, -- Marnen Laibow-Koser http://www.marnen.org marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On 04 Feb 2010, at 17:36, Vincent Bakker wrote:> I recently heard about MongoDB, maybe Ill give that one a try. > > If I use the Mongo Wrapper does it work the same as if I where using a > SQL or MYSQL database?Mongomapper uses a slightly different syntax than ActiveRecord, leaning more towards DataMapper. This is quite understandable though, since it''s more apt for a schemaless database. No reason not to use it though. Best regards Peter De Berdt -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.