Database

Database design, migration, optimization, repair, backup, increase website speed and performance, MySQL, MongoDB, SQL Server.

Doctrine ORM PHP Enterprises - Web Application Development India

What makes Doctrine is the best ORM?

What is ORM? ORM stands for the object relational mapping. ORM is a programming technique used to convert the data between incompatible type system in object oriented programming language. It created the “virtual object database” that can be used within the programming languages. There are many ORM’s available in the market in each technology in which some famous ORM are ActiveJPA, ActiveRecord (AR in Yii Framework) Ebean, Database objects, CakePHP, Propel and the best one Doctrine. But why Doctrine ORM [...]

Read more...
Bad Parts of NoSQL MongoDB Database

NoSQL Database – the bad parts

NoSQL (Interpreted as not only SQL) database is a non-relational and large distributed database system that enables the data for a rapid and ad-hoc organization and analysis of large data volume and disparate its data types. NoSQL databases sometimes also referred as cloud databases, non-relational databases and Big data databases and their applications. NoSQL database is generally referred by the Big Data companies to store large number of databases. But as we know every technology has its good part [...]

Read more...
Ezeelive Technologies - MySQL versus Mongodb Database

MySQL versus MongoDB Database – Which one is winner and looser based on performance

When MongoDB comes in mind then everyone start thinking that it’s just a NoSQL database but no one think that why it was developed and what its benefits over the MySQL. In this Article we will first demonstrate that what these both things are i.e MySql and MongoDB because MongoDB is little new so we have first read about its definition. MySQL Database: MySQL is a open source relational database management system (RDBMS) which is based on Structured Query Language (SQL). [...]

Read more...
MongoDB - NoSQL Database - Ezeelive Technologies

MongoDB : Why use MongoDB NoSQL Database – Pros and Cons

RDBMS or Mongo DB, What is the best option is the question of the hour. If you are from the SQL background and in need of knowing closer information and details pertaining to MongoDB then here we are to present you with some quality info here. Yes, the pros and cons of the major kind are exposed. Use it to your best potential. MongoDB NoSQL Database Pros : 1. MongoDB Database is absolutely schema less. It is one major advantage for [...]

Read more...
MySQL Regular Expression - REGEX

MySQL find values in comma separated string

MySQL is very strong, popular database stytem using for mainly in PHP MySQL web development solution. In web application development sometime developer store data in comma(,) or pipe (|) etc formats. Finding value(s) from comma seperate MySQL has REGEXP (Regular Express) function. REGEXP (mysql find values in comma separated string) function can search or filer one or multiple string value in your field data. Given below example to understand in detail how to use finding value(s) from comma seperate in [...]

Read more...
yii framework developer india - ezeelive

How to Use Two Database in Yii PHP Framework

Recently in one of Ireland based project client has requirement to use existing Microsoft SQL Server database and implement new feature and store data into MySQL database with Yii Framework along with multiple database connection. Ezeelive Technologies developer has code changes in yii framework and setup option to use two database in yii php framework. First we have install and implement microsoft sql server driver in wamp server to make in localhost environment. Now we have to connect both the [...]

Read more...
microsoft sql server with mysql in yii-framework - ezeelive technologies

Install Microsoft SQL Server Driver with WAMP

Install Microsoft SQL Server Driver with WAMP – Most of PHP developer very much familiar with MySQL Database but We talk about Microsoft SQL Server we find lack for knowledge on PHP with SQL Server even on the google and php.net official website. Even the hosting company provide Pre-installed PHP and MySQL on the Server. Here some explicit instructions for install Microsoft SQLServ Driver in WAMP 32bit with PHP 5.3 : 1. Open http://www.microsoft.com/en-us/download/details.aspx?id=20098 for Download Microsoft SQLServ PHP Driver 2. [...]

Read more...
php mysql web development india

Find and Replace Data in MySQL Database

Here the below examples To find a string in a certain field and replace it with another string in MySql Database Single Row : update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]'); Multiple Row : update [table_name] set [field_name_1] = replace([field_name_1],'[string_to_find_1]','[string_to_replace_1]'), [field_name_2] = replace([field_name_2],'[string_to_find_2]','[string_to_replace_2]') ....; Multiple Conditional : update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]') WHERE [condition]; In SQL Server : BEGIN TRANSACTION; UPDATE tbl_name SET column_name=REPLACE(column_name,'text_find','replace_this'); COMMIT TRANSACTION; Replace using RegEx in MySQL: Mysql does not support replace with Regular Expression (RegEx), but you can install lib_mysqludf_preg library to do [...]

Read more...