Home / Documentation / FAQ / Support / Download Getting Started

### Getting Started Index

> 1. Before You Begin
> 2. Creating A Database
> 3. Database Configuration

1. Before You Begin

> To use Mckoi SQL Database, you will need a JavaTM runtime environment version 1.2 or greater. Sun provides Java runtimes for Win32, Solaris and Linux from their website at http://www.javasoft.com/j2se/. IBM also provides various Java runtimes for a number of platforms at http://www.ibm.com/java/jdk/download/.

> When Java has been installed on your system, unpack the mckoi distribution file to a directory in your file system. Then you are ready to create a database and develop your database application.

2. Creating A Database

> Before you can begin development of your database application, you will need to create and configure a blank database. The database configuration file describes all of the configurable properties of the database (details of the database configuration file are covered in the next section). The software ships with a default configuration that looks for a database at path `./data` in your filesystem.

> To create a database using the default configuration with an admin username of '`admin_user`' and password '`aupass00`', go to a prompt, change to the Mckoi Database distribution directory and type:

> `java -jar mckoidb.jar -create "admin_user" "aupass00"`

> We do not advise using either this username or password in a production system. The user created here has full control over every aspect of the database so choose a username / password carefully.

> When the command has completed, a sub-directory called `data` will have been generated. This directory is used to store data from the database. A sub-directory called `log` is also generated which stores debugging and query log information.

3. Database Configuration

> When you run the `mckoidb.jar` package, it looks for a file named `db.conf` in the current directory. This file contains a number of variables that determine where the database looks for information, as well as other user-definable properties. The configuration file can be renamed and copied to a different location. If you change the configuration file location, you must supply the location when you run the database;

> `java -jar mckoidb.jar -conf [location of conf file] .....`

> You can edit the configuration file with a text editor. The default configuration file that ships with the software contains extensive comments on what each variable does.

Last Updated: Mon Aug 16 00:27:18 PDT 2004 Mckoi SQL Database Copyright © 2000 - 2004 Diehl and Associates, Inc. All rights reserved.