List of database compatible with PHP

List of  database compatible with PHP

In dynamic websites database plays important role for storing, searching, modifying or extracting data.
various database magement systems available to help your website backend we will discuss some advanced and popular database which is fully compitable with php.

PHP is open source script so best combination with php is open source database like MySQL, MariaDB, PostgreSQL.

But other commercial database like oracle, MSSQL also supports PHP.


Short description of features which is supported by all database mention in list:

RDBMS: 
Relational database management system (RDBMS) is based on the relational model as introduced by E. F. Codd.
So any database management system(DBMS) based on relational model by E. F. Codd is supports standard RDBMS.

SQL compatibility: 
SQL is Structured Query Language standard for database queries.

Cache:
Most recently accessed data from database by application program stored in computer memory is called cache. 
cache is used to minimize the amount of physical disk I/O performed by the DBMS.

B-tree: 
database tables columns indexing method to provides fast access to data in searching.

Client/Server architecture:
client performed operations from PC,smartphone web browsers on server where database exist.

Cursor:
its like a pointer for certain rows selected by query and points each row to navigate.

Stored procedures: 
Stored procedure is advanced queries written with in database.

Triggers:
Automatically execute by server on certain operations like (insert,update,delete).

Unicode: 
supports various charsets like UTF8,UCS2. 

Foreign key constraints:
In relational database model foreign key (one or more columns) of a table refers to one and only existing primary key column into another table.

Transactions:
transaction means in database execute several operations in block and ensures that all operations completed successfully.

Administration tool: 
For administering database server like phpmyadmin.


Below is list of RDBMS which is compitable with php:

These all database engine supports features described above
Except SQlite.

because SQlite is RDBMS file system unlike other database in list.

MySQL:

MySQL the most popular open source database

MySQL still most popular database management system and first choice of beginners because easy tutorials, documentation and support available.

WebSite:
link: www.mysql.com

Documentation:
link: dev.mysql.com/doc

Licence:
Open Source

Administration tool: 
phpmyadmin

MariaDB:

MariaDB open source and faster alternative for MySQL

MariaDB is open source RDBMS faster than MySQL 
MariaDB is replacing MySQL database because supports mysqli driver so you can switch from MySQL to MariaDB anytime without any modification in your MySQL queries.

WebSite:
link: mariadb.org

Documentation:
link: mariadb.com/kb/en/mariadb/documentation

Licence:
Open Source

Administration tool: 
phpmyadmin


PostgreSQL:

PostgreSQL the worlds most advanced open source database

PostgreSQL is worlds most advanced open source database management system if you planing to make new PHP application in that case you should use postgreSQL instead of MySQL or MariaDB.

WebSite:
link: www.postgresql.org

Documentation:
link: www.postgresql.org/docs

Licence:
Open Source

Administration tool:
phppgadmin

Oracle:

Oracle worlds most popular and advanced database management system

Oracle is worlds most advanced and secure database management system but it's not open source you have to buy commercial licence for oracle database. 

Oracle also own MySQL under oracle organization but MySQL still available opensource under oracle.

WebSite:
link: www.oracle.com/index.html

Documentation:
link: docs.oracle.com/en/database

Licence:
link: www.oracle.com/us/corporate/pricing/price-lists/index.html

Administration tool:
phporacleadmin


MSSQL:

Microsoft SQL server powerful dbms

Microsoft SQL server is also powerful database management system with commercial licence.

WebSite:
link: www.microsoft.com/en-in/server-cloud/products/sql-server

Documentation:
link: msdn.microsoft.com/en-us/library/ms130214.aspx

Licence:
link: www.microsoft.com/en-in/server-cloud/products/sql-server/purchasing.aspx


SQLite:

SQLite most widely deployed database engine

SQLite is an embedded SQL database engine. SQLite reads and writes directly to ordinary disk files.

Complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.  

SQLite is not as a replacement for MySQL,PostgreSQL,MariaDB etc but as a replacement for FileSystem like fopen().

WebSite:
link: www.sqlite.org

Documentation:
link: www.sqlite.org/docs.html

Licence:
Open Source


these database are fully supported php and having powerful features.




Thanks for reading if you have any question add in comments section.