2009/9/6 katrina anne arguelles <[email protected]>: > From: katrina anne arguelles <[email protected]> > Subject: Questions about kexi > To: [email protected] > 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 [email protected] https://mail.kde.org/mailman/listinfo/kexi
