Yii Framework Forum: mySql or MongoDB - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

mySql or MongoDB Which one to use? Rate Topic: -----

#1 User is offline   Antonio Ramirez 

  • Elite Member
  • Yii
  • Group: Yii Dev Team
  • Posts: 1,447
  • Joined: 04-October 10

Posted 11 January 2011 - 06:35 AM

Hi guys,

I really need some good advice folks. I am about to start a personal project that, if successful, will have to work with lots of amount of data and checking recently tendencies I have been quite impressed with NoSQL databases, more precisely MongoDB.

So here are my question, would you start from scratch a project that uses that technology, even though the process will be a bit more slow due to the need of learning such tech in advance *properly learn*? Or would you stick with mySQL even though you know that your project will one day change?

Have you guys worked with mongoDB? What do you think about it?

Thanks in advance!
¿How long would it take for you to understand that you own nothing in this world?

www.ramirezcobos.com
www.2amigos.us
www.github.com/tonydspaniard
www.github.com/2amigos


Posted Image
0

#2 User is offline   Mike 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 3,013
  • Joined: 06-October 08
  • Location:Upper Palatinate

Posted 11 January 2011 - 09:19 AM

I had a look at couch DB some time ago. Not sure, but i think it's using a similar approach like MongoDB. In my opinion i would not use such a system if i don't really need it. The reason for this is simply: I know more about relational databases and how to work with them or improve their performance ("never change a winning team").

The only case where couchDB would be an option for me would be, if i have very complex datasets that are hard to map to a relational database.
0

#3 User is offline   mk3 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 2
  • Joined: 17-November 10

Posted 11 January 2011 - 09:47 AM

It depends totally on your case. as I have read case studies for mongodb it seems really impressive. I'm also considering using mongodb for my project, but have some issues with that relational db knowledge kinda makes me kneel everytime i try to make logical datasets, on other hand people reporting huge improvements in performance while using mongodb, as for me I'm looking forward to use mongodb as it seems really viable case, large amount of different datasets and mysql would be real headache also large amount of data.
0

#4 User is offline   Antonio Ramirez 

  • Elite Member
  • Yii
  • Group: Yii Dev Team
  • Posts: 1,447
  • Joined: 04-October 10

Posted 11 January 2011 - 10:06 AM

Thanks both for such positive feedback. As you can see, both of you represent the factors of my doubts, on one side I have strong knowledge on relation database and on the other hand the performance reports from other people.
¿How long would it take for you to understand that you own nothing in this world?

www.ramirezcobos.com
www.2amigos.us
www.github.com/tonydspaniard
www.github.com/2amigos


Posted Image
0

#5 User is offline   Mike 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 3,013
  • Joined: 06-October 08
  • Location:Upper Palatinate

Posted 11 January 2011 - 10:10 AM

One golden rule for me that comes to mind here is "Never trust the hype!". :)
0

#6 User is offline   Antonio Ramirez 

  • Elite Member
  • Yii
  • Group: Yii Dev Team
  • Posts: 1,447
  • Joined: 04-October 10

Posted 11 January 2011 - 02:41 PM

Already convinced... thanks both
¿How long would it take for you to understand that you own nothing in this world?

www.ramirezcobos.com
www.2amigos.us
www.github.com/tonydspaniard
www.github.com/2amigos


Posted Image
0

#7 User is offline   sumwai 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 85
  • Joined: 16-March 09

Posted 11 January 2011 - 03:42 PM

I haven't use it before, but I was thinking of using both together - where mongodb will go to parts where I need flexible schema.
tipstank.com - where I share my coding stuff
0

#8 User is offline   Antonio Ramirez 

  • Elite Member
  • Yii
  • Group: Yii Dev Team
  • Posts: 1,447
  • Joined: 04-October 10

Posted 11 January 2011 - 03:49 PM

Yeah, I still thinking how the relations work among documents and gridFs elements and I do not have time to play with it. :(
¿How long would it take for you to understand that you own nothing in this world?

www.ramirezcobos.com
www.2amigos.us
www.github.com/tonydspaniard
www.github.com/2amigos


Posted Image
0

#9 User is offline   Pradhan 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 209
  • Joined: 01-May 09
  • Location:Charlotte, NC

Posted 29 January 2011 - 08:02 PM

Antonio,

Canni has developed two great extensions.

http://www.yiiframew...iimongodbsuite/
Allows you to interactive with MongoDB like AR

http://www.yiiframew...jsoneditorview/
I will say it is the PHPMyAdmin for MongoDB

I am using both to replace EAV based on RDBM only.
0

#10 User is offline   Antonio Ramirez 

  • Elite Member
  • Yii
  • Group: Yii Dev Team
  • Posts: 1,447
  • Joined: 04-October 10

Posted 30 January 2011 - 06:57 AM

View PostPradhan, on 29 January 2011 - 08:02 PM, said:

Antonio,

Canni has developed two great extensions.

http://www.yiiframew...iimongodbsuite/
Allows you to interactive with MongoDB like AR

http://www.yiiframew...jsoneditorview/
I will say it is the PHPMyAdmin for MongoDB

I am using both to replace EAV based on RDBM only.


Thanks for pointing that out Pradham, I already downloaded that great extension, and I use a different MongoDB admin. Nevertheless, I think that i will stick with RDMS until I need more flexibility on the future.
¿How long would it take for you to understand that you own nothing in this world?

www.ramirezcobos.com
www.2amigos.us
www.github.com/tonydspaniard
www.github.com/2amigos


Posted Image
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users