Encyclopedia - Databases

    MySQL
    Databases represent the powerful software that underlines contemporary websites, making the web such an enormous and flexible source of information as we know it today. The most popular open source database software on the Internet is one of the basic components of established website development platforms such as LAMP (Linux-Apache-MySQL-PHP) due to its proven reliability and speed of performance.


    MySQL create user
    The ability to create users is a basic part of the MySQL database management process and is usually executed through the MySQL command line requiring that certain privileges be assigned to the website administrator.


    MySQL create database
    Creating databases equals setting up the data 'containers' for information loaded websites. Two major MySQL database creation methods are currently practised online through the phpMyAdmin interface and via the SQL command line.


    MySQL create table
    These are the main components of MySQL databases allowing for various data to be easily structured and managed. The easiest way to create MySQL tables is through database management software like phpMyAdmin.


    MySQL alter table
    The possibility for website owners to manage the settings of MySQL tables is the key to keeping the information presented on their web pages always up to date and secure. This is possible through the command line or via the graphic interface of admin tools like phpMyAdmin.


    phpMyAdmin
    PhpMyAdmin is the most popular MySQL database administration tools, phpMyAdmin allows you to easily manage your MySQL databases.


    MySQL grant
    This refers to the possibility for server administrators to control certain user privileges over the MySQL server by restricting their access to a whole database or just limiting permissions for a specific table for security reasons.


    MySQL date strong>
    This refers to the option to store dates in MySQL. Using one of the several store data methods users can create structured websites with chronological arrangement of articles, posts and replies.


    MySQL insert
    Using the MySQL insert, users can add new records to a database table. The "insert into" command can be run via command line or using a web interface, such as PHPMyAdmin.


    MySQL Table
    MySQL stores the data in tables. The database tables consist of rows and columns. In MySQL the rows contain the actual data, while the columns specify the data type.


    MySQL database dump
    The MySQL database storage refers to the exact number of megabytes you need to store information in databases on your site or web server.


    MySQL Database Storage
    The MySQL dump is a method for creating a backup of your database data. Creating a database dump is also useful when you need to easily migrate your website to other web hosting provider.


    PostgreSQL
    As a free alternative to powerful corporate database applications, PostgreSQL offers architecture of proven quality allowing for the creation of huge databases, and boasts reliability, scalability, data integrity, and correctness.


    PostgreSQL create user
    Allowing users to have full control over the access to the objects in the database, PostgreSQL offers two methods of database user creation - by using the SQL command CREATE USER, and via the command line wrapper called createuser.


    PostgreSQL table
    The basic components of PostgreSQL databases, allowing for the stored data to be easily organized and modified, can be created through any PostgreSQL end client.


    PostgreSQL database strong>
    PostgreSQL databases store web applications' dynamic content and user information within tables and can be created via authorized access to the respective pgSQL server.


    phpPgAdmin
    This popularity gaining database management tool ensures both basic and advanced functions, among them the ability to create PostgreSQL databases and users and manage user privileges, database dumping in a variety of formats, etc.


    MySQL Statistics
    The MySQL statistics tool ensures real time monitoring of your MySQL databases activity. With such tool at hand you will be able to avoid any possible load on the server where your database driven websites are located.