What is Chrome 68?

Early next month, Chrome 68 will be launched and the new browser will distrust all webpages that do not have HTTPS encryption as “not secure”. This is...

10 free Drupal themes you should know about

  • CMS

Acting as a template for web presences, themes can change your website’s appearance in the blink of an eye. If Drupal is your chosen CMS, you’ll never be short of layout options. When it comes to free Drupal themes, users are spoilt for choice. The hard part is knowing where to start! There are a lot of deciding factors here, including your knowledge of web design and what type of website you’re...

A New Way to WordPress: 4 Things to Know About Gutenberg

  • CMS

As the launch of WordPress 5.0 approaches, website owners and developers are raising questions about the new Gutenberg plugin. In four easy points, this article provides a detailed overview of the usability, new features and technicalities of WordPress’ Gutenberg plugin, read on to find out more about this exciting update.

HTTP 408: how to fix the timeout error

Permanent availability is one of the most important things when it comes to a website. However, even the best technical conditions do not offer a 100% guarantee that a website will constantly run smoothly. Connection errors like HTTP error 408 regularly present websites with minor and major difficulties, especially since the causes are often found on the client side. Our guide looks at the causes...

Databases – why do you need them and what kinds are there?

Databases are a fundamental part of our information society today. They organize electronic data and regulate access to it. Databases have a wide range of applications, both commercial and private. Each database system has a database management system based on a specific database model. While the history of the database began with the hierarchical model, today the relational database model is the...

ProcessWire: the open source CMS for individual websites

  • CMS

Do you want to create web pages and have as much freedom as you need? WordPress may be the undisputed market leader, but it also contains unsafe plugins that make attacks easier for hackers or greatly increase loading times. If you are looking for a highly flexible solution that is relatively easy to get to grips with, especially for users with some previous experience, then ProcessWire may be the...

What is Chrome 68?

Early next month, Chrome 68 will be launched and the new browser will distrust all webpages that do not have HTTPS encryption as “not secure”. This is a big step in the recent trend towards emphasizing user safety on the internet, a not entirely selfless strategy from Google. In this guide, we will explain what changes will be made, why they are happening, and how you can prepare your website...

Less redundancy thanks to database normalization

Redundancies occur when various details are combined in a single database table. These redundancies use up storage capacity and prevent efficient data processing. The relational database model offers strategies for splitting datasets among several linked tables, in a process called database normalization. Find out what it’s all about with practical examples.

SQL OUTER JOIN

OUTER JOINs are queries that take place across several database tables. There are LEFT OUTER JOINs, RIGHT OUTER JOINs and FULL OUTER JOINs. Each of these JOIN types has a larger result set than the INNER JOIN. But what exactly is the difference between the individual types? Here, we will distinguish OUTER JOINs from INNER JOINs, compare the different subtypes of OUTER JOINs and explain how they...

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.

SQL JOIN – queries across multiple data tables

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