Kexi: Difference between revisions

    From KDE UserBase Wiki
    No edit summary
    No edit summary
    (46 intermediate revisions by 7 users not shown)
    Line 1: Line 1:
    {{Template:I18n/Language Navigation Bar|Kexi}}
    <languages />
    {|style="text-align:center"
     
    |[[Image:Kexi_form.png|250px]]||'''Rapid Application Development, for handling your database needs'''
    {|class="tablecenter vertical-centered"
    |[[Image:Kexi_form.png|350px]]||<translate><!--T:1-->
    '''Rapid Application Development'''</translate>
    |}
    |}


    ==Features==
    <translate>
    * Full visual designers for tables, queries and forms
    <!--T:9-->
    '''Kexi''' is a visual database applications creator, part of the [[Special:myLanguage/Calligra|Calligra Suite]]. 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>
     
    __TOC__
     
    <translate>
    ==Features== <!--T:2-->
     
    <!--T:3-->
    * Full visual designers for tables, queries, forms and reports
    * Running queries, support for parametrized queries
    * 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
    * Supports query design in dedicated SQL view
    * Designing and displaying relational data using combo boxes (lookup columns)
    * Designing and displaying relational data using combo boxes (lookup columns)
    * Direct data entry or import using CSV
    * 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
    * Locked down User Mode, allowing you to switch off all commands related to editing your project's design
    * Many more features
    * Scripting using JavaScript, Python or Ruby programming languages (experimental)
    * [http://kexi-project.org/wiki/wikiview/[email protected] Many more features]
     
     
    <!--T:4-->
    [http://www.kexi-project.org/ Read more] and see many more screenshots on the project's pages.


    '''[http://www.kexi-project.org/ Read more]''' and see many more screenshots on the project's pages.


    <!--T:5-->
    {|
    |[[Image:Kexi_find.png|thumb|250px]]
    |[[Image:Kexi_objects.png|thumb|250px]]
    |}
    {|
    {|
    |[[Image:Kexi_find.png|thumb|250px]] ||[[Image:Kexi_objects.png|thumb|250px]]
    |[[Image:Kexi_images.png|thumb|250px]]
    |-
    |[[Image:Kexi_properties.png|thumb|250px]]
    |[[Image:Kexi_images.png|thumb|250px]] ||[[Image:Kexi_properties.png|thumb|250px]]
    |}
    |}


    == Hints, Tips and Tutorials ==
    == Documentation, Tutorials and Samples == <!--T:6-->
    {{info|This section is under construction}}
     
    <!--T:13-->
    * [[Special:myLanguage/Kexi/Tutorials|Tutorials]]
    * Documentation
    ** [[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].
    ** <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
    * ''Samples''
    ** [http://kde-files.org/content/show.php/Simple+Database?content=23137 Simple database] (kde-files.org)
    ** [http://kde-files.org/content/show.php?content=129683 Data importing using Javascript] (kde-files.org)
    * Follow the project [http://twitter.com/kexi_project on Twitter], [http://www.facebook.com/kexi.project facebook] or [http://identi.ca/kexi identi.ca].
     
    == Presentations == <!--T:14-->
     
    <!--T:15-->
    *[http://kexi-project.org/pics/kexi_arch.pdf Kexi Architecture]
     
    <!--T:16-->
    *[http://kexi-project.org/docs/akademy/kexi-akademy-2005.pdf Kexi - Database Environment and Introduction to KDE Database Layer] (Akademy 2005)
     
    <!--T:17-->
    *[http://kexi-project.org/download/kde4/akademy2006/kexidb/kexidb.pdf Kexi - Data(base) Environment, Universal Data Layer for KDE] (Akademy 2006)
     
    <!--T:18-->
    *[http://kexi-project.org/download/kde4/akademy2007/kexi.pdf Kexi - Data(base) Environment - Introduction to universal data layer for KDE] (Akademy 2007)
     
    <!--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)
     
    <!--T:20-->
    *[http://kexi-project.org/pics/blog/2013/10years.pdf History of Kexi development] ([http://blogs.kde.org/2013/04/04/ten-years blog], 2013)


    <!--T:8-->
    [[Category:Office]]
    [[Category:Office]]
    [[Category:Kexi]]
    [[Category:Utilities]]
    </translate>

    Revision as of 19:12, 25 September 2017

    Rapid Application Development

    Kexi is a visual database applications creator, part of the Calligra Suite. 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


    Read more and see many more screenshots on the project's pages.


    Documentation, Tutorials and Samples

    Presentations