Sequelize

What is Sequelize? Sequelize is a javascript library used in NodeJS as ORM to access relational database schemas as objects.¬† The library is written entirely in Javascript to be used in NodeJS environment.   Features Sequelize is used in NodeJS and is available via npm. Sequelize is an ORM (Object Relational Mapper) It provides easy access to various databases like MySQL, MariaDB, SQLite, or PostgreSQL. It has good support for database synchronization, eager loading, associations, transactions and migrations. It is …

Query optimization in SQL Server

Introduction A query is a request for information from a database. Initially when we have small amount of data everything runs well. Now It has been long time since your team have developed the application. The same query that you were executing earlier was working fine but now it is taking more time. Query optimizer attempts to determine the most efficient way to execute a given query. So in short¬†“Query optimization” is the overall process of choosing the most efficient …

Object Relational Mapping in PHP

This blog is about what is Object Relational Mapping? Why and when we should use Object Relational Mapping with PHP. What is Object Relational Mapping? Object-Relational Mapping in computer science is a programming technique for converting data between incompatible type systems in object-oriented programming languages. This creates, in effect, a “virtual object database” that can be used from within the programming language. It treats data stored in relational (SQL) database table records as if they are objects. It is like …

Introduction to MongoDB

The most innovative structures for storing data today are NoSQL and object-oriented databases. These do not follow the table/row/column approach of RDBMS. There are four types of NoSQL databases :- Document Database Graph Database Key-value Database Wide-column Database This blog is about a NoSQL database which stores data in the form of document i.e.MongoDB. MongoDB is a open source, cross platform and document- oriented database which stores data in forms of collection of documents. It is written in C++.It can …