| -!!Related & interesting projects |
| +!!!Related & interesting projects |
| |
| +@@@ |
| + |
| +!!Projects Reused By Kexi |
| * [KDElibs for win32|http://wiki.kde.org/tiki-index.php?page=KDElibs+for+win32] (formerly [Qt-KDE Wrapper|http://iidea.pl/~js/qkw/]) - Kexi is the very first larger application available also __on win32__ thans to this project. |
| -* [SQLite Project|http://www.sqlite.org/index.html] - db engine that is planned to be used as embedded engine for Kexi. See also [SQLite Wiki docs|http://www.sqlite.org/cvstrac/wiki]. |
| -** [SQLite ODBC driver|http://www.ch-werner.de/sqliteodbc/] |
| -** [Client/Server Extension for SQLite|http://www.it77.de/sqlite/sqlite_sockets.htm] |
| -** [SQLiteServer|http://sqlabs.net/index.shtml?sqliteserver] - other server embedding SQLite engine (closed source) |
| -** [SQLite Driver for OpenOffice.org|http://dba.openoffice.org/drivers/sqlite/index.html] - very simple implementation, compared to KexiSQL :) |
| -** [SQLitePlus|http://www.sqliteplus.com/] - commercial c++ library for SQLite |
| -** [SQLiteSecure - Encryption Extension for SQLite|http://www.voidbrain.com/sqlitesec.html] - could be probably reused for Kexi |
| -* DB Abstraction layers |
| -** Relational |
| -*** [ADOdb|http://php.weblogs.com/ADODB] - DB abstraction library, for PHP, although it has some features similar to KexiDB as handling metadata. Many [drivers|http://phplens.com/lens/adodb/docs-adodb.htm#drivers] included. |
| -*** [QtSQL|http://www.mobiustech.net/qtsql/] - GUI database frontend for MySQL,PostgreSQL and ODBC databases. |
| -** Object based |
| -*** [SQLObject|http://sqlobject.org] - an object-relational mapper for Python. Handles few database backends including SQLite. Interested because some sort of mapping will be performed in Kexi Scripting Engine. |
| -*** [db4objects|http://www.db4objects.com] - Dual licensed (GPL/Commercial) native Java or .NET open source object database engine - takes care about (de)serializing objects. |
| +* [SQLite|http://www.sqlite.org/index.html] - db engine used as embedded engine for Kexi. See also [SQLite Wiki docs|http://www.sqlite.org/cvstrac/wiki]. |
| + |
| +!!Projects Related to SQLite |
| +* [SQLite ODBC driver|http://www.ch-werner.de/sqliteodbc/] |
| +* [Client/Server Extension for SQLite|http://www.it77.de/sqlite/sqlite_sockets.htm] |
| +* [SQLiteDBMS|http://sqlitedbms.sourceforge.net] - a database management server for SQLite. It allows an sqlite3 process to be accessed via a TCP/IP network; provides Extended SQL, SSL, basic authentication, query caching, WebDAV, access control, and replication. '''Can bring sqlite network layer for to Kexi.''' |
| +* [SQLiteServer|http://sqlabs.net/index.shtml?sqliteserver] - other server embedding SQLite engine (closed source) |
| +* [SQLite Driver for OpenOffice.org|http://dba.openoffice.org/drivers/sqlite/index.html] - very simple implementation, compared to KexiSQL :) |
| +* [SQLitePlus|http://www.sqliteplus.com/] - commercial c++ library for SQLite |
| +* [SQLiteSecure - Encryption Extension for SQLite|http://www.voidbrain.com/sqlitesec.html] - could be probably reused for Kexi |
| +* [SQLite: Contributed Files|http://www.sqlite.org/contrib], LiteWrap by Ben.Clewett is especially interesting as an idea. |
| +* [SQLite Database Browser|http://sqlitebrowser.sourceforge.net/] free, public domain, open source visual tool used to create, design and edit SQLite files. |
| * [SQLiteManager|https://sourceforge.net/projects/sqlitemanager/] - a multilingual web based tool to manage [SQLite|http://sqlite.org/] database. Even KexiDB compatibility exists! |
| -* KDE database frontends |
| -** [KSqlShell|http://www.ksqlshell.de] - graphical MySQL and PostgreSQL database shell for KDE |
| -** [KMySQLAdmin|http://www.alwins-world.de/programs/kmysqladmin/] MySQL interface for KDE |
| -** [KSqlAnalyzer|http://www.kpage.de/en/] - a tool for easy accessing the data of a MS-SQL-Database. It's a KDE GUI built on top of FreeTDS project. |
| -** [KPoGre|http://kpogre.sourceforge.net/index.html] - a KDE postgresql frontend that uses libpqxx as our pgsql driver. |
| -** [Rekall|http://www.thekompany.com/products/rekall] - a tool to extract, display and update data, it does forms and reports and scripting; [GPL-ed Rekall|http://www.rekallrevealed.org] is also available. |
| -* Gnome stuff |
| -** [Gnome DB Project|http://www.gnome-db.org] |
| -** [Glom|http://www.glom.org/] - GNOME's [FileMaker|http://www.filemaker.com/]-like app for designing and editing PostgreSQL tables ([Screenshots|http://www.glom.org/screenshots/]). |
| +* '''[Sqliteman|http://sqliteman.com]''' is one of the best developer's and/or admin's GUI tool for SQLite 3. |
| +* [uSQLite|http://users.libero.it/irwin/] - a network wrapper for SQLite. May be reused by Kexi. |
| +* ''Full text search for SQLite'' - the goal is to add full text index support to sqlite3 databases. Nice addition for Kexi/KexiDB. [ft3 @ sourceforge|http://sourceforge.net/projects/ft3/], [A draft onm sqlite.org|http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex&t=1147987382], [FullTextIndex @ sqlite.org|http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex] |
| +* [SQLite in Google Gears|http://code.google.com/apis/gears/api_database.html] - Google Gears uses the open source SQLite database system. The Database module provides browser-local relational data storage to JavaScript web application. Gears also includes an SQLite extension [fts2|http://www.sqlite.org/cvstrac/wiki?p=FtsTwo] for "Full-Text Search". |
| +* [SQLite as unified storage backend for Mozilla 2|http://wiki.mozilla.org/Mozilla2:Unified_Storage] for storing and searching through data for all Mozilla components and extensions. "SQLite will be the back end for the unified store. Because it implements a SQL engine, we get querying for free, without having to invent our own query language or query execution system." |
| +* [Redland RDF's (Resource Description Framework) storage|http://librdf.org/docs/api/redland-storage.html] (http://librdf.org) uses SQLite (among others) for persistent storage. Redland storage is [used|http://nepomuk-kde.semanticdesktop.org/xwiki/bin/view/Main/Soprano] (QRDF) by [Soprano|http://sourceforge.net/projects/soprano], which in turn is used by [NEPOMUK-KDE|http://nepomuk-kde.semanticdesktop.org/xwiki/bin/view/Main/], part of [Nepomuk Semantic Desktop project|http://nepomuk.semanticdesktop.org/]. |
| + |
| +!!Projects Related to MS Access |
| +* [DBToFile|http://patrice.dargenton.free.fr/dbtofile/dbtofileeng.html] - A Microsoft Access Database Backup Engine. Possible reusability for Kexi's "Total MSA Importer". However, it only reads database schema and SQL strings, not forms or reports. |
| + |
| +!!Projects Related to PostgreSQL |
| +* [gppl's nest|http://gppl.moonbone.ru/] - a patch which allows PgSQL to make hierarchical queries a la Oracle do. |
| + |
| + |
| +!!Database Abstraction layers |
| + |
| +!Relational Database Abstraction Layers |
| +* [ADOdb|http://php.weblogs.com/ADODB] - DB abstraction library, for PHP, although it has some features similar to KexiDB as handling metadata. Many [drivers|http://phplens.com/lens/adodb/docs-adodb.htm#drivers] included. |
| +* [QtSQL|http://www.mobiustech.net/qtsql/] - GUI database frontend for MySQL,PostgreSQL and ODBC databases. |
| +* [Mono Database Access|http://www.mono-project.com/Database_Access] wiki |
| + |
| +!Object-based Database Abstraction Layers |
| +* [SQLObject|http://sqlobject.org] - an object-relational mapper for Python. Handles few database backends including SQLite. Interested because some sort of mapping will be performed in Kexi Scripting Engine. |
| +* [db4objects|http://www.db4objects.com] - Dual licensed (GPL/Commercial) native Java or .NET open source object database engine - takes care about (de)serializing objects. |
| +* [SQLAlchemy|http://www.sqlalchemy.org/] is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. |
| +** [Migrate|http://erosson.com/migrate/docs/], SQLAlchemy schema change management, inspired by Ruby on Rails' migrations, provides a way to deal with database schema changes in SQLAlchemy projects. |
| +** [Elixir|http://elixir.ematia.de/] is a declarative layer on top of SQLAlchemy. |
| +* [Spring|http://www.springframework.org/] - open source web application framework for the Java platform; among others includes Data access framework: working with relational database management systems on the Java platform using JDBC and Object-relational mapping tools providing solutions to technical challenges that are reusable in a multitude of Java-based environments. |
| + |
| +!!Open Source Database Connection Libraries |
| +Things that might be useful for a KexiDB driver or Migration plugin |
| +* __[MDB Tools|http://mdbtools.sourceforge.net] - tools for direct reading and writing data stored in MS Access database files, it will be good metod for extending Kexi's data-exchange capabilities. See also: [Article on MDB Tools|http://otn.oracle.com/pub/articles/gagne_access.html], Currently used by [Kexi's MDB Migration plugin|MDBDriver].__ |
| +* __[libpqxx|http://pqxx.org] - C++ client API for [PostgreSQL|http://www.postgresql.org], currently used for KexiDB PostgreSQL driver.__ |
| +* [pxlib|http://pxlib.sourceforge.net/pxview.html] - C Library to read Paradox Database files (GPL) - usable for Kexi Paradox import/export filter |
| +* [FreeTDS|http://www.freetds.org] - libraries for Unix and Linux that allow to natively talk to MS SQL Server and Sybase databases (related to MDB Tools) |
| +* [libodbc++|http://sourceforge.net/projects/libodbcxx/] - c++ class library for accessing SQL databases via ODBC |
| +*[Xbase|http://linux.techass.com/projects/xdb/] - a collection of specifications, programs, utilities and a C++ class library for manipulating Xbase type datafiles and indices |
| +* [UNITY|http://www.bell-labs.com/project/wwexptools/unity/] - relational db in a flat file |
| +* [DBTCP|http://www.fastflow.it/dbftp] is a proxy server for ODBC connection, so it is possible to hide multiple virtual ODBC connections inside one physical ODBC connection (May be valuable for further Kexi research) |
| +* [SQL Relay|http://sqlrelay.sourceforge.net] is a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting most database servers. This may be integrated with Kexi (hmm, 5.0 ? :) ) environment. |
| +* [SOCI|http://soci.sourceforge.net/] is a database access library for C++ that makes the illusion of embedding SQL queries in the regular C++ code, staying entirely within the Standard C++. Supports Oracle, PostgreSQL, MySQL, SQLite. __Something we considered for KexiDB API__. |
| + |
| +!!Database Development/Administering Tools and Environments |
| + |
| +!Open Source: KDE-based |
| +* [KSqlShell|http://www.ksqlshell.de] - graphical MySQL and PostgreSQL database shell for KDE |
| +* [KMySQLAdmin|http://www.alwins-world.de/programs/kmysqladmin/] MySQL interface for KDE |
| +* [KSqlAnalyzer|http://www.kpage.de/en/] - a tool for easy accessing the data of a MS-SQL-Database. It's a KDE GUI built on top of FreeTDS project. |
| +* [KPoGre|http://kpogre.sourceforge.net/index.html] - a KDE postgresql frontend that uses libpqxx as our pgsql driver. |
| +* [Rekall|http://www.thekompany.com/products/rekall] - a tool to extract, display and update data, it does forms and reports and scripting; [GPL-ed Rekall|http://www.rekallrevealed.org] is also available. |
| +* [Umbrello UML Modeller|http://uml.sourceforge.net] - Unified Modelling Language diagram programme for KDE. Could be integrated with Kexi database design capatibilities, e.g. Entity Relationship designer: http://uml.sourceforge.net/screenshots/umbrello-entiry-relationship.png |
| +* [DataKiosk|http://extragear.kde.org/apps/datakiosk/] is a JuK-like database interface tool for generic SQL databases. QUite similar interface to planned Kexi's Final Mode. |
| +* [RKWard|http://rkward.sourceforge.net/] is meant to become an easy to use, transparent frontend to the R-language, a very powerful, yet hard-to-get-into scripting-language with a strong focus on statistic functions. Its capatibilities could be adopted to interoperate with Kexi data sources. |
| + |
| +!Open Source: Qt-based |
| +* [HBasic|http://hbasic.sourceforge.net] - integrated development environment with database support. |
| +* [DBACompanion|http://homepage.internet.lu/torsten/] - a graphical administration tool for Oracle databases. Looks like good starting point for adding db driver and import/export driver for Oracle. |
| + |
| +!Proprietary: Qt-based |
| +* [Data Architect|http://www.thekompany.com/products/dataarchitect] - a tool for designing databases |
| + |
| +!Open Source: Other |
| +* New GUI tools from MySQL: |
| +** [MySQL Administrator|http://www.mysql.com/products/administrator/] |
| +** [MySQL Query Browser|http://www.mysql.com/products/query-browser/] |
| +* A great page with many [*SQL-ish projects|http://www.rot13.org/~dpavlin/sql.html]; [exportSQL|http://www.rot13.org/~dpavlin/projects/sql/exportSQL3.txt] has a special value in Kexi context: MS Access module which exports Access Database into MySQL, mSQL and PostgreSQL. This is __exactly__ what we have planned for Kexi migration tools suite. |
| +* [IBAccess|http://www.ibaccess.org/] is an Interbase client application, that allows the users or administrators the use of a intuitive interface to Interbase/Firebird database servers and Interbase/Firebird database files and objects. |
| +* [phpFlashMyAdmin|http://www.tufat.com/s_flash_phpmyadmin.htm] includes all of the significant table administration features of phpMyAdmin, but without the annoyance of page refreshes (demo available). |
| + |
| +!Open Source: GNOME |
| +* [Gnome DB Project|http://www.gnome-db.org] |
| +* [Glom|http://www.glom.org/] - GNOME's [FileMaker|http://www.filemaker.com/]-like app for designing and editing PostgreSQL tables ([Screenshots|http://www.glom.org/screenshots/]). |
| + |
| +!Proprietary |
| * [DBDesigner|http://www.fabforce.net/dbdesigner4/index.php] - visual database design system that integrates database design, modeling, creation and maintenance |
| * [DBManager|http://www.dbtools.com.br/EN/index.php] - MySQL and PostgreSQL management win32 app, also supports SQLite |
| -* [HBasic|http://hbasic.sourceforge.net] - integrated development environment with database support. |
| -* [TOra|http://www.globecom.se/tora] - Toolkit For Oracle |
| * [TOAD|http://www.quest.com/toad] - provides Windows—based PL/SQL development and administration |
| -* A great page with many [*SQL-ish projects|http://www.rot13.org/~dpavlin/sql.html]; [exportSQL|http://www.rot13.org/~dpavlin/projects/sql/exportSQL3.txt] has a special value in Kexi context: MS Access module which exports Access Database into MySQL, mSQL and PostgreSQL. This is __exactly_ what we have planned for Kexi migration tools suite. |
| -* Database connection libraries. Things that might be useful for a KexiDB driver or Migration plugin: |
| -** [MDB Tools|http://mdbtools.sourceforge.net] - tools for direct reading and writing data stored in MS Access database files, it will be good metod for extending Kexi's data-exchange capabilities. See also: [Article on MDB Tools|http://otn.oracle.com/pub/articles/gagne_access.html], [Kexi's MDB Migration plugin|MDBDriver]. |
| -** [libpqxx|http://pqxx.tk] - C++ client API for [PostgreSQL|http://www.postgresql.org], currently used for KexiDB PostgreSQL driver |
| -** [pxlib|http://pxlib.sourceforge.net/pxview.html] - C Library to read Paradox Database files (GPL) - usable for Kexi Paradox import/export filter |
| -** [KSpread CSV import filter|http://webcvs.kde.org/koffice/filters/kspread/csv/] |
| -** [FreeTDS|http://www.freetds.org] - libraries for Unix and Linux that allow to natively talk to MS SQL Server and Sybase databases (related to MDB Tools) |
| -** [libodbc++|http://sourceforge.net/projects/libodbcxx/] - c++ class library for accessing SQL databases via ODBC |
| -** [dBASE Reader and Converter|http://anubisnet.sourceforge.net/products/dbf] - can be usable for import/export plugins |
| -** [UNITY|http://www.bell-labs.com/project/wwexptools/unity/] - relational db in a flat file |
| -* Reporting |
| -** [ReportLab|http://reportlab.org/] - Open Source toolkit for creating good-looking reports in PDF. Let's see if this can be reused in Kexi? |
| -** [Agata Report|http://www.agata.org.br/us/index.php] - mature reporting tool (LGPL), it's good idea to see how things are made there |
| -** [BusinessObjects|http://businessobjects.com/] - Crystal Reports and so on. |
| -* [DBTCP|http://www.fastflow.it/dbftp] is a proxy server for ODBC connection, so it is possible to hide multiple virtual ODBC connections inside one physical ODBC connection (May be valuable for further Kexi research) |
| -* [SQL Relay|http://sqlrelay.sourceforge.net] is a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting most database servers. This may be integrated with Kexi (hmm, 5.0 ? :) ) environment. |
| -* [QicsTable|http://www.ics.com/support/docs/qt/qicstable/usermanual/index.php] - advanced, commercial QTable replacement from [The User Interface Company|http://www.ics.com/qt/], and thus KexiTableView competitor. Valuable for comparisons. |
| * [Ability Database|http://www.ability.com/sales/products/database.php?ln=en] - commercial product, very MSAccess-like ([Some features|http://www.softsource.co.uk/linked_pages/ability_database_features.htm]) |
| -* [DBACompanion|http://homepage.internet.lu/torsten/] - a graphical administration tool for Oracle databases. Looks like good starting point for adding db driver and import/export driver for Oracle. |
| -*[Navicat|http://www.navicat.com] some mySQL "frontend" (proprietery) |
| -*[DbNetGrid|http://www.dbnetgrid.com/dbnetgrid/default.aspx] - HTML db grid component (IE-only). Some good ideas for incoming Kexi Web Plugin. |
| +*[Navicat|http://www.navicat.com] some mySQL "frontend" |
| *[OpenLink Virtuoso|http://docs.openlinksw.com/virtuoso/index.html] - CROSS PLATFORM Universal DB Server; also integrates Web and File serving. Large commercial project with interesting documentation. |
| *[DB Manager Pro|http://www.dbtools.com.br/EN/dbmanagerpro/] - a multi-database tool with powerfull functionality. For example see Process Designer : www.dbtools.com.br/EN/dbmanagerpro/images/task_builder.png. Many ideas for Kexi! |
| -*[SQL Server 2005 Express Edition Beta 2|http://lab.msdn.microsoft.com/express/sql/default.aspx] |
| *[SQL datacompare|http://www.red-gate.com/sql_data_compare.htm] - Compare and Synchronize Database Contents. Interesing extrension, could be added for Kexi. |
| *[sqlFree|http://www.independencesoft.com/] - Java-based db GUI includes: Visual SQL query builder, Reverse engineering of SQL statements - the Parser, Reverse engineering of SQL statements - the Parser, Viewing returned results, DB Browser |
| -* Migration Tools |
| -** [MySql to Access / Access to MySql Converter|http://www.fonlow.com/zijianhuang/dbconverter/index.html]; especially see [Data type mapping from MySql to Access|http://www.fonlow.com/zijianhuang/dbconverter/mysql2access_matrix.html]. |
| -** [Sqlporter|http://www.realsoftstudio.com/overview.html] - migration of database structures and data across Oracle, IBM DB2, MS-SQL Server, Sybase ASE, MS Access and MySQL. |
| +* [AquaFold|http://www.aquafold.com/] - Java-based database query and administration tool. Very interesting, especially built-in [Visual Explain Plan|http://www.aquafold.com/features_3_7.html] |
| +* [DB Visual Architect|http://www.visual-paradigm.com/dbva.php] - DB Visual Architect is a single development environment which acts as a bridge between object model, data model and relational model. |
| +* [DeZign for Databases|http://www.datanamic.com/dezign] - database development tool using an entity relationship diagram |
| +* [Kirix Strata|http://www.kirix.com/] - commercial MSA competitor, developed using wxWidgets, has quite a few interesting ideas (eg. grouping within table view), also see their PDF [guide|http://www.kirix.com/docs/strata/strata_eval_guide.pdf] |
| +* [GUPTA Team Developer|http://www.guptaworldwide.com/Products/TD.aspx] - a development tool for creation of business applications; object-oriented, COM+ object generation, integrated Web applications, native database interface for all popular databases. '''For Linux and Windows'''. |
| +* [SQL Manager|http://www.sqlmanager.net/] - database administration tools for MySQL, PostgreSQL, MSSQL, Firebird, DB2 from a nice Russian company. Rather advanced and complex GUIs. Import/Export tools. |
| +* [AccessUI|http://www.accessui.com/] - MSA GUI extension |
| +* [VistaDB|http://www.vistadb.net/] - Data management environment, MSA competitor. |
| +* [CodeCharge Studio|http://www.yessoftware.com/products/product_detail.php?product_id=1] - visually creating database-driven Web applications with minimal amount of coding. __Idea for Kexi Web Plugin?__ |
| +* [SQL_Prompt|http://www.red-gate.com/products/SQL_Prompt/index.htm] - provides Intellisense style auto-completion for MS SQL Server editors. |
| +* [SBase|http://www.bluewatersys.com/s-base/index.php] is a programmable, fully relational, RISC OS database management system, which allows you to develop customised data applications without any programming. __Development stopped until recently - Qt port is in progress...__ |
| +* [Active Query Builder|http://www.activequerybuilder.com/] - a visual query builder component that allows to build complex SQL queries via a visual query building interface. __Interesting way for adding fields to the query (using checkboxes)__. |
| +* [SQL Uniform|http://www.sqluniform.com] - a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert), import. |
| +* [Dabble DB|http://dabbledb.com] is a '''web-based application''' that lets you work with data on your own terms. You can import data from spreadsheets or databases — or just start from scratch. |
| +* [Servoy|http://www.servoy.com] is a cross-platform, Java-based application development and deployment environment; contains GUI designer for databases frontends, scriptable through JavaScript, allows for combining data from multiple sources; supports various servers. |
| + |
| +!!Reporting Tools |
| + |
| +!Open Source Reporting Tools |
| +* [ReportLab|http://reportlab.org/] - Open Source toolkit for creating good-looking reports in PDF. Let's see if this can be reused in Kexi? |
| +* [Agata Report|http://www.agata.org.br/us/index.php] - mature reporting tool (LGPL), it's good idea to see how things are made there |
| +* [NCReport|http://ncreport.sourceforge.net] - a lightweight, fast, easy to use SQL report engine written in C++ based on Qt toolkit. |
| +* [OpenRPT|http://www.openrpt.org] report writer and rendering engine - let's look at it for interesting features for Kexi Reports ([PDF user manual|http://heanet.dl.sourceforge.net/sourceforge/openrpt/OpenRPT_UserGuide_DRAFT_041505.pdf]) |
| +* [Report Manager|http://sourceforge.net/projects/reportman/] is both a print scheme designer (report) and a high level printing (reporting) engine. Also a TCP Report Server and a Web Report Server (PDF on the fly), supports Windows and Linux. Connectivity to almost all databases is provided. |
| +* [Papyrus|http://www.treshna.com/papyrus/] - an XML reporting engine, generates reports from a variety of different SQL databases. Reports can be generated as PDF, PS, XML, HTML, etc. |
| +*[iReport|http://jasperforge.org/sf/projects/ireport] is a powerful, intuitive and easy to use visual report builder/designer for JasperReports written in Java. |
| +*[DataVision|http://datavision.sourceforge.net/] is an Open Source reporting tool written in Java similar to Crystal Reports. Reports can be designed using a GUI and may be run, viewed, and printed from the application or exported as HTML, XML, PDF, Excel, LaTeX2e, DocBook, or tab- or comma-delimited text files. |
| +*[JOOReports|http://jooreports.sourceforge.net/?q=jooreports], Java/OpenOffice Document and Report Generator, helps creating office documents and reports in OpenDocument Text format '''from templates that can be visually composed using the OpenOffice.org Writer'''. These documents can then optionally be converted to other formats such as PDF, Word and RTF. |
| +*[JODConverter|http://www.artofsolving.com/opensource/jodconverter], the Java OpenDocument Converter, converts documents between different office formats. It leverages OpenOffice.org, which provides arguably the best import/export filters for OpenDocument and MSO formats. |
| + |
| +!Proprietary Reporting Tools |
| +* [BusinessObjects|http://businessobjects.com/] - Crystal Reports and so on. |
| +* [.rpt Inspector|http://www.softwareforces.com/Product/ri/pro/2/ri_index.htm] - a tool for Crystal Reports®, for editing multiple reports at once ([features|http://www.softwareforces.com/Product/ri/pro/2/features.htm]). |
| +* [GUPTA Report Builder|http://www.guptaworldwide.com/Products/Report.aspx] - client/server query and reporting tool; part of the Team Developer package, can be embedded into applications developed with GUPTA tools; also available as a standalone product. '''For Linux and Windows''' |
| + |
| +!!3rd-party Data Widgets |
| +!Open Source Plotting/Charting/Presentation |
| * [kst|http://omega.astro.utoronto.ca/kst/] - A GPLed plotting and data viewing program; it's display capatibilities could be reused for Kexi |
| * [Qt4Lab Data Plotter|http://www.qt4lab.org/] - LGPLed Data Plotting library, could be reused within Kexi. |
| * [LabPlot|http://labplot.sourceforge.net/] - another GPLed Data analysis and visualisation tool. |
| -* [Mono Database Access|http://www.mono-project.com/Database_Access] wiki page |
| -* New GUI tools from MySQL: |
| -** [MySQL Administrator|http://www.mysql.com/products/administrator/] |
| -** [MySQL Query Browser|http://www.mysql.com/products/query-browser/] |
| -* [AquaFold|http://www.aquafold.com/] - Java-based database query and administration tool. Very interesting, especially built-in [Visual Explain Plan|http://www.aquafold.com/features_3_7.html] |
| -* Database design/ DB driven application development: |
| -** [DB Visual Architect|http://www.visual-paradigm.com/dbva.php] - DB Visual Architect is a single development environment which acts as a bridge between object model, data model and relational model. |
| -** [Umbrello UML Modeller|http://uml.sourceforge.net] - Unified Modelling Language diagram programme for KDE. Could be integrated with Kexi database design capatibilities, e.g. Entity Relationship designer: http://uml.sourceforge.net/screenshots/umbrello-entiry-relationship.png |
| -** [Data Architect|http://www.thekompany.com/products/dataarchitect] - a tool for designing databases |
| -** [DeZign for Databases|http://www.datanamic.com/dezign] - database development tool using an entity relationship diagram |
| -* [Kirix Strata|http://www.kirix.com/] - commercial MSA competitor, developed using wxWidgets, has quite a few interesting ideas (eg. grouping within table view), also see their PDF [guide|http://www.kirix.com/docs/strata/strata_eval_guide.pdf] |
| +* [Qanava|http://www.libqanava.org/] - a Qt-based library for graphical display of graphs and other relational structures. Qt4 support! |
| +* [KGraphViewer|http://kde-apps.org/content/show.php?content=23999] - another graph-displaying app, supports the dot format. __jstaniek has contacted the author: kleag at free.fr__. |
| + |
| +!Proprietary |
| +* [QicsTable|http://www.ics.com/support/docs/qt/qicstable/usermanual/index.php] - advanced, commercial QTable replacement from [The User Interface Company|http://www.ics.com/qt/], and thus KexiTableView competitor. Valuable for comparisons. |
| +*[DbNetGrid|http://www.dbnetgrid.com/dbnetgrid/default.aspx] - HTML db grid component (IE-only). Some good ideas for incoming Kexi Web Plugin. |
| + |
| +!!Migration Tools |
| +* [MySql to Access / Access to MySql Converter|http://www.fonlow.com/zijianhuang/dbconverter/index.html]; especially see [Data type mapping from MySql to Access|http://www.fonlow.com/zijianhuang/dbconverter/mysql2access_matrix.html]. |
| +* [Sqlporter|http://www.realsoftstudio.com/overview.html] - migration of database structures and data across Oracle, IBM DB2, MS-SQL Server, Sybase ASE, MS Access and MySQL. |
| +* [MS Access 2003 Conversion Toolkit|http://www.microsoft.com/downloads/details.aspx?FamilyId=2E861E76-5D89-450A-B977-980A9841111E&displaylang=en] - analyzes Access 97 databases for upgrade and conversion to MS Access 2003. Could Kexi gain similar tool? |
| +* [MSSQL 2 MySQL|http://www.kofler.cc/mysql/mssql2mysql.html] - Database Converter from Microsoft SQL Server to MySQL. |
| +* [Access2PostgreSQL & Access2MySQL|http://dbconvert.com] - converter from MSA to mysql/pgsql. |
| +* [Monarch Data Pump|http://monarch.datawatch.com/monarch-data-pump.asp] - automatically transforms unstructured data sources, such as report files and PDF files, into live, customized data; also works with structured data sources, such as databases and spreadsheets. |
| + |
| +!!Database Engines |
| +!Open Source |
| +* [PostgreSQL|http://www.postgresql.org/] |
| +* [Firebird|http://firebird.sourceforge.net/] |
| +* [MySQL|http://www.mysql.com/] |
| +* [NoSQL|http://www.scriptaworks.com/cgi-bin/wiki.cgi/NoSQL/HomePage?from=NoSQL.NoSQL] |
| +* [EyeDB|http://www.eyedb.org], an Object Oriented Database Management System (OODBMS) based on the ODMG 3 specification. |
| + |
| +!Properietary |
| * [Worksheet-Server|http://www.jedox.com/] using [OLAP|http://en.wikipedia.org/wiki/OLAP] - see how Kexi Web Interface could be handled)- "The Worksheet-Server combines the flexibility of Microsoft Excel with the power of todays Web technology. Simply define the desired business logic in Excel Spreadsheets and let the Worksheet-Server run these applications independently from Microsoft Excel as a true PHP-based Multi-User Web application". |
| -* [DataKiosk|http://extragear.kde.org/apps/datakiosk/] is a JuK-like database interface tool for generic SQL databases. QUite similar interface to planned Kexi's Final Mode. |
| -* [RKWard|http://rkward.sourceforge.net/] is meant to become an easy to use, transparent frontend to the R-language, a very powerful, yet hard-to-get-into scripting-language with a strong focus on statistic functions. Its capatibilities could be adopted to interoperate with Kexi data sources. |
| -* [.rpt Inspector|http://www.softwareforces.com/Product/ri/pro/2/ri_index.htm] - a tool for Crystal Reports®, for editing multiple reports at once ([features|http://www.softwareforces.com/Product/ri/pro/2/features.htm]). |
| +* [SQL Server 2005 Express Edition Beta 2|http://lab.msdn.microsoft.com/express/sql/default.aspx] |
| +* [GUPTA SQLBase|http://www.guptaworldwide.com/Products/SQLBase.aspx] - a relational, embedded database engine '''for Linux and Windows''' |
| + |
| +!!Scripting and Macro Engines |
| +* [Open Source VBA implementation|http://go-ooo.org/wiki/index.php/VBA] for OO.org |
| + |
| +!!Our Potential Partners |
| +!PostgreSQL Supporters |
| +* [Greenplum|http://www.greenplum.com/] is offering of open source databases for enterprise-class Business Intelligence and Data Warehousing. |
| +* [The Bizgres|http://www.bizgres.org/] Project is a Greenplum sponsored and community supported open source project. The goal of Bizgres is to to build a complete, database system for business intelligence exclusively from free software. |
| +* [EnterpriseDB|http://www.enterprisedb.com] Corporation (EDB) was founded in 2004 to bring the benefits of open source databases to enterprise customers. The EDB product set is built on top of PostgreSQL, the world's most advanced open source database. |
| +* [Pervasive Postgres|http://www.pervasivepostgres.com] combines the advanced features of PostgreSQL, the world’s most advanced open source database, with Pervasive’s twenty years of experience shipping, supporting, and servicing database products. |
| + |
| +!!Other |
| +!Other: Open Source |
| +* [PolePosition|http://www.polepos.org/] is a benchmark test suite to compare database engines and object-relational mapping technology. '''Let's use this to compare Kexi engine(s) with competition'''. |
| +* [Docvert|http://holloway.co.nz/docvert/] - takes word processor files (typically .doc) and converts them to OpenDocument and clean HTML. |
| +* [monotone|http://monotone.ca/] - is a free distributed version control system. it provides a simple, single-file transactional version store, with fully disconnected operation and an efficient peer-to-peer synchronization protocol. '''Idea: can be used together with Kexi to get versioning engine and still can be interoperable with kexisql'''. |
| +* [GCF|http://vcreatelogic.com/oss/gcf/index.html], a Generic Component Framework (GPL, Qt-based, a winner of the [Qt Centre Contest|http://contest.qtcentre.org/results]) providing '''tabbed toolbar (menu strip) like in Kexi 2'''; ([pdf manual|http://vcreatelogic.com/oss/gcf/GenericComponentFramework_Manual.pdf]) |
| + |
| +!Other: Proprietary |
| +* [ThinCAP JX|http://www.clearnova.com/] - RAD for AJAX, J2EE, and Open Source. What's interesting here? [Screenshots|http://www.clearnova.com/thinkcap/overview_cd/screenshots/screenshots_site.html] - "Domains" tree with ''Tools'' and ''Business Logic'' nodes interesting thing for Kexi. Web capatibilities are also interesting, Kexi's going to have similar (see their Demo Application). |
| +* [Qt Property Browser|http://www.trolltech.com/products/qt/addon/solutions/catalog/4/Widgets/qtpropertybrowser/] - the framework provides a browser widget that displays the given properties with labels and corresponding editing widgets (e.g. line edits or comboboxes) |
| +* [Resolver|http://resolversystems.com/products.php] lets you create powerful solutions integrating databases, code and IT-developed components - all using your existing knowledge of spreadsheets. '''Similar to our idea of live integration of Kexi and KSpread.''' |
