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
(52 intermediate revisions by 7 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, 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>


* 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
* Scripting using JavaScript, Python or Ruby programming languages (experimental)
* [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-->
[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]]
|}
== 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://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: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