NeoBase

From NeoWiki

(Redirected from Using MySQL)
Jump to: navigation, search
This article is not up to date, or it needs structural or stylistic changes to conform with the rest of this wiki.

NeoOffice Base allows you to either connect to an external database (MySQL, dBase, Calc, etc.) or to create an "embedded database" using the included HSQL database engine. In addition to entering and editing data, you can create Queries, Views, and Forms, as well as access any registered datasource in Writer and Calc documents.

Contents

Tips and Hints in the Wiki

Note that some of the pages are "stubs" consisting mostly of links to discussions on trinity.

Additional tips can be found on the New Articles Needed page, which contains links to stub pages and/or threads in trinity that need to be developed into full blown articles.

Connecting to and Importing from Other Databases

Other Base Tips in the Wiki


External Tips

Documentation, Tutorials, etc.

User Guides and Documentation

User Guides and Other "General" Documentation

Definitions

Using Macros in Base

HSQLDB and SQL Documentation

Books

Forums

Probably the oldest forum OpenOffice.org users. It is well frequented.
A newer OpenOffice.org forum. Many of the regulars also frequent ooforum.org, so double posting is not reccommended.

Tutorials

A new series of tutorials being written by one of NeoWiki's editors. Follows the creation of a database for tracking birding trips and sightings.
step-by-step construction of a small relational database for employees, with some advanced concepts like forms toward the end

Miscellaneous

includes lots of good links to documentation and tutorials


Database Examples

  • Gemstone. A double entry accounting system.
  • Herbs An example which tracks groups, cures, and myths for herbs. A commercial site, but the Herbs example database is Free.


This article in other languages: Français
Personal tools