Fw: Questions about kexi

[katrina anne arguelles]

--- On Sat, 9/5/09, katrina anne arguelles <kate_sphinx07@...> wrote:

From: katrina anne arguelles <kate_sphinx07@...>
Subject: Questions about kexi
To: kexi@...
Date: Saturday, September 5, 2009, 11:54 PM

1. Limits of the database based on:
-Max DB size
-Max table size
-Max row size
-Max columns per row
-Max Blob/Clob size
-Max CHAR size
-Max NUMBER size
-Min DATE value  
-Max DATE value-Max column name size

2. does it have native support on indexes based on:
-r/r+ tree
-hash
-expression
-partial
-reverse
-bitmap
-GiST
-GIN

3. Is it capable of the ff databse capabilities:
-union
-intersect
-except
-inner joins
-outer joins
-inner selects
-merge joins
-blobs/clobs
-common table expressions
-windowing functions

4. Does it support other objects such as:
-data domain
-cursor
-trigger
-function
-procedure
-external routines

_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

[Jaroslaw Staniek]

2009/9/6 katrina anne arguelles <kate_sphinx07@...>:
> From: katrina anne arguelles <kate_sphinx07@...>
> Subject: Questions about kexi
> To: kexi@...
> Date: Saturday, September 5, 2009, 11:54 PM
>

Dear Katrina
Kexi is not database engine itself, but a gui on top of other engines.
It has limited features because it is neither a frontend to a given
specific engine (unlike mysql admin, pgadmin, etc.). Look at filemaker
and ms access for close comparisons.
For information on features, index implementation and limits, one
needs to look at the specification of the underlying db engine, that
is mysql, postgresql or sqlite. Below I will only answer on whether
given feature is expressed in the Kexi's GUI.

> 1. Limits of the database based on:
> -Max DB size
> -Max table size
> -Max row size
> -Max columns per row
> -Max Blob/Clob size
> -Max CHAR size
> -Max NUMBER size
> -Min DATE value
> -Max DATE value-Max column name size
>
> 2. does it have native support on indexes based on:
> -r/r+ tree
> -hash
> -expression
> -partial
> -reverse
> -bitmap
> -GiST
> -GIN
>
> 3. Is it capable of the ff databse capabilities:
> -union

not in GUI

> -intersect

not in GUI

> -except

not in GUI

> -inner joins

supported in GUI

> -outer joins

not in GUI

> -inner selects

not in GUI

> -merge joins

not in GUI
> -blobs/clobs

supported in the GUI

> -common table expressions

?

> -windowing functions

supported
>
> 4. Does it support other objects such as:
> -data domain

not in GUI

> -cursor

not in GUI

> -trigger

not in GUI

> -function

not in GUI

> -procedure

partially (bindings)

> -external routines
>

not in GUI
--
regards / pozdrawiam, Jaroslaw Staniek
 Kexi & KOffice (http://www.kexi-project.org, http://www.koffice.org)
 KDE Libraries for MS Windows (http://windows.kde.org)
 http://www.linkedin.com/in/jstaniek
_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi