Difference between revisions of "Database"
From Apache OpenOffice Wiki
(→Misc) |
(→Connecting) |
||
| Line 104: | Line 104: | ||
== Connecting == | == Connecting == | ||
* Base New Driver Tutorial | * Base New Driver Tutorial | ||
| − | + | : [[Base_New_Driver_Tutorial]] | |
| − | [ | + | : Initial author: Robert Vojta |
| − | + | : This small How-To contains a simple step-by-step introduction on how to put your driver inside the connectivity module. The second part of this document covers differences between a driver in connectivity module and a driver in an UNO package. | |
| − | Initial author: Robert Vojta | + | |
| − | + | ||
| − | This small How-To contains a simple step-by-step introduction on how to put your driver inside the connectivity module. The second part of this document covers differences between a driver in connectivity module and a driver in an UNO package. | + | |
* Better Database Drivers | * Better Database Drivers | ||
| − | + | : [[BetterDatabaseDrivers]] | |
| − | [ | + | : Initial author:Eric Bischoff |
| − | + | :Some ideas for a better and simpler infrastructure for database drivers | |
| − | Initial author:Eric Bischoff | + | |
| − | + | ||
| − | Some ideas for a better and simpler infrastructure for database drivers | + | |
* Connecting to Microsoft Access | * Connecting to Microsoft Access | ||
| − | + | : [[Connecting_to_Microsoft_Access]] | |
| − | [ | + | : Initial author: Regina Henschel |
| − | + | : These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system. | |
| − | Initial author: Regina Henschel | + | |
| − | + | ||
| − | These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system. | + | |
* OpenOffice.org Base - Database Drivers | * OpenOffice.org Base - Database Drivers | ||
| − | + | : [http://dba.openoffice.org/drivers/ http://dba.openoffice.org/drivers/] | |
| − | [http://dba.openoffice.org/drivers/ http://dba.openoffice.org/drivers/] | + | |
* Connecting with MySQL | * Connecting with MySQL | ||
| + | : [http://wiki.services.openoffice.org/wiki/Connect_MySQLandBase http://wiki.services.openoffice.org/wiki/Connect_MySQLandBase] | ||
| − | + | * An overview page | |
| − | + | : Native PostgreSQL Driver | |
| − | An overview page | + | : [http://dba.openoffice.org/drivers/postgresql/index.html http://dba.openoffice.org/drivers/postgresql/index.html] |
| − | + | ||
| − | + | ||
| − | + | ||
| − | [http://dba.openoffice.org/drivers/postgresql/index.html http://dba.openoffice.org/drivers/postgresql/index.html] | + | |
* SQL-lite Driver | * SQL-lite Driver | ||
| − | + | : http://dba.openoffice.org/drivers/sqlite/index.html | |
| − | http://dba.openoffice.org/drivers/sqlite/index.html | + | |
* mdb-sdbc-driver-0.1.0 | * mdb-sdbc-driver-0.1.0 | ||
| − | + | : [http://dba.openoffice.org/drivers/mdb/index.html http://dba.openoffice.org/drivers/mdb/index.html] | |
| − | [http://dba.openoffice.org/drivers/mdb/index.html http://dba.openoffice.org/drivers/mdb/index.html] | + | : Initial author: Wind Li (yl146652 [at] openoffice [dot] org) |
| − | + | : It is a try to connect a Linux system to MS Access. There is no further development. | |
| − | Initial author: Wind Li (yl146652 [at] openoffice [dot] org) | + | |
| − | + | ||
| − | It is a try to connect a Linux system to MS Access. There is no further development. | + | |
* A working page | * A working page | ||
| − | + | : [http://wiki.services.openoffice.org/wiki/MDB_Driver_Integration http://wiki.services.openoffice.org/wiki/MDB_Driver_Integration] | |
| − | [http://wiki.services.openoffice.org/wiki/MDB_Driver_Integration http://wiki.services.openoffice.org/wiki/MDB_Driver_Integration] | + | |
* MSA-Base Faq | * MSA-Base Faq | ||
| − | + | : [http://wiki.services.openoffice.org/wiki/MSA-Base_Faq http://wiki.services.openoffice.org/wiki/MSA-Base_Faq] | |
| − | [http://wiki.services.openoffice.org/wiki/MSA-Base_Faq http://wiki.services.openoffice.org/wiki/MSA-Base_Faq] | + | |
* Firebird driver update for OO.org | * Firebird driver update for OO.org | ||
| − | [http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase Jaybird OpenOffice.org Base support] | + | : [http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase Jaybird OpenOffice.org Base support] |
== Examples == | == Examples == | ||
Revision as of 09:33, 2 February 2009
This page is hosted by the OOo Database Docu Coordinator, who are members of the OOo Database QA Team. You can find here links to Base documentation ordered by languages and topics. Feel free to add documents, you are missing, to this list.
Resources related to OpenOffice.org Base:
Contents
English
The following links are in English.
Manuals
General
- Base
- Base
- Description of the features of OpenOffice.org Base (short overview), Documentation resources and official sites
- OpenOffice.org User Guides (Getting started with Base) - PDF
- Getting started with Base
- Learn how to create a database, queries, forms and reports and connect to and use other data sources within OOo-Base.
- OpenOffice.org Base Manual
- OpenOffice.org Base Primer
- Initial Authors: Andrew 'Drew' Jensen, Frank Schoenheit, et al.
- A short screenshot-guided overview on how to use Base.
- Mid Level Base Tutorial
- Mid Level Base Tutorial
- Innitial Authors: Mariano Casanova, Andrew 'Drew' Jensen
- Beginners - Example Database - Base Tutorial
- Example
- Initial author: Andrew 'Drew' Jensen
- This tutorial covers creating a first database using OOoBase. It is intended for those that have not used Base before or those that have never used any database manager.
- Base and Macros
- Pitonyak's document
- Initial author: Andrew Pitonyak
- This documentation focuses on operating a database with the help of OpenOffice.org Macros.
- Database: "ooBase", aka "Base"
- Base Tutorial by Sheepdogguides.com
- Initial author: TK Boyd
- After a short introduction some every day tasks like importing data from other tables are explained.
- Bringing data into OpenOffice 2.0's database
- Database
- Initial author: Solveig Haugland
- Screenshot guided tutorial on how to import data into Openoffice.org Base.
- New Features in 3.1
- [[Base/New_features_in_3_1 New Features]
- Initial author: Reizinger Zoltan
- Compiled from mailing list
Tables
Queries
Reports
- description followed
- Sun Report Builder (Reference)
- Reference
- description follow
- Sun Report Builder Documentation
- Documentation
- Basic Features
- Functions in Reports
- Functions and Expressions
- description follow - Not available now
- Functions in Reports
- SUN Report Builder/Functions
- description followed
Developer
- Working basis to make the user guide better
- Getting_Started/Getting_Started_with_Base
- description followed
- Using Macros in Database Files
- Macros_in_Database_Documents
- 'Specification to develope this functionality
FAQ
- Common tasks
- Common_tasks
- Initial author: Andrew 'Drew' Jensen
- Many good questions, no answers.
Misc
- HSQLDB Tips and Tricks
- Tips_and_Tricks
- description followed
Connecting
- Base New Driver Tutorial
- Base_New_Driver_Tutorial
- Initial author: Robert Vojta
- This small How-To contains a simple step-by-step introduction on how to put your driver inside the connectivity module. The second part of this document covers differences between a driver in connectivity module and a driver in an UNO package.
- Better Database Drivers
- BetterDatabaseDrivers
- Initial author:Eric Bischoff
- Some ideas for a better and simpler infrastructure for database drivers
- Connecting to Microsoft Access
- Connecting_to_Microsoft_Access
- Initial author: Regina Henschel
- These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system.
- OpenOffice.org Base - Database Drivers
- Connecting with MySQL
- An overview page
- Native PostgreSQL Driver
- http://dba.openoffice.org/drivers/postgresql/index.html
- SQL-lite Driver
- mdb-sdbc-driver-0.1.0
- http://dba.openoffice.org/drivers/mdb/index.html
- Initial author: Wind Li (yl146652 [at] openoffice [dot] org)
- It is a try to connect a Linux system to MS Access. There is no further development.
- A working page
- MSA-Base Faq
- Firebird driver update for OO.org
Examples
General
- Base Example (Overview)
http://wiki.services.openoffice.org/wiki/Category:Base_Example
Initial author: Frank Schönheit
- Standard Distributed Schema
http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema
Concrete Examples
- A club membership database
http://wiki.services.openoffice.org/wiki/A_club_membership_database
Initial author: Andrew 'Drew' Jensen
Description of creating an example database
- OpenOffice.org API - Code snippets: http://codesnippets.services.openoffice.org/Database/index.xml
Useful code snippets solving frequently asked questions.
- Base Example
http://wiki.services.openoffice.org/wiki/Help_Files
http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema
Misc
- Initial author: Andrew 'Drew' Jensen
- Starting Point for all kind of OOo Database Questions
Testing
- Initial Author: Christoph Lukasiak
- Main Point of OOo Database Testing
- Initial Author: Wolfram Garten
- Main Starter Document for QA Newbies
- http://wiki.services.openoffice.org/wiki/Database_Automatic_Testing
- http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide/Planning
- http://wiki.services.openoffice.org/wiki/FAQ_%28Base%29
Connecting OpenOffice.org To A Remote MySQL Database] (event. 1.x)
French
German
DE/Beispielsdatenbank_mit_Base
http://dannenhoefer.de/faqstarbasic/Datenbanken.html
http://de.openoffice.org/doc/howto_2_0/index.html#datenquellen_2_0
End user documentation
Portugese
http://broffice.org/files/Introdu%C3%A7%C3%A3o_ao%20BrOffice.org_Base_2.0.x.odt
Copyright
OOo Database Development
OOo Database QA
OOo General Database Info
Initial author : Mechtilde Stehmann 24 September 2007
Please do not change the logical content of this site without acknowledge of the author or the OOo QA Project Lead/Co-Leads. This side is linked by the online help.
