database

TL;DR: Serverless removes the architecture responsibilities like hardware provisioning, scaling, and maintenance in cloud-based application development. Serverless Architecture Serverless (also called Serverless computing) is a way of software development, where the software application is built and run without having to manage servers (hardware). This is more attractive for application developers as it provides a complete abstraction […]

In a typical application using Database, it is natural all the changes for fixing bugs or new features are sent as SQL scripts. In most of the cases we have single line scripts (DDL / DML statements). But there are some scenarios we need to run multi-line scripts like creating and running some procedures / […]

What is multiple-column index? MySQL or many RDBMS supports multiple-column indexes. i.e. The index key will be more than 1 column in the table. For example, consider a table consolidated CREATE TABLE `consolidated` ( `consolidated_id` int(11) NOT NULL AUTO_INCREMENT, `pub_id` int(11) DEFAULT NULL, `cp_id` int(11) DEFAULT NULL, `ro_id` int(11) DEFAULT NULL, `country_id` int(11) DEFAULT NULL, […]