Difference between revisions of "Base To-Do"
From Apache OpenOffice Wiki
| (26 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | Below is a list of [[Base]]-related projects which could be implemented by interested developers. Most of these projects are relatively self-contained, and do not require too much knowledge about | + | Below is a list of [[Base]]-related projects which could be implemented by interested developers. Most of these projects are relatively self-contained, and do not require too much knowledge about AOO's code infrastructure. |
| − | Note that the actual project descriptions are not yet moved to this place here, they still reside [ | + | Note that the actual project descriptions are not yet moved to this place here, they still reside [https://www.openoffice.org/dba/development/projects.html one of the project's static pages]. You're encouraged to visit this page, as it contains much more current information. |
| − | (So if you want, one of the To-Dos of our project is to move the To-Dos from | + | (So if you want, one of the To-Dos of our project is to move the To-Dos from https://www.openoffice.org/dba/development/projects.html to this Wiki page.) |
== Joins in dBase queries == | == Joins in dBase queries == | ||
| − | + | The content of this item moved to a dedicated page: [[Base_To-Do/Joins_in_dBase_queries]] | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
== SDBC driver for LDAP directories == | == SDBC driver for LDAP directories == | ||
| − | + | The content of this item moved to a dedicated page: [[Base_To-Do/SDBC_driver_for_LDAP_directories]] | |
== New/Enhanced Form Controls == | == New/Enhanced Form Controls == | ||
| − | + | The content of this item moved to a dedicated page: [[Base_To-Do/New+Enhanced_Form_Controls]] | |
== Dialogs with Form Functionality == | == Dialogs with Form Functionality == | ||
| − | + | The content of this item moved to a dedicated page: [[Base_To-Do/Dialogs_with_Form_Functionality]] | |
== Database driver UI modularization == | == Database driver UI modularization == | ||
| − | + | The content of this item moved to a dedicated page: [[Base_To-Do/Database_driver_UI_modularization]] | |
== HSQLDB: single-file backend == | == HSQLDB: single-file backend == | ||
| − | + | The content of this item moved to a dedicated page: [[Base_To-Do/HSQLDB:_single-file_backend]] | |
| − | == Embed Derby into OpenOffice | + | == Embed Derby into OpenOffice databases == |
| − | + | OpenOffice Base features an abstract mechanism to embed database backend files into AOO databases (.odb). Currently, this is implemented for [https:///hsqldb.org HSQLDB], which is used as AOO's default database engine. | |
| − | + | To allow this feature for other engines, one must: | |
| − | + | * virtualize the engine's file access, so that it re-routes all its file operations through an abstract API. | |
| + | * implement this API on the AOO Base side | ||
| − | + | The project is to do those implementations for [https://db.apache.org/derby Apache Derby database]. | |
| − | + | * required skills Java, C++ | |
| + | * useful skills: AOO's database access API, AOO's component technology (UNO) | ||
| + | * Contact: mailto:dev@dba.openoffice.org | ||
| + | * effort: 2 months | ||
| + | * difficulty: high | ||
| + | |||
| + | See also: | ||
| + | * [[File:DerbyToursDB.odb]] | ||
| + | * [[User:HCPotter]] | ||
== Native, cross-platform access to MS Access databases == | == Native, cross-platform access to MS Access databases == | ||
| Line 61: | Line 62: | ||
described in more detail at the [http://dba.openoffice.org/development/projects.html#new_filter here]. | described in more detail at the [http://dba.openoffice.org/development/projects.html#new_filter here]. | ||
| − | <noinclude>[[Category:Database]]</noinclude> | + | == Enable Picture Insertion == |
| + | |||
| + | :For example uses see table MAPS in [[File:ToursDB_schema.sql]] and [[File:DerbyToursDB.odb]]. [[User:HCPotter|HCPotter]] | ||
| + | |||
| + | == Discuss Remote Operation Necessity == | ||
| + | |||
| + | :When [[File:DerbyToursDB.odb]] is downloaded it can be used only when saved for local access. I have not tried the external application editing option. [[User:HCPotter|HCPotter]] 09:00, 14 June 2010 (UTC) | ||
| + | |||
| + | <noinclude>[[Category:Database]][[Category:To-Do]]</noinclude> | ||
Latest revision as of 16:24, 30 July 2022
Below is a list of Base-related projects which could be implemented by interested developers. Most of these projects are relatively self-contained, and do not require too much knowledge about AOO's code infrastructure.
Note that the actual project descriptions are not yet moved to this place here, they still reside one of the project's static pages. You're encouraged to visit this page, as it contains much more current information.
(So if you want, one of the To-Dos of our project is to move the To-Dos from https://www.openoffice.org/dba/development/projects.html to this Wiki page.)
Contents
- 1 Joins in dBase queries
- 2 SDBC driver for LDAP directories
- 3 New/Enhanced Form Controls
- 4 Dialogs with Form Functionality
- 5 Database driver UI modularization
- 6 HSQLDB: single-file backend
- 7 Embed Derby into OpenOffice databases
- 8 Native, cross-platform access to MS Access databases
- 9 SDBC driver for vCards
- 10 New Filter Dialog
- 11 Enable Picture Insertion
- 12 Discuss Remote Operation Necessity
Joins in dBase queries
The content of this item moved to a dedicated page: Base_To-Do/Joins_in_dBase_queries
SDBC driver for LDAP directories
The content of this item moved to a dedicated page: Base_To-Do/SDBC_driver_for_LDAP_directories
New/Enhanced Form Controls
The content of this item moved to a dedicated page: Base_To-Do/New+Enhanced_Form_Controls
Dialogs with Form Functionality
The content of this item moved to a dedicated page: Base_To-Do/Dialogs_with_Form_Functionality
Database driver UI modularization
The content of this item moved to a dedicated page: Base_To-Do/Database_driver_UI_modularization
HSQLDB: single-file backend
The content of this item moved to a dedicated page: Base_To-Do/HSQLDB:_single-file_backend
Embed Derby into OpenOffice databases
OpenOffice Base features an abstract mechanism to embed database backend files into AOO databases (.odb). Currently, this is implemented for HSQLDB, which is used as AOO's default database engine.
To allow this feature for other engines, one must:
- virtualize the engine's file access, so that it re-routes all its file operations through an abstract API.
- implement this API on the AOO Base side
The project is to do those implementations for Apache Derby database.
- required skills Java, C++
- useful skills: AOO's database access API, AOO's component technology (UNO)
- Contact: mailto:dev@dba.openoffice.org
- effort: 2 months
- difficulty: high
See also:
Native, cross-platform access to MS Access databases
described in more detail at the here.
SDBC driver for vCards
described in more detail at the here.
New Filter Dialog
described in more detail at the here.
Enable Picture Insertion
- For example uses see table MAPS in File:ToursDB schema.sql and File:DerbyToursDB.odb. HCPotter
Discuss Remote Operation Necessity
- When File:DerbyToursDB.odb is downloaded it can be used only when saved for local access. I have not tried the external application editing option. HCPotter 09:00, 14 June 2010 (UTC)
