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'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.
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.
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.