If you work in web development or routinely analyze data, you’re probably familiar with SQL. It might be a surprise to hear that the domain-specific, declarative language is most-closely related to the design language CSS. Built on the mathematical theory of “relational algebra”, SQL brings some special features to the table. We’ll show you how the language works using examples.
There is much more going on behind WordPress blogs than the average visitor is aware of. In addition to texts, pictures and other graphics, it is primarily the behind-the-scenes aspects like plugins and user settings that make the site what it is. All of these features have to be taken into account when migrating from A to B. Thanks to tools like migration plugins, moving your WordPress blog to a...
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...
Do you know any content management systems without databases? These simple CMS systems are usually free, can be downloaded online, and can often be extended and adjusted to the user’s needs. Despite these advantages, are simple CMS platforms really a serious alternative to the classic CMS giants Drupal, Joomla and Typo3, which are linked to databases such as MySQL or MariaDB?
The PostgreSQL database management system, also known to many as Postgres, has many decades of development behind it. It originally started as a project at Berkeley University in California. Today, the open source database continues to defy solutions from commercial competitors, since the development team is constantly working on its functionality and performance. But what exactly is PostgreSQL?...
Raspberry Pi is an inexpensive micro-computer that can behave like a standard computer in many respects. The innovative mini device can be used for a wide range of tasks - from setting up an operating system to surfing the web, to using it as a server or a media center. Discover these interesting Raspberry Pi projects to try out at home.
MS Access is widely used office software and enables people with no prior programming knowledge to work with databases. The license for the program, however, is not exactly cheap. Several free alternatives to Microsoft Access promise to do essentially the same thing. But which are the best Microsoft Access alternatives? And can they actually keep up with the range of functions and standard of...
For enterprise IT, the database software Oracle Database is one of the market leaders. The relational database management system supports companies by storing, processing, and evaluating data in a clear and tabular way. Find out here how Oracle Database works. We also reveal the software’s advantages and disadvantages.
Open source databases are a much cheaper and often very reliable alternative to the well-known commercial providers. Even large corporations therefore now rely on these free options. But which system is suitable for which purpose? How do open source databases perform in terms of handling large amounts of data? We created a comparison of popular databases.
Databases are usually based on rows of data. Columnar databases turn this system on its side. Instead of saving each entry one after the other, in a columnar database entries are stored category by category. This results in a decisive speed advantage when working with massive quantities of data. But how exactly does a column-oriented DBMS work?
Provide powerful and reliable service to your clients with a web hosting package from IONOS.
View packages
