S J, Author at Adglob Infosystem Pvt Ltd

DocumentDB SQL – From Clause

Post author:S J
Post published:August 20, 2021
Post category:DocumentDB SQL
Post comments:0 Comments

In this chapter, we will cover the FROM clause, which works nothing like a standard FROM clause in regular SQL. Queries always run within the context of a specific collection…

DocumentDB SQL – Select Clause

Post author:S J
Post published:August 20, 2021
Post category:DocumentDB SQL
Post comments:0 Comments

The Azure portal has a Query Explorer that lets us run any SQL query against our DocumentDB database. We will use the Query Explorer to demonstrate the many different capabilities…

DocumentDB SQL Tutorial

Post author:S J
Post published:August 20, 2021
Post category:DocumentDB SQL
Post comments:0 Comments

DocumentDB is Microsoft's newest NoSQL document database platform that runs on Azure. DocumentDB is designed keeping in mind the requirements of managing data for latest applications. This tutorial talks about…

PostgreSQL – Python Interface

Post author:S J
Post published:August 19, 2021
Post category:PostgreSQL
Post comments:0 Comments

Installation The PostgreSQL can be integrated with Python using psycopg2 module. sycopg2 is a PostgreSQL database adapter for the Python programming language. psycopg2 was written with the aim of being…

PostgreSQL – Perl Interface

Post author:S J
Post published:August 19, 2021
Post category:PostgreSQL
Post comments:0 Comments

Installation The PostgreSQL can be integrated with Perl using Perl DBI module, which is a database access module for the Perl programming language. It defines a set of methods, variables…

PostgreSQL – PHP Interface

Post author:S J
Post published:August 19, 2021
Post category:PostgreSQL
Post comments:0 Comments

Installation The PostgreSQL extension is enabled by default in the latest releases of PHP 5.3.x. It is possible to disable it by using --without-pgsql at compile time. Still you can use yum…

PostgreSQL – JAVA Interface

Post author:S J
Post published:August 19, 2021
Post category:PostgreSQL
Post comments:0 Comments

Installation Before we start using PostgreSQL in our Java programs, we need to make sure that we have PostgreSQL JDBC and Java set up on the machine. You can check…

PostgreSQL – C/C++ Interface

Post author:S J
Post published:August 19, 2021
Post category:PostgreSQL
Post comments:1 Comment

This tutorial is going to use libpqxx library, which is the official C++ client API for PostgreSQL. The source code for libpqxx is available under the BSD license, so you are free…

PostgreSQL – Useful Functions

Post author:S J
Post published:August 19, 2021
Post category:PostgreSQL
Post comments:0 Comments

PostgreSQL built-in functions, also called as Aggregate functions, are used for performing processing on string or numeric data. The following is the list of all general-purpose PostgreSQL built-in functions −…

PostgreSQL – Functions

Post author:S J
Post published:August 19, 2021
Post category:PostgreSQL
Post comments:0 Comments

PostgreSQL functions, also known as Stored Procedures, allow you to carry out operations that would normally take several queries and round trips in a single function within the database. Functions allow…