|
|
MySQL5 |
|
|
PostgreSQL |
|
|
phpMyAdmin |
|
|
phpPgAdmin |
|
|
Managing databases are a key aspect of developing and maintaining dynamic web-based applications such as bulletin boards, content management systems, and online retail shops. We offer Unlimited Databases for all our hosting plans along with MySQL Database Wizard so even a novice can create and manage a database for a web site with just few clicks.
MySQL5 :
With MySQL 5 there are quite a few changes. Triggers, Stored Routines and Views are the most important features of it.
Triggers : when a particular action happens on a particular table, triggers are performed automatically on that particular table of the database. As these actions are executed automatically there is no way to request for a trigger other than call upon the action which requested it.
Stored Routines : cover both stored procedures and functions. Here the user can set a sequence of code, save in the MySQL server and call as needed. As a criterion stored functions determine and return simple values while stored procedures carry out a sequence of steps and have a tendency to not return any value.
Views : a special kind of a table built upon the structure and data of a regular table. With a view you can filter out the wanted information so to get an understanding at a glance is easy.
PostgreSQL :
PostgreSQL is an open source relational database management system (RDBMS) and its source code is freely available.
This RDBMS supports transactions, sub selects, triggers, views, foreign key referential integrity and sophisticated locking. It runs very well on Linux and supports text, images, sounds, and video, and includes programming interfaces for Perl, Python, Ruby, Tcl and Open Database Connectivity (ODBC).
phpMyAdmin :
phpMyAdmin is a set of PHP-scripts meant to conduct the administration of MySQL over the WWW. As of for now it can create and drop databases ; create, copy, drop and alter tables ; delete, edit, add fields ; execute any SQL-statement, batch-queries, manage keys on fields , load text files into tables, create and read dumps of tables, export and import CSV data, administer one single database.
phpPgAdmin :
phpPgAdmin is a set of PHP-scripts to meant to conduct the administration of PostgreSQL over the WWW. As of for now it can create and drop databases; create, copy, drop and alter tables/views/sequences/functions; edit and add fields; execute any SQL-statements, batch-queries ,manage keys on fields, load text files into tables, create and read dumps of tables, administer one single database also administer postgres users.