MySQL

papaya CMS: content management for professionals
papaya CMS: powerful and accessible
  • CMS

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?

papaya CMS: powerful and accessible
SQL INNER JOIN
INNER JOIN: definition and application
  • Technical matters

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.

INNER JOIN: definition and application
SQL JOIN
SQL JOIN – queries across multiple data tables
  • Technical matters

A major strength of the relational database model is that information is stored in separate database tables structured according to semantic relationships. This concept, known as normalization, is the basis for data storage that is as redundancy-free as possible, but requires a mechanism with which data from different tables can be merged for queries. The different JOIN types provide users with...

SQL JOIN – queries across multiple data tables
Your own knowledge base with wiki software
Your own knowledge base wiki software
  • CMS

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?

Your own knowledge base wiki software
LAMP servers – the solution for dynamic websites
LAMP Servers: an affordable solution for dynamic websites
  • Know-how

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?

LAMP Servers: an affordable solution for dynamic websites