MySQL

Alchemy CMS: the CMS based on Ruby

Alchemy CMS: the open source project based on Ruby on Rails

While most content management systems are based on the PHP scripting language, Alchemy CMS uses a less common but more dynamic programming language: Ruby. There are also countless add-ons available from Ruby on Rails that can help to extend your web framework to create complex projects like company websites or online shops. Find out what makes this intuitive CMS a good bet for beginners.

papaya CMS: content management for professionals

papaya CMS: powerful and accessible

The CMS, papaya, is lauded by its developers as a high performance content management system – a fully justified claim, considering the software’s wide range of smart and powerful functions. But is papaya CMS a viable option for any web project? And what exactly are this program’s strengths and weaknesses?

XAMPP tutorial: create your own local test server

XAMPP tutorial: installation and first steps

The software packet XAMPP is a collection of popular applications like the web server Apache, a leading database management system (either MySQL or MariaDB), the scripting languages PHP and Perl, and more – all together in a compact test server. Our XAMPP tutorial will take you through the installation and configuration process, with the aid of clear instructions and screenshots, to help you set...

SQL INNER JOIN

INNER JOIN: definition and application

The INNER JOIN is the most important JOIN type in the relational database model. If you want to query database tables in a group, you would usually use INNER JOINs based on equality relationships between primary and foreign keys. We will show you how to use INNER JOINs in practice, delineate the JOIN type from OUTER JOINs, and also deal with the different subtypes of INNER JOINs.

Joomla: the basics about this open source CMS

Joomla – the open source CMS in profile

Over the past few years, Joomla has established itself as one of the most popular content management systems. This is thanks to its extensive basic functions and large number of extensions developed by the Joomla community. Its functions and design modifications give Joomla projects the crucial final flourishes and even enable you to run an online shop on this open source CMS.

How does data backup work for databases?

Backing up your database

Backing up your data is a popular option for securing your database. In order to create backup copies, you need additional hardware and to install a suitable backup structure. How do you secure your own network and web server against attacks and proceed to protect your databases?

MariaDB vs. MySQL

MariaDB vs. MySQL

MySQL is the most used database management system in the world. This open source software has been available for productive use since 1995 and is generally considered a standard solution for users of relational databases. This could change in the near future. MariaDB, a community-developed fork of MySQL is catching up on its predecessor and is consequently becoming an increasingly attractive...

LAMP servers – the solution for dynamic websites

LAMP Servers: an affordable solution for dynamic websites

If independently installing the software package for your hosting project is your goal, then you might consider choosing one of the many free components out there. Sooner or later you are bound to encounter the widely used and very popular LAMP stack software bundle. But what exactly makes this package so attractive in comparison to alternative options?

Learn MySQL in simple steps

MySQL tutorial: the comprehensive guide for beginners

Along with Oracle and Microsoft SQL server, MySQL is one of the most popular management systems for relational databases. Nowadays the software developed by MySQL AB belongs to the product portfolio of the Oracle Corporation and is proprietarily marketed under a dual license. Since 2009, an open source MySQL fork, known as MariaDB, has also been available from the original developers. Here we give...

Magento: an introduction to the open source software

What is Magento

Many contemporary content management systems such as WordPress and TYPO3 can be used to design and program web stores with the help of plugins. But depending on the CMS, plugins can be pretty inconvenient to manage, making them a poor choice for larger projects. Some content management systems like Magento, however, are specially tailored for e-commerce, and therefore present a considerably more...

1