Kexi: Difference between revisions

From KDE UserBase Wiki
(New page: =Kexi= {|style="text-align:center" |250px||'''Rapid Application Development, for handling all your database needs''' |} * Full visual designers for tables, querie...)
 
No edit summary
 
(64 intermediate revisions by 9 users not shown)
Line 1: Line 1:
=Kexi=
<languages />
{|style="text-align:center"
 
|[[Image:Kexi_form.png|250px]]||'''Rapid Application Development, for handling all your database needs'''
{|class="tablecenter vertical-centered"
|[[Image:Kexi_form.png|350px]]||<translate><!--T:1-->
'''Rapid Application Development'''</translate>
|}
|}


<translate>
<!--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.
</translate>


* Full visual designers for tables, queries and forms
__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
* [http://kexi-project.org/wiki/wikiview/[email protected] Many more features]


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


<!--T:4-->
Development wiki is at https://community.kde.org/Kexi and home page is at http://www.kexi-project.org.
<!--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]]
|}
== Documentation, Tutorials and Samples == <!--T:6-->
<!--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://kexi-project.org/download/examples/Simple_Database.kexi Simple database]
** <strike>[http://kde-files.org/content/show.php?content=129683 Data importing using Javascript]</strike>
* [https://www.youtube.com/@KexiAppsBuilder KEXI YouTube Channel]
* Follow the project on:
** [https://floss.social/@KEXI Mastodon]
** [http://twitter.com/kexi_project Twitter]
** [http://www.facebook.com/kexi.project Facebook]
== 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:Kexi]]
[[Category:Utilities]]
</translate>

Latest revision as of 22:43, 5 October 2024

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
  • 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