Kexi: Difference between revisions

    From KDE UserBase Wiki
    No edit summary
    No edit summary
    Line 8: Line 8:
    <translate>
    <translate>
    <!--T:9-->
    <!--T:9-->
    '''Kexi''' is a visual database applications creator. It can be used for designing database applications, inserting and editing data, performing queries, and processing data. Forms can be created to provide a custom interface to your data. All database objects – tables, queries, forms, reports – are stored in the database, making it easy to share data and design.
    '''KEXI''' is a visual database applications creator. It can be used for designing database applications, inserting and editing data, performing queries, and processing data. Forms can be created to provide a custom interface to your data. All database objects – tables, queries, forms, reports – are stored in the database, making it easy to share data and design.
    </translate>
    </translate>


    Line 48: Line 48:
    * [[Special:myLanguage/Kexi/Tutorials|Tutorials]]
    * [[Special:myLanguage/Kexi/Tutorials|Tutorials]]
    * Documentation
    * Documentation
    ** [[Special:myLanguage/Kexi/Handbook|The Kexi Handbook]] for '''Kexi 2'''
    ** [[Special:myLanguage/Kexi/Handbook|The KEXI Handbook]] for '''KEXI 2'''
    ** This Handbook is also found [http://docs.kde.org/development/en/calligra/kexi/index.html on docs.kde.org].
    ** This Handbook is also found [http://docs.kde.org/development/en/calligra/kexi/index.html on docs.kde.org].
    ** <strike>[[Special:myLanguage/Kexi/Cheat Sheet|Kexi Cheat Sheet]]</strike> (planned)
    ** <strike>[[Special:myLanguage/Kexi/Cheat Sheet|KEXI Cheat Sheet]]</strike> (planned)
    ** Note: scripting is undocumented and experimental, please read [http://community.kde.org/Kexi/Plugins/Scripts#Documentation] for more information
    ** Note: scripting is undocumented and experimental, please read [http://community.kde.org/Kexi/Plugins/Scripts#Documentation] for more information
    * ''Samples''
    * ''Samples''
    Line 60: Line 60:


    <!--T:15-->
    <!--T:15-->
    *[http://kexi-project.org/pics/kexi_arch.pdf Kexi Architecture]
    *[http://kexi-project.org/pics/kexi_arch.pdf KEXI Architecture]


    <!--T:16-->
    <!--T:16-->
    *[http://kexi-project.org/docs/akademy/kexi-akademy-2005.pdf Kexi - Database Environment and Introduction to KDE Database Layer] (Akademy 2005)
    *[http://kexi-project.org/docs/akademy/kexi-akademy-2005.pdf KEXI - Database Environment and Introduction to KDE Database Layer] (Akademy 2005)


    <!--T:17-->
    <!--T:17-->
    *[http://kexi-project.org/download/kde4/akademy2006/kexidb/kexidb.pdf Kexi - Data(base) Environment, Universal Data Layer for KDE] (Akademy 2006)
    *[http://kexi-project.org/download/kde4/akademy2006/kexidb/kexidb.pdf KEXI - Data(base) Environment, Universal Data Layer for KDE] (Akademy 2006)


    <!--T:18-->
    <!--T:18-->
    *[http://kexi-project.org/download/kde4/akademy2007/kexi.pdf Kexi - Data(base) Environment - Introduction to universal data layer for KDE] (Akademy 2007)
    *[http://kexi-project.org/download/kde4/akademy2007/kexi.pdf KEXI - Data(base) Environment - Introduction to universal data layer for KDE] (Akademy 2007)


    <!--T:19-->
    <!--T:19-->
    *[http://kexi-project.org/pics/akademy/2011/helsinki_sprint/calligra_sprint_2011-11-kexi-intro-for-devs.pdf Kexi: Introduction for KDE Contributors] (2nd Calligra Sprint, 2011)
    *[http://kexi-project.org/pics/akademy/2011/helsinki_sprint/calligra_sprint_2011-11-kexi-intro-for-devs.pdf KEXI: Introduction for KDE Contributors] (2nd Calligra Sprint, 2011)


    <!--T:20-->
    <!--T:20-->

    Revision as of 00:10, 11 March 2018

    Rapid Application Development

    KEXI is a visual database applications creator. It can be used for designing database applications, inserting and editing data, performing queries, and processing data. Forms can be created to provide a custom interface to your data. All database objects – tables, queries, forms, reports – are stored in the database, making it easy to share data and design.

    Features

    • Full visual designers for tables, queries, forms and reports
    • Running queries, support for parametrized queries
    • Supports SQLite, MySQL, PostgreSQL and MS SQL Server databases
    • The only multiplatform graphical tool importing data from MS Access databases
    • Supports query design in dedicated SQL view
    • Designing and displaying relational data using combo boxes (lookup columns)
    • Direct data entry or import using CSV format
    • Locked down User Mode, allowing you to switch off all commands related to editing your project's design
    • Scripting using JavaScript, Python or Ruby programming languages (experimental)
    • Many more features


    Development wiki is at https://community.kde.org/Kexi and home page is at http://www.kexi-project.org.


    Documentation, Tutorials and Samples

    Presentations