Category: Database

In this post, we will be backing up and restoring database easily using PHP. The basic idea is to dump database table structure and data into a SQL file for backing up. While restoring, the SQL queries dumped into the file are executed one after another.

By creating correct indexes for tables based on the queries your applications use, you can improve performance of your application. In this post, I'll discuss on basics of Database Indexes and best practices to follow.

Sometimes we need to insert large data set into database table. Using one INSERT statement per row is quite inefficient. Instead of this, we can assemble one INSERT statement with multiple rows. In this article, I am going to show how to perform bulk insert into MySQL table using PHP.

DBMS is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. DBMS allow the definition, creation, querying, update, and administration of databases. Some of the popular DBMSs are MySQL, Oracle, MariaDB, Microsoft SQL Server, PostgreSQL, MongoDB.