Database

All about SocialBlade
SocialBlade: social media data on demand
  • Web analytics

Understanding social media means understanding numbers. While internal tools such as YouTube Analytics provide a lot of numbers, it is not always easy to understand them at first glance. The third-party provider SocialBlade has thus made it their business to prepare and present data from platforms such Instagram, Twitter and YouTube in a clear and concise manner.

SocialBlade: social media data on demand
The basics for modern web development
Modern web development: the basics
  • Web development

Der Trend in der Webentwicklung führt weg von statischen Webangeboten hin zu interaktiven Inhalten. Auch wenn HTML und CSS nach wie vor das Grundgerüst einer jeden Website darstellen, greifen Webentwickler immer öfter auf serverseitige Programmiersprachen wie PHP zurück, um dynamische Webauftritte zu realisieren. Zudem bieten clientseitige Skriptsprachen wie JavaScript die Möglichkeit, eine...

Modern web development: the basics
Setting up server backups with rsync
Server Backups with rsync
  • Tools

Server backups are the best way to save vital data from your online projects and avoid losing data. A sophisticated backup strategy including all terminal devices is essential, especially in server environments. To do so, you need reliable backup programs. In addition to software solutions and online services, which are often very expensive, free applications like rsync offer an alternative.

Server Backups with rsync
MongoDB: an introduction and comparison to MySQL
MongoDB — the flexible and scalable NoSQL database
  • Web development

NoSQL databases have long since been serious competitors to classic relational database systems, like MySQL. They replace the strictly-defined storage structures of traditional models through flexible saving procedures. This allows data pools to be easily distributed onto multiple servers in order to guarantee high availability of web applications. But are these new systems really all that they’re...

MongoDB — the flexible and scalable NoSQL database
Databases
Databases – why do you need them and what kinds are there?
  • Technical matters

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

Databases – why do you need them and what kinds are there?
Set up ownCloud with Raspberry Pi
Creating a Raspberry Pi cloud server with owncloud
  • Configuration

With ownCloud software, your Raspberry Pi can be used as a private cloud, performing the same kind of tasks as clouds from major providers such as Google, Amazon, and Dropbox. Cost-effectiveness is just one of many the benefits of creating your own personal cloud; another is the privacy and security of your data. This step-by-step Raspberry Pi cloud tutorial explains how to set up ownCloud.

Creating a Raspberry Pi cloud server with owncloud
Relational Databases
The relational database model
  • Technical matters

With relational database systems, you use tables to store and manage information. This sounds simple but involves quite complex concepts such as normal forms, key relationships, and JOINs. This article will introduce the basics of the relational database model, compare its advantages and disadvantages, and delimit this type of data storage from alternative approaches, like object databases,...

The relational database model
Buyer personas for optimal targeting
Buyer personas: Getting to know your customers better
  • Web analytics

When it comes to online marketing, data is what counts most today. But what good is the information you have collected and analyzed if you address indefinite groups of people in your messages? It is better to identify the people behind the data set and focus on them. Creating concrete buyer personas helps to better align marketing measures with the target group.

Buyer personas: Getting to know your customers better
In-memory databases
In-memory databases: the storage of big data
  • Technical matters

In-memory databases enable big data to be analyzed and made available in real time. The quick access speeds are made possible by storing the data on the working memory – hence the name in-memory database. Traditional databases, on the other hand, are based on the method of storing data on the hard disk. How do in-memory databases differ from traditional database systems? And what are the go-to...

In-memory databases: the storage of big data
CRUD – the most important database operations
CRUD: the basis for data management
  • Web development

It won’t take long for those looking to get into to software development to encounter the term CRUD. The acronym stands for the typical operations used for communicating with database systems; these normally form the basis of database management. But just how are these access functions for data management actually set up? And how much of role does CRUD play when it comes to the databases’...

CRUD: the basis for data management