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

Raspberry Pi at a glance: 10 great Raspberry Pi projects

Raspberry Pi is an inexpensive small form factor PC that can behave like a standard computer in many respects. Users can use this innovative mini-computer for all kinds of functions, from setting up an operating system to surfing the web, to using it as a server or a media center, and much more besides. Discover 10 interesting Raspberry Pi projects to try out at home. [...]  

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 operation that MS Access offers? [...]  

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

Set up ownCloud with Raspberry Pi

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

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

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’ programming language and language environment? [...]  

What are quotas?

Did you encounter the word 'quota' from your web space provider or as part of mail hosting and wonder what is it? When does this storage limit come into play? We show you when and why quotas are used and how to differentiate between the different types. [...]  

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 cracked up to be? Or is there still a case to be made for using relational storage systems? [...]