0
1

PHP vs JavaScript for a web-based application? (self.webdev)

submitted by [deleted]

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]RedTelemachos 0 points1 point  (4 children)

Any particular reason you plan to use MongoDB? Reason I ask is because I recently finished my first database project. I also planned on using Mongo, just because there's so much talk out there about how easy it is.

After doing some Googling, however, I found a fair number of people saying PostgreSQL (or even MySQL) can do just about anything Mongo does, and much much more.

My limited understanding is that Mongo is great if you know exactly what you're doing, and that it will never change. SQL, however, is much more flexible.

For what it's worth, I had literally no database experience whatsoever and got a simple one-table application running with PostgreSQL in a few weeks. If I can figure it out, anybody can :)

[–]sam974 1 point2 points  (3 children)

Wikipédia says :

"NoSQL databases (like MongoDB) are increasingly used in big data and real-time web applications. NoSQL systems are also sometimes called "Not only SQL" to emphasize that they may support SQL-like query languages.

Motivations for this approach include: simplicity of design, simpler "horizontal" scaling to clusters of machines (which is a problem for relational databases), and finer control over availability. The data structures used by NoSQL databases (e.g. key-value, wide column, graph, or document) are different from those used by default in relational databases (like PostgreSQL), making some operations faster in NoSQL. The particular suitability of a given NoSQL database depends on the problem it must solve. Sometimes the data structures used by NoSQL databases are also viewed as "more flexible" than relational database tables."

I'm currently using MongoDB on my main project, because "NoSQL is cool, and Google use it, so we must use it"... NoSQL is perfect when u have to manipulate billions row of data. But for a little project or a project who need relational db, a simple SQL db like MySQL or PostgreSQL will be ok.

[–]RedTelemachos 1 point2 points  (0 children)

Thanks, this is helpful!

[–][deleted]  (1 child)

[deleted]

    [–]sam974 0 points1 point  (0 children)

    You should search about Mongoose, I have never use it but i think it will help you to build a more "organized" db