Re: [NYC-rb] Databases

From: Vincent
Sent on: Monday, June 3, 2013 9:30 PM
Thanks for all of your suggestions. I'll be watching the videos from Database Month and from 10gen for more background on these things. Right now, I'm keeping my current project in postgresql but I will try out Mongo and others when I mess around. Good to get out of my comfort zone. 

Thanks for all of the advice. 

-Vincent


On Mon, Jun 3, 2013 at 12:05 PM, Tyler Poland <[address removed]> wrote:
Buffalo's DB Seminar was the ThoughChild of our very own Charlie Wertz (former UB Prof and all around awesome guy) and is "officially" organized through BuffaloLab http://www.meetup.com/buffalolab/. We started with a history of the development of data repositories over time and database theory and are now getting into presenting various specific implementations. We typically have about a 1 hour presentation/lecture by various knowledgeable folks followed by some social time. If you are ever in town you are of course welcome to join us and it would be amazing to hear of someone organizing something similar in the Big Apple (do you guys still call it that?).

Tyler


On Mon, Jun 3, 2013 at 11:42 AM, Francesca Krihely <[address removed]> wrote:
TL;DR this is a list of resources for NYCers looking to learn more about MongoDB 

If you're interested in learning more about MongoDB, I run the NYC User Group that meets every month in the City. The talks are mostly on use-cases and best practices but it's a good opportunity to get a general overview of how it works. 


10gen also hosts weekly office hours for those with questions on MongoDB (You can sign up for those through the user group). if you want to get really into the Nitty Gritty, we're also hosting our annual MongoDB conference on June 21 


Also there are free online courses available each month: https://education.10gen.com/

Hope this is helpful! 


On Mon, Jun 3, 2013 at 11:33 AM, Bent Cardan <[address removed]> wrote:
Hear Hear. That was well said Tyler. I agree roughly 100% with the first part and I'm just like ready to kick it or participate or check in on any of the things mentioned in the later part. Like I want to hang out with the 10Gen, Basho, DB Seminar knowledge crowd, where's that party? 

The reason I want to get into the nitty gritty with true heads on the topic is because like you say, data needs crop up with added complexity. Like for example, what about my user sessions? I use Redis ostensibly for authentication. Not looking up a user's MD5 or whatever SHA hash stored in the DB, but rather alleviating a different constraint to performance. I prefer to use Redis for tracking the state and status of these users without much impact on throughput off the top of the stack, freeing up threads and whatnot. Just for that bit Redis is a perfect solution because it provides quick access to a persistent session object throughout my user's experience of the app until logout or leave. The stuff I want to learn more about and converse about is like getting into the MongoDB aggregation framework, the grouping and matching and result parsing stuff and for sure anything to do with MapReduce.  -Bent

[address removed]



On Jun 3, 2013, at 10:37 AM, Tyler Poland <[address removed]> wrote:

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





--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Tyler Poland ([address removed]) from NYC.rb.
To learn more about Tyler Poland, 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 Bent Cardan ([address removed]) from NYC.rb.
To learn more about Bent Cardan, visit his/her member profile



--

   

name     : "Francesca  Krihely", 
  title    : "Community Manager for MongoDB at 10gen",
  phone    : "[masked]",
  location : "New York, NY",
  twitter  : ["@francium", "@MongoDB""@10gen"],
  facebook : ["MongoDB", "10gen"] }




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





--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Tyler Poland ([address removed]) from NYC.rb.
To learn more about Tyler Poland, 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]



--
Vincent Trivett
Multimedia Journalist

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