7 04, 2017

AWS | Upgrading mysql version

2018-02-22T04:56:19+00:00April 7, 2017|Database, Web Development|0 Comments

|
| ByWebner

AWS: Upgrading MySQL version Below are few step to upgrade Mysql version very easily on AWS-RDS: 1. Log on to AWS console. 2. Open AWS RDS from Database section: 3. Click on Instances: 4. Select the Database Instance which you [...]

17 03, 2017

Taking Database Backup And Moving that backup from one server to another using PHP

2018-02-05T08:49:49+00:00March 17, 2017|Database, PHP Frameworks|1 Comment

|
| ByWebner

While working on two servers, we can take the backup of database on one server using mysqldump command in php. Example : exec('mysqldump --host '.$dbhost.' --user '.$dbuser.' --password='.$dbpass." ". $dbname.' > '.$dbname.'.sql'); After creating dump of database, user can move [...]

16 03, 2017

Scaffolding in CakePHP

2017-03-16T06:01:28+00:00March 16, 2017|Database, PHP Frameworks, Web Development|0 Comments

|
| ByWebner

Scaffolding in CakePHP Application scaffolding in CakePHP is a technique that allows the developer to define and create a basic application that can create, retrieve, update and delete objects. Basically CRUD (create, Read, Update, Delete) data operations are common in [...]

20 02, 2017

Java | Hibernate best practices

2018-02-16T08:50:56+00:00February 20, 2017|Database, Java Frameworks|0 Comments

|
| ByWebner

1.  Always define hashCode() and equals() methods in your Persistent classes. 2.  Persistent class method’s equals() and hashCode() must access its fields through getter methods. It is a good practice to use accessor methods instead of direct instance variable access. [...]

25 01, 2017

Introduction to DataBase Isolation Levels

2018-02-16T07:26:42+00:00January 25, 2017|Database|0 Comments

|
| ByWebner

Introduction to DataBase Isolation Levels Transaction specifies an isolation level that defines the degree to which one transaction must be isolated from resource or data modifications made by other transactions. Isolation Levels are described in terms of side-effects of concurrent [...]

14 12, 2016

Heroku | The datasource configuration “default” was not found in database.php

2018-02-16T12:12:04+00:00December 14, 2016|Database, Mobile, PHP Frameworks, Salesforce, Web Development, Zoho|0 Comments

|
| ByWebner

Heroku throwing ERROR: “The datasource configuration "default" was not found in database.php” with database configuration already present for cakephp app. In one of our cakephp projects hosted on Heroku we used PostgreSql database. For configuring the database to connect to [...]

15 11, 2016

CakePHP | How to handle special characters (like apostrophes) in queries

2018-02-16T06:52:40+00:00November 15, 2016|Database, Mobile, PHP Frameworks, Salesforce, Web Development, Zoho|0 Comments

|
| ByWebner

Let us take an example: We have table employees with following fields: id int primary key, name varchar(50), city varchar(50) We have following records in the table: (1, isha, amr); (2, Hamlet’s, ghy); (3, éhjj, amr); 2nd and 3rd records [...]

Go to Top