Install SQLite and create a database - database configuration/design tasks

If you are tasked with installing and configuring the database, here is a list of steps to be taken:

  1. If the dbmsqt* database driver is linked dynamically with the SQLite library, you must install the SQLite software on your computer. However, on most platforms, the driver has an embedded version of the SQLite library, and on platforms such as Linux™ as Mac OS/X, the SQLite library is usually present. The minimum required version is SQLite 3.5.9.
  2. To create a new database with SQLite, you just need to start the sqlite3 command line tool and issue an SQL statement.

    $ sqlite3-3.5.9.bin /var/data/stores.db
    sqlite> CREATE TABLE customer ( cust_id INT PRIMARY KEY, ... );
    $ .exit