A day of coding

All software developers have to deal with it. Version control software. Today I decided to play a bit with installing my own dedicated SVN (subversion) server. This, hopefully brief, step plan will help you do the same.

Downloading all needed software

Before you can continue with the tutorial you will have to get the following things:

• A ‘virtual’ computer to install you dedicated SVN server on,
  I used VMWare to emulate a server, but you could also use an old computer that you have as a spare.
• Download Debian from http://www.debian.org/devel/debian-installer/,
  The reason for picking Debian is easy. It’s supposed to be a stable and powerful Linux OS. (You can pick the netinst CD image)

That’s all you will need. But be aware that we will be downloading various other packages (software applications) later on. So make sure you have your network prepared.

I’ve recently gotten a few questions on the issue of multilingual website implementation and the usage of a language indicator (eg: nl, uk, de). So today it’s time to look into best practice, both from the visitors point of view as well as that of the programmer.

Visitors like confirmation

That was easy. I just summed up the reason why it could be important for your visitor to include a language indicator in the URL. If I am browsing your website I would like to know what language the information is that I can expect. And I mean all of the information, not just this page. Because of that reason I would prefer to see a URL like:

Strange title isn’t. Is there such a thing as basic SQL(Structured Query Language). Lets try and find out. I will be covering some basics, thus creating a simple table. Making some basic queries and basics on T-SQL (Transact SQL).

Why use databases

Best to begin with a little story I suppose. Why would you want to use a database? Well it’s pretty easy. Databases give you the capability to store massive amounts of data in a orderly manner. With easy and structured access. I can hear those lovers of files shouting that you can do the same with files. I’ll grant them this, files can store information in the same way. But when it comes to quick access or easy manipulation then nothing beats databases.