Database

Server migration - transfer without data loss

Moving to a new server can become a real challenge even when you’re not changing provider. You need to take care and plan your strategy well. This is the only way to ensure the integrity of the data transferred to a new server and to keep downtime to a minimum. But what exactly is server data migration? And what problems can be expected during implementation?

Microsoft Access alternatives at a glance

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

DWH | What is a data warehouse?

More and more businesses are adopting dispositive data with the aim of making strategic decisions shaped by reports, prognoses, and patterns. The database is usually supplied by an information system that functions as a central data repository, separate from a data operating system. This is known as a data warehouse, or a DWH for short. A data warehouse is a modularly built system made up of...

Finding a website host: how to search successfully

If you want to release a new web project today, you need to find the right host. Hosts have become a popular alternative for large companies, since they enable convenient outsourcing of certain work areas or data, saving company resources. But how do you know which host and which hosting package best meets your needs? And why is the provider’s security concept such a crucial criterion nowadays?

MongoDB tutorial: first steps

MongoDB is a document-based database system that competes with the more traditional relational systems. The setup and configuration is comparable to classics like MySQL, making it fairly straightforward to switch over. So how do you save and call up data with this modern software? Our MongoDB tutorial will explain the installation process and first steps to get you started on this open source...

SQL injection: Fundamentals and safeguards

There are daily reports on how security gaps in applications are exploited – because hardly a day goes by without a new gap being discovered or a known gap being closed. One attack method, which has always been based on exploiting such weak points, is called SQL injection. But what is actually hidden behind the malicious database exploitation and how can you protect your database system from it?

CRUD – the most important database operations

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

MAMP: the practical software stack for Mac OS X

If you’re developing a website, it’s important to regularly ensure that all the elements function as intended. Although there are no specific tools required for creating a basic info page with static content, it’s not possible to preview a project containing dynamic elements without some additional tools. The simplest solution is to use an all-in-one development environment like MAMP.

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

Buyer personas for optimal targeting

In online marketing today, one thing matters most: data, data, data. But what use is all this diverse information that you have been collecting and evaluating if you only use it to address a vague group of people? A better way is to identify the individuals behind the data and put the focus on them. Creating concrete buyer personas helps to ensure that your carefully planned-out marketing measures...