Database

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.   

MongoDB: an introduction and comparison to MySQL

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

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

Your own knowledge base with 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?   

The basics for modern web development

The trends driving web development are moving away from static web presences and heading increasingly in the direction of interactive content. Even though languages like HTML and CSS still rule the roost, a growing number of developers prefer the server-side programming language, PHP, for dynamic websites. Client-side script languages like JavaScript make it possible for a site to react to user [...]   

Setting up server backups with rsync

A server backup is the best method for securing the data of your online projects, thereby preventing any damaging losses. Server environments are especially in need of cleverly devised backup strategies that take every type of device into account. Here, backup programs become essential. Free applications, like rsync, offer reliable and compelling alternatives to their expensive conventional [...]