search

opensource-ny / OpenSource-NY

MIT License
10 stars 14 forks source link

Need a Data Base! #30

Closed yizongk closed 5 years ago

yizongk commented 5 years ago

We need a data base, let's try PostgresQL

Chocolate-Spaghet commented 5 years ago

How's MongoDB?

yizongk commented 5 years ago

MongoDB isn't relational, and PostgresQL is.

I think we would be better off if we could write statement like select all from user blah blah blah than grabbing a JSON stored in MongoDB and then parsing it, which could take time.

But then again, Javascript has nice API to play with JSON. What you think about it?

Chocolate-Spaghet commented 5 years ago

I'm good with either or. PostgresQL is good if we know what we are going to be storing exactly (you can store JSON in PSQL), but MongoDB has the advantage of storing pretty much anything. I think Mongo will be better since we may want to expand the things we store down the road. Mongo also has a very good query system, and can be somewhat used as a relational database. In general, I think Mongo will be better for this project.

yizongk commented 5 years ago

Ok! I have no problem with your reasoning. We will go with MongoDB!

Fioringo commented 5 years ago

This issue is resolved as the project is using MongoDB now. Thank you for the discussion! 🎉