4.1 Working with SQLite database

First of all you have to create tables for GNU Gama in SQLite database file (here with db extension, but you can choose your own, e.g. sqlite).

$ sqlite3 gama.db < gama-local-schema.sql

You can check created tables by following commands (fist in command line, second in SQLite command line).

$ sqlite3 gama.db
sqlite> .tables

Output should look like this:

gnu_gama_local_clusters        gnu_gama_local_descriptions
gnu_gama_local_configurations  gnu_gama_local_obs
gnu_gama_local_coordinates     gnu_gama_local_points
gnu_gama_local_covmat          gnu_gama_local_vectors

When you have created tables you can import data. One way is to process file with SQL statements.

$ sqlite3 gama.db < geodet-pc.sql

Another way can be filing database file in another program.

For using sqlite3 command you need a command line interface for SQLite 3 installed on your system (e.g. sqlite3 package).

This document was generated on February 17, 2024 using texi2html 1.82.