Re: [NYC-rb] Databases

From: Tyler P.
Sent on: Monday, June 3, 2013 10:11 AM
Hi Vincent,

As someone who supports applications running MySQL, PostgreSQL, MongoDB, and Riak currently (ordered by number of servers) I wanted to take a moment to weigh in on this. The bar for entry to a database such as MySQL or PostgreSQL (via EnterpriseDB) is really so low that I wouldn't recommend using SQLite for more than just a preliminary exploration of rails. The abstract nature of your interaction with the database through rails means that you really won't be interacting with the database directly very often. Once you do reach that level of complexity you are you are probably pushing the capabilities of SQLite, and will benefit from having some base interaction knowledge that you have accumulated gradually over time.

Seven Databases in Seven Weeks is also an excellent read for what you are asking, but its handy to have a computer nearby so I wouldn't quite call it a beach read. You'll notice a review in there from Dr. Nic @ Engine Yard that pretty much says it all. This particular book is really good at explaining the use cases that each database engine is good for answering. Some applications are actually well served by having more than one data repository type behind the scenes.

Just a thought for NYC-rb in general: We've hosted several DB talks @WNYRuby and they tend to be really well attended and reviewed. If you haven't already I highly recommend reaching out to DB groups, 10Gen, Basho, etc to see if they'd be interested in sending a speaker to one of your meetups. We recently hosted Dan Crosta (@lazlofruvous) at a DB Seminar through BuffaloLab (not WNYRuby) here; he is from NYC and provided an excellent overview of MongoDB.

Thank you,
Tyler




On Mon, Jun 3, 2013 at 9:28 AM, James Gray <[address removed]> wrote:
Hey Vincent,

First, Tom's advice was well-meaning, but not good advice - don't just pick a database because someone says it is the best - do your own research as you will be married to the DB once your projects get more involved and it becomes prohibitively tedious to change a DB later. Also, Postgres is a jack-of-all-trades DB that does almost everything; there are purpose-built DBs that may fit your project better and are usually far easier to use and scale than the jack-of-all-trades style (like Postgres or MySQL)

If you want a full overview of many of the most-modern  SQL (eg. Postgres) as well as NoSQL (eg. MongoDB) databases, check out the videos of the various DBs on http://www.DatabaseMonth.com 

Also, consider attending tomorrow's Database Month event which has free BEER, Pizza, Swag- New Operational Database: Scale-out Transactions & Real-time Analytics, presented by Sergei Tsarev, Co-Founder & CTO, Clustrix with Dmitri Mikhailov, Principal Database Architect, TheLadders



On Sun, Jun 2, 2013 at 11:48 AM, Vincent <[address removed]> wrote:
Hey all.

I'm still fairly new to Rails but I feel like I am a little clueless about our choices of database and I would like to learn more.

Is there anything you all know of that compares postgresql, mongo, sqlite, etc? I want to have a better overview of their strengths and weaknesses, and also make sure that my machine is ready to use all of them. 

I appreciate your feedback.


--
Vincent Trivett
Multimedia Journalist





--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Vincent ([address removed]) from NYC.rb.
To learn more about Vincent, visit his/her member profile
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]





--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by James Gray ([address removed]) from NYC.rb.
To learn more about James Gray, visit his/her member profile

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy