While developing database-driven applications or building a database with bogus information for testing purpose, the traditional interfaces for adding values to each table are often utterly complex or require too many mouse-clicks per entry. Wouldn’t it be nice to import a plain spreadsheet created in OpenOffice Calc or Excel straight into your database? This article will introduce a technique making it possible.
Apparently my fellow blogger Lasse has tagged me in this popular (but childish) blog game called 8 random facts. The first rule of 8 random facts is not that you do no talk about 8 random facts, instead the first rule states that you should give away the rules:
For the past term I have been taking a specialized course in which the teacher was kind enough to combine a course called programming A and another one called database management. The idea was to use PHP together with MySQL to put together various assignments. After solving a couple of assignments I started out working on the main project, a webshop with basic features. With one week to go I think that I have learnt several things from the course so far:
In this post I will summarize my own personal backup approach, which might give you some fresh ideas about backups, especially if you are a Linux user.