Difference between ReactNative and ReactJS

ReactNative Vs ReactJS Listed below is a comparative study between the ReactNative and the ReactJS.   ReactNative ReactJS JavaScript framework. Open-source JavaScript library.  Used to build a real, native mobile applications for iOS, Android, and Windows. Used to build a user interface for Single Page Application. Initial release: 2013 Initial release: 2015 Used for developing … Read more

Advantages and Disadvantages of ReactJS

Pros and Cons Listed below are the list of advantages that ReactJS offers to the developers. But nothing comes with some or more limitations attached with it and same applies to ReactJS also.   Advantage of ReactJS Easy to understand and easy to use: A good supply of documentation, tutorials, and training resources, helps the … Read more

Install ReactJS

React Installation There are some prerequisites to set-up an environment for ReactJS. These are: NodeJS and NPM, React and React DOM, Webpack and Babel. To install ReactJS there are two ways: by using the npm command and by using the create-react-app command.   Using the create-react-app command: The ‘create-react-app’ is a tool maintained by Facebook … Read more

React version history

React Version VERSION FEATURES RELEASED ON Version 0.3.0 ●      Initial Public Release 29 May 2013 Version 0.4.0 ●      Support for comment nodes <div>{/* */}</div> ●      Improved server-side rendering APIs ●      Removed React.autoBind ●      Support for the key prop ●      Improvements to forms ●      Fixed bugs 20 July 2013 Version 0.5.0 ●      Improved Memory usage ●      … Read more

Functions in PostgreSQL

PostgreSQL Functions PostgreSQL functions are stored procedures and can be easily understood as a set of SQL and procedural statements. They are stored on the database server. A function can be invoked using the SQL interface. It facilitates to ease the operations within the database. A PostgreSQL function can be created in several languages including … Read more

CROSS Join in PostgreSQL

CROSS JOIN The PostgreSQL CROSS Join query combines each row of the first table with each row of the second table in the result set. Thus, if we select all the fields of both the table than the resultant table contains x*y rows, where the FIRST table has x number of rows and the Second … Read more

Full Outer Join in PostgreSQL

Full Outer Join: The Full Outer Join query after joining returns all the records from the selected fields of both the tables irrespective of the fact that the join condition is met or not. Syntax: SELECT expr_1, expr_2, … expr_n FROM table_1 FULL OUTER JOIN table_2 ON join_predicate; Parameters: join_predicate: It is used to specify … Read more

Left Outer Join in PostgreSQL

OUTER JOIN The PostgreSQL database supports three major types of Outer joins: Left Outer Join or Left Join Right Outer Join or Right Join Full Outer Join or Full Join Left Outer Join: The Left Outer Join query after joining returns all the records from the Left table for the specified fields along with the … Read more

RIGHT OUTER JOIN in PostgreSQL

Right Outer Join: The Right Outer Join query after joining returns all the records from the Right table for the specified fields along with the records from the Left table where the join condition is met. Syntax: SELECT expr_1, expr_2, … expr_n FROM table_1 RIGHT OUTER JOIN table_2 ON join_predicate; Parameters: join_predicate: It is used … Read more

JOINS in PostgreSQL

PostgreSQL JOINS To create a new table with the records as a combination of records from multiple tables, the PostgreSQL Join Query is used. Types of Joins: The PostgreSQL database supports mainly five types of Joins. These are: Inner or Simple Join Left Outer Join Right Outer Join Full Outer Join Cross Join INNER JOIN … Read more