Introduction

An important part of the logbook design is the ability to use many different database engines, this is acheived by using Open Database Connectivity (ODBC).

You do not need to install any extra software to use the logbook - Microsoft Access (part of Windows) is the default database.

You can easily move data between databases, so you can switch to MySQL later on if you so desire.

Access
Access is designed as an end user/small workgroup database platform.

MySQL, Microsoft SQL Server
MySQL and Microsoft SQL Server are database engines used by medium and large enterprises. They provide an engine for storing the data. The advantage of an enterprise database is:

  • Greater speed,
  • Robust database design resulting in better database integrity,
  • Database replication,
  • Networking - the database can be on a computer somewhere else on your network.

MySQL and Microsoft SQL Server support large databases (> 10,000 records) far better than Access and are typically 3x to 5x faster.

Recommendation
Start with Access (the default) and switch to MySQL later on if you so decide.


Access

For simplicity and small databases Microsoft Access is fine. Microsoft Access is used by default; you do not need to install other database products.

When you start the logbook for the first time a database is automatically created using Access - you can now start adding QSO's!

Note: the Access database support is part of Windows, you do not need to install Access (part of Microsoft Office).


MySQL

MySQL is the recommended alternative to Microsoft Access – excellent performance, the price is right, it’s very easy to install and configure and offers all the features expected from a full-blown database product.

You can use MySQL on the same computer as Ham Radio Deluxe or over your network – Ham Radio Deluxe on your laptop, the MySQL database on either your web server or another computer at your home.

The MySQL download page is http://dev.mysql.com/downloads/.

On the computer where the database is located you must install:

  • MySQL Community Server (the MySQL database)
  • MySQL GUI Tools (database management program)

On the computer where the logbook is installed you must install:

  • MySQL Connector/ODBC (ODBC support)

Microsoft SQL Server Express

The free version Microsoft SQL Server Express is limited to using one processor, 1 GB of memory and a 4 GB database. This is more than enough for any logbook application.

From http://www.microsoft.com/express/sql/download/ download either:

  • SQL Server 2008 Express with Tools, or 
  • SQL Server 2008 Express with Advanced Services.

It is important that you have SQL Server Management Studio Basic - a visual database management tool for creating, editing and managing databases.

Just like MySQL Microsoft SQL Server Express can be used over the network.


Copyright 2009 by Simon Brown, HB9DRV Terms Of Use Privacy Statement