Database Management with Kexi/Database Basics

From Wikibooks, open books for an open world
Jump to: navigation, search

A Kexi database can hold 5 types of objects: tables, queries, forms, reports, and scripts.

A table is a grid that holds data (for instance, the patrons of a library.) The horizontal rows of the grid are called "records", and contain information on a single entity (e.g. one patron). The vertical columns hold a piece data of a certain type (e.g. a patron's phone number), and are called "fields".

A query creates sets of data pulled from one or more tables. Various operators and functions may be used to manipulate the data. For instance, in a library database, you could take the "patrons" table (which also has data on which books are checked out), and correlate it with the "books" table (which has book titles and due dates), to form a new table that holds information on all patrons that still have overdue books.

Forms provide a simple, familiar interface for editing and viewing the database.

Kexi scripts can be written in JavaScript, Python, or any other scripting language supported by Kross (the KDE scripting framework).