Programming

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 : in the normal mode to go to this mode.Insert Mode : Type i in the normal mode to go to insert mode. .(dot) repeat

2021-02-14T15:03:24+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 model. SQLite SQLite is an embedded, file-based RDBMS. It is

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 is USER1. If this user log on to the database

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

TRUNCATE TABLE Statement in MySQL

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. The TABLE keyword is optional. If there is any FOREIGN

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. The database name must be unique within the MySQL server

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 new view you use the CREATE VIEW statement. Syntax for

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 when a value is emitted. In Rx programming data flows

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 template <class Fn, class... Args> bind (Fn&& fn, Args&&... args);

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, class BinaryOperation> T accumulate (InputIterator first, InputIterator last, T init,

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

copy and copy_if Function in C++

std::copy() and std::copy_if() function in C++ copies the elements in the range, to another range. However std::copy_if() function copies the element based on result of unary function passed to it. Syntax Syntax of copy() and copy_if() function is template <class InputIterator, class OutputIterator> OutputIterator copy (InputIterator first, InputIterator last, OutputIterator result); template <class InputIterator, class OutputIterator, class UnaryPredicate> OutputIterator copy_if

2020-09-23T16:51:45+05:30Categories: Programming|Tags: |
Go to Top