gusty edge
Basically, I want to create an e commerce app which, if done correctly would have a Customers, Products and Orders table, which would all be related by the corresponding primary/foreign id key.
Im probably gonna use PostgreSQL, but wondered about the pros and cons of each for this situation
modest lance
its the best choice and is powerful to use, go ahead and use it .
its also has much features comparing to other technologies
gusty edge
yeah was more wondering postgres vs mongodb not necessarily postgres vs mysql etc, i've seen theres basically no competition there
but the only thing with document oriented databases is they scale nicely, but i can just deal with that in the future if i need to i guess
thanks ! :)
worldly tulip
Jotting down the differences between a Relational and a NoSQL database would be far too much to note simply in a forum post. You should research the subject. They both have advantages and disadvantages. If you have experience/ knowledge with working with the one or the other, that should also play a role in the decision to use a certain database. I can say with certainty, both Postgres and MongoDB can handle an eCommerce application with no problem.
gusty edge
yeah im used to relational databases, i'll have a look at nosql though, thanks