Can node.js be used for working with database? like CRUD opertaion.

Answer 1

MongDb is NoSql, it's easy to manage and has higher level of flexibility compare to Sql, and it's easier in term of scalability from small to huge.

Sql like Mysql needs detailed database model, once the model is fixed, it's hard to alter, whereas NoSql like MongDb can be created quickly without detail database model, and it can be changed or add extra data easily.

NoSql is using Json formatted data, it's easier to work with NodeJs since they share the same language Javascript.

If you good at Javascript and your web server supports NodeJs and MongoDb, you should learn and use NodeJs in your new projects, once you familiar with NodeJs and MongDb, you would not like to go back to PHP and Mysql again.

Answer 2

can it be used with mysql, sql server and oracle

Answer 3

Yes, it can. It normally use it with Nosql like MongoDB.
You can use Express.js and Mongoose ODM to create CRUD operation with MongoDB. Check out http://mongoosejs.com/

Answer 4

Yes, it's possible