addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1linklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Re: [NYC-rb] Databases

From: John C.
Sent on: Sunday, June 2, 2013 4:46 PM
If you're going the SQL route, I agree that you're going to be hard pressed to find a compelling reason not to use postgresql. However, I think understanding the differences in style, complexity, function, and strengths of sql vs. nosql vs. key/value stores is really advantageous. 

For me the keys are:

SQL - Strong transactional support, built in synchronization strategies, data integrity constraints/strict typing/etc.
NoSQL  - Simplicity, flexibility, asynchronous operation.
Redis - Simplicity, performance, auto-expiration of data, easy mgmt of "moving" data like feeds and lists, or high write volume stuff like analytic tracking and job queues

I'd strongly recommend at least some shallow familiarity with each, since often the best app architectures incorporate more than one persistence mechanism/strategy IMO. Just because you are using postgres or mongo for some data doesn't mean you need to use it for all your data.


On Sun, Jun 2, 2013 at 4:17 PM, Vincent <[address removed]> wrote:
With what I know right now, I agree with Thomas about Postgresql. It's particularly handy to have arrays in there but just looking for a good beach read about its other advantages. Also good to know other ones inside and out in case I join a project using something else. I'll check out Seven Databases in Seven Weeks, thanks.


On Sun, Jun 2, 2013 at 4:10 PM, Stephen Schor <[address removed]> wrote:
I have heard decent things aout Seven Databases in Seven Weeks.
It's published by Pragmatic Press.

Stephen


On Sun, Jun 2, 2013 at 11:49 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 Stephen Schor ([address removed]) from NYC.rb.
To learn more about Stephen Schor, visit his/her member profile



--
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]

Our Sponsors

  • Pivotal Labs

    Provides the awesome event space we use every month!

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