Relational databases

What is a database? You could compare it to a wholesale arena, where certain products are stored on certain shelves. Those shelves would be tables and the products would be data. Thanks to databases it is possible to gather and popularise information quickly, e.g. a basket in an online store.

In our work, we use relational database management system based on an open-source licence. Depending on one’s needs we use MySQL and PostgreSQL.

MySQL

The most popular database used in Internet solutions. Its success is closely connected to the PHP language popularity. It is spread on GPL licence terms. TYPO3 and Magento systems are supporting this database by default.

PostgreSQL

A database created for more challenging solutions. It contains mechanisms known from larger systems, e.g. Oracle or MySQL. Is uses an advanced transaction mechanism. It is fully compatible with SQL standard. Spread on BSD licence terms.

Technology

Macopedia in social network:
Become friends!