Database Archives

Advanced SQL – Indexes and Triggers

Author - Webner
|
0 Comments
|

Introduction

The SQL database provides a lot of commands and functions. With the help of them, we can manage a huge amount of data easily in the database. Following are some of the examples:

INDEX:

In the SQL database Index is like a schema object. It Read more…

MySQL: only_full_group_by issue on joins

Author - Ishpreet Kaur
|
0 Comments
|

Issue

#1055 – Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxx which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

After upgrading ubuntu 14.04 to 18.04 and MySQL 5.5 to Read more…

PHP: mysqli_multi_query stops the execution of further MySQL queries.

Author - Ishpreet Kaur
|
0 Comments
|

The mysqli_query statement

Generally, we use mysqli_query to execute Mysql queries in PHP. We can use multiple mysqli_query statements to execute multiple operations like insert, update, and select. Sometimes, we store records in more than one table during save operation at the backend, but it is Read more…

MongoDB Driver Not Found

Author - Manoj Thakur
|
0 Comments
|

Problem – Getting “Class ‘MongoDB\Driver\Manager’ not found” error while inserting some data in the collection (Laravel)

Check the following three points in order to resolve the MongoDB driver issue in Laravel:
1. PHP Module
2. MongoDB Extension
3. MongoDB Library
1. PHP Module –Read more…

Migrate MySql to MariaDB in Ubuntu 18.04

Author - Manoj Thakur
|
1 Comment
|

How to Migrate MySql to MariaDB in Ubuntu 18.04

We need to perform few steps to migrate the MySql database to Maria database, I have mentioned the steps below:

Log in to your MySql server with root password.

$ mysql -u root -p

mysql> show Read more…

How to Detect Mobile devices in php

Author - Gopi Garg

Detect mobile device php code

We often need to detect if site visitor is using an iPad, a smartphone or any other mobile device in order to change website appearance and even make it faster by reducing data load. Normally we use the media queries and Read more…

Class ‘App\Controller\Aws\S3\S3Client’ not found error in CakePHP 3.*

Author - Kailash Kumar

How to resolve “Class ‘App\Controller\Aws\S3\S3Client’ not found” error in CakePHP 3.*

Problem: Class ‘App\Controller\Aws\S3\S3Client’ not found error occurs when we are trying to create S3Client class object with given code (code copied from github):

$s3 = new Read more…

Using Laravel Eloquent ORM

Author - Umang Pasricha

Introduction to Laravel Eloquent ORM

Introduction:

Eloquent ORM is an Object Relational Mapper that interacts with the database. It is a package separate from laravel so can be used outside the laravel too. It implements active record pattern. Laravel Eloquent ORM uses Object-Oriented Read more…

How to Change Innodb storage Format for Moodle/Totara

Author - Varun Chopra

Steps to Change Innodb storage Format for Moodle/Totara

Description: You may face this problem in Totara:

Advanced Totara features require innodb Barracuda storage format

Reason: The error usually occurs because of Mysql 5.6 and below using file format “Antelope”. This format cannot handle more Read more…

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…