MySQL Indexing and Internals

A database index is a data structure that improves the speed of operations in a table. MySQL indexing is used to avoid full table scan. An index is a data structure (most commonly a B- tree) that stores the values for a specific column in a table. An index is created on a column of […]

Middlewares in Node.JS

An Express application is essentially a series of middleware function calls. Middleware functions are functions that have access to the request object (req), the response object (res), and the next middleware function in the application’s request-response cycle. Source : Types of middleware functions: Application – level middleware Router – level middleware Error – handling middleware […]

NodeJS Under the Hood

what does it mean by : NodeJS is single threaded non blocking eventdriven framework…. NodeJS works on single thread ie main thread . where as other develoment platforms use multiple threading to process multiple request you can say one thread per request . So by using single thread NodeJS saves a lot of memory. NodeJS […]

MySQL Client and MySQL Server Difference

Source : MySql Client : The mysql-client package allows you to connect to a MySQL server. It will give you the “mysql” command-line program. MySql Server : The mysql-server package allows to run a MySQL server which can host multiple databases and process queries on those databases. MySQL : The “MySQL” package probably includes both […]

REST Webservices

RESTful Web Services are basically REST Architecture based Web Services. In REST Architecture everything is a resource. RESTful web services are light weight, highly scalable and maintainable and are very commonly used to create APIs for web-based applications. REST Architecture : A concrete implementation of a REST Web service follows four basic design principles: Use […]

Understanding NodeJS

What is node js Node.js is a runtime system for creating (mostly) server-side applications. It’s best known as a popular means for JavaScript coders to build real-time Web APIs. Node.js is a platform built on Chrome’s JavaScript runtime for easily building fast and scalable network applications. Node.js uses an event-driven, non-blocking I/O model that makes […]