Basics of Vim Text Editor

Vim text editor is used for creating, editing and perform other operations in a text file. Common modes in Vim i.e. Normal Mode : Hit the Esc key to enter Normal mode.Command Mode : Type colon ( : ) in the normal mode to go to this mode.Insert Mode : [...]

2021-07-06T17:06:49+05:30Categories: Programming|

Comparison Between MySQL and SQLite

Relational Database Management Systems (RDBMS) are based on the relational model invented by Edgar F. Codd. They store data in the form of tables, and allow the data to be linked by establishing a relationship between the tables. MySQL and SQLite are both based on the relational database management system [...]

2020-10-02T22:45:39+05:30Categories: Programming|Tags: |

What is Schema in SQL ?

A schema is a collection of database objects (tables, views, functions, indexes ,etc) associated with one particular database username. This username is called the schema owner. A database can have one or multiple schemas. An object within a schema is qualified using the schema_name.object_name format. Say a user's database username [...]

2020-09-30T13:14:36+05:30Categories: Programming|Tags: , |


TRUNCATE TABLE statement empties a table completely. Logically, it is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. Syntax Following is the syntax of TRUNCATE TABLE statement: TRUNCATE [TABLE] table_name; It will delete all data in a table table_name. [...]

2020-09-29T17:09:25+05:30Categories: Programming|Tags: |

Create Database in MySQL

A database is a directory that contains all files which correspond to tables in the database. To create a new database in MySQL, use following syntax: CREATE DATABASE [IF NOT EXISTS] database_name [CHARACTER SET charset_name] [COLLATE collation_name] It will create a new database, where database_name : Name of the database. [...]

2020-09-29T15:24:30+05:30Categories: Programming|Tags: , |

Views in SQL

Views in SQL are the virtual tables. They have rows and columns like they are present in the normal database tables. But it fetches selective portion of the data from one or more tables. A view is a named query stored in the database catalog. Creating View To create a [...]

2020-09-29T13:31:47+05:30Categories: Programming|Tags: |

What is Reactive Programming ?

Reactive Programming (Rx) is a declarative programming paradigm concerned with data streams and the propagation of change. In reactive programming, data streams are spine of application. Events, messages, calls, and even failures are going to be conveyed by a data stream. With reactive programming, you observe these streams and react [...]

2020-09-28T17:07:47+05:30Categories: Programming|

bind Function and Placeholders in C++

Function template std::bind takes a function as input and generates a forwarding call wrapper. Calling this wrapper is equivalent to invoking input function with some of its arguments. A placeholder forwards argument to the calling function object returned by std::bind. Syntax std::bind is defined in functional header. Below is syntax [...]

2020-09-25T15:25:33+05:30Categories: Programming|Tags: |

accumulate and partial_sum Function in C++

std::accumulate() computes the sum of the given elements in the range. std::partial_sum() computes the partial sums of the elements in the subranges of the range. Syntax Below is the syntax of accumulate. template <class InputIterator, class T> T accumulate (InputIterator first, InputIterator last, T init); template <class InputIterator, class T, [...]

2020-09-23T18:08:25+05:30Categories: Programming|Tags: |
Go to Top