Database

Understanding Azure Functions with Example

Author - Varun Chopra

What are Azure functions? Example of Invoking Azure functions inside the Logic App.

Azure Functions

In General, functions are used to run the small pieces of code to make it reusable. Similarly, Azure functions are used to run the small pieces of code inside Read more…

Customized multi row selection in Devextreme Datagrid

Author - Harleen Kaur

Customized multiple row selections in Devextreme Datagrid with dxRadiogroup as a Custom Column Field

I am using Devextreme jquery datagrid with paging options implemented that involves setting permissions for user. The target here is to update the datasource and dxRadiogroup values when multiple rows are selected Read more…

PostgreSQL 9.3.15 | Type “citext” does not exist

Author - Manju Kashyap
|
0 Comments
|

ERROR: type “citext” does not exist (on PostgreSQL 9.3.15)

While creating a table (email_notifications), we were facing this error type “citext” does not exist. The syntax of creating table and the error is shown in the screenshot below :

Then Read more…

Invalid value for header \u0067x-ms-request-id\u0067

Author - Harleen Kaur
|
0 Comments
|

Resolved Issue

“Invalid value for header \u0067x-ms-request-id\u0067. The header must contain a single valid GUID”

I was facing the issue “Invalid value for header \u0067x-ms-request-id\u0067. The header must contain a single valid GUID” while making request to the Read more…

Invalid value for header \u0067x-ms-request-id\u0067

Author - Harleen Kaur
|
0 Comments
|

Resolved Issue

“Invalid value for header \u0067x-ms-request-id\u0067. The header must contain a single valid GUID”

I was facing the issue “Invalid value for header \u0067x-ms-request-id\u0067. The header must contain Read more…

Sending email using Amazon SES service

Author - Ashish Gautam
|
0 Comments
|

Sending email with or without Attachment using Amazon SES service

First download the aws library using the this link:

http://docs.aws.amazon.com/aws-sdk-php/v3/download/aws.zip link and save it in project.

(adsbygoogle = window.adsbygoogle || []).push({});

Now the usage of library Read more…

PostgreSQL – Server doesn’t listen error

Author - Manoj Thakur
|
0 Comments
|

How to fix PostgreSQL server doesn’t listen error

While trying to connect to Postgress you may face this error – Server doesn’t listen.

Error:

This is not an error exactly but an exception that occurs when we are running two Read more…

Improve SQL query performance

Author - Banita Rani
|
0 Comments
|

Tips to improve SQL query performance

1. Avoid usage of multiple joins in a single query. Unnecessary joins degrade your query performance.

2. Creation of indexes on the table. Indexes are used for improving your queries. We need to create the indexes Read more…

DAO with JPA (and service layer/EJB3-Session Beans) or not

Author - Webner
|
0 Comments
|

There is a lot of discussion on internet about whether to have DAOs or not with JPA and service layer or with session beans (which is the service layer).

My personal opinion is more favored towards DAO layer and some reasons for this are following:

1. In most of the Read more…

MySQL | Communications link failure

Author - Manoj Thakur
|
0 Comments
|

MySql Communication link failure while connecting MySql server remotely

I’m getting the following error when I tried to connect MySql server remotely:

ERROR:
——————————————
Cannot connect to database server
Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not Read more…

MySql | Show only columns as rows which have specific value

Author - Ishpreet Kaur
|
0 Comments
|

Sometimes, we want to show only those columns which have specific value. Let’s assume we have following table :

In the above table, value of 1 in a column represents that corresponding service is provided by organization and 0 represents service is not provided by the organization.

In the above Read more…

SQL Transaction in Cakephp 3

Author - Parminder Kaur
|
0 Comments
|

SQL transaction in Cakephp 3 is a series of statements working in a logical order to handle database errors and ensure data integrity. There are four main methods being used in Sql transaction in Cakephp 3.

1. Initialize the statement using begin() method.

2. Execute the statement which Read more…

Azure | Consumer Web application to crerate copy of SQL Database

Author - Harleen Kaur
|
0 Comments
|

Azure provides various rest apis to perform different actions and operations that are possible in the azure server like to create web applications, databases and many more. User can design their own simplified UI to perform actions, instead of logging into Azure and perform all the steps one by one Read more…

MySql | Display Latest entries of two columns of two rows into single row

Author - Ishpreet Kaur
|
0 Comments
|

Suppose we have two tables : articles and article_comments

CREATE TABLE articles(
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 200 ) NOT NULL ,
`content` VARCHAR( 500 ) NOT NULL ,
`author_name` VARCHAR( 20 ) DEFAULT 1 NOT NULL ,
`author_email` VARCHAR( 50 ) NOT NULL ,
`created_date` TIMESTAMP NOT NULL DEFAULT ‘0000-00-00 00:00:00 Read more…

MySQL | How to convert row values into column names

Author - Anjana
|
0 Comments
|

Sometimes requirement arises to display a field value as column name in output and adjacent values in the same row below it as its values.

Suppose I have a table “students” with marks of each student in different subjects. Each student may not appear in every subject:

students

We want Read more…

Download CSV of table Records using OUTFILE sql command and PHP

Author - Deepika
|
0 Comments
|

Create and Download CSV of table Records using OUTFILE Sql command and PHP

1. Create temporary CSV file using OUTFILE SQL command: OUTFILE command is used to write your sql command output to the specified location. You can write the output to some files using OUTFILE when required Read more…

Moodle | SQL report example in Configurable Reports plugin

Author - Harleen Kaur
|
0 Comments
|

SQL Report in ‘Configurable Reports’ plugin provides us an easy UI to write SQL Query and draw results immediately without involving any code complications.

Suppose I want to generate my custom grades report based on some specific activities from course – Let’s say these are PreTest 1, Pretest 2 and Read more…

Moodle: Performing search through wildcard queries with ‘Like’ operator

Author - Harleen Kaur
|
0 Comments
|

‘Like’ operator of SQL can be used in the following ways in Moodle:

Using expression $DB->sql_like:
$grade_item_test = $DB->get_records_sql ( ‘SELECT * FROM {grade_items} WHERE
‘.$DB->sql_like(‘idnumber’, ‘:idnum’).’ AND courseid=:cid order by itemmodule’,
array (‘idnum’=>’test’,’cid’=> $courseid) );
Using like operator:
$grade_item_test = $DB-&gt Read more…

Postgres | JSONB data type field in PostgreSQL(9.4) and using it in CakePHP

Author - Kailash
|
0 Comments
|

JSONB (JSON Blob) datatype in Postgres is used to save JSON data. We can search on JSONB type of column after creating an index on it.

For example:

Usage in PostgreSQL:

1. Create table and index
CREATE TABLE tests
(
id integer NOT NULL,
email citext NOT NULL,
address jsonb NOT Read more…

MySQL Access Denied due to wrong column name

Author - Webner
|
0 Comments
|

MySQL access Denied for user while Username and password is correct.

I got this error when I named one of my table columns as “order” which is also a mysql keyword. When tried to rename it, I got the following error on execution.

ERROR 1045 (28000): Access denied Read more…