Database design, migration, optimization, repair, backup, increase website speed and performance, MySQL, MongoDB, SQL Server.
13Apr
Read more...
08Apr
MySQL find values in comma separated string
MySQL is very strong, popular database system using for mainly in PHP MySQL web development solution. In web application development sometime developer store data in the comma(,) or pipe (|) etc formats. Finding value(s) from comma separated 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 the comma...
18Dec
What makes Doctrine ORM the best in 2025?
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 an 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 is...
04Nov
MySQL versus MongoDB Database – Which one is winner and looser based on performance
When MongoDB comes to mind then everyone starts thinking that it’s just a NoSQL database but no one thinks 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 an open source relational database management system (RDBMS) which is based on Structured Query Language (SQL). MySQL virtually runs...
12Oct
MongoDB : Why use MongoDB NoSQL Database – Pros and Cons
RDBMS or MongoDB, 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 :
MongoDB Database is absolutely schema-less. It is one major advantage for the users...
17Jan
How to Use Two Databases in Yii PHP Framework
In Yii framework, using multiple databases is relatively straightforward. You can configure multiple database connections in the configuration file and then access these connections as needed throughout your application. Recently in one of Ireland based project client has the 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 connections. Ezeelive Technologies developer has code changes in Yii framework and setup option to Use Two Databases in...
15Jan
Install Microsoft SQL Server Driver in WAMP
Install Microsoft SQL Server Driver in 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 SQL Server Driver in WAMP with PHP 5.3 : 1. Open //www.microsoft.com/en-us/download/details.aspx?id=20098 for Download Microsoft SQLServ PHP Driver 2. Download SQLSRV30.EXE...
17Oct
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. To find and replace data in a MySQL database, you can use the UPDATE statement with the REPLACE() function. Here's a general example of how you can do it: SET name = REPLACE(name, 'old_string', 'new_string'): Updates the name column by replacing occurrences of 'old_string' with 'new_string'. Replace name with the name of your column and 'old_string' and 'new_string' with the...