MySQL

Learn MySQL in simple steps

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 an introduction into dealing with relational databases, as well as providing you with a practical beginner’s tutorial for MySQL and MariaDB. [...]  

Composr 10: the new CMS from ocPortal

The UK-based CMS ocPortal has undergone a rebrand: presenting Composr 10. Following in the footsteps of ocPortal 9, this CMS offers an all-in-one solution for web presences, with no need for extensions or templates. But who is Composr 10 suited to? And how does it compare to the CMS market leaders? [...]  

Alchemy CMS: the CMS based on Ruby

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. [...]  

Magento: an introduction to the open source software

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 powerful and versatile choice for those who want to build a web store. [...]  

XAMPP tutorial: create your own local test server

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 up XAMPP as a test environment for your online project. [...]  

papaya CMS: content management for professionals

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? [...]  

Your own knowledge base with wiki software

Do you ever find yourself grabbing your smartphone mid-conversation to look something up on Wikipedia? Since the boom in mobile technology, instant access to information has become a part of everyday life, and Wikipedia is the most prominent knowledge bank of all, demonstrating the possibilities of this slimmed down CMS. But how exactly do you go about creating a wiki? [...]  

Creating backups with MySQLDumper

“Data is the new oil!”. So when it comes to online businesses, loss of data means loss of capital. Important and sensitive data should be backed up at regular intervals. Thanks to free programs such as MySQLDumper you can create MySQL database backups in minutes! Once installed, you can use the software to automatize and administer backups. [...]  

Joomla: the basics about this open source CMS

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 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? [...]