NeoBase

From NeoWiki

Revision as of 04:00, 21 July 2007 by Sardisson (Talk | contribs)
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.

Connecting to and Importing From Other Databases

Configuring MySQL using JDBC and NeoOffice 2.0
Configuring MySQL using ODBC
Configuring postgresql
Configuring FileMaker Pro
dbf and MS Access tips

Other Base Tips in the Wiki

Using a Calc spreadsheet as a data source
Importing Data from Address Book
Using the Mail Merge Wizard (in Writer, but using Base datasources)

Documentation, Tutorials, etc.

User Guides and Documentation

Suggested by the HSQLDB User Guide

Books

Forums

Probably the best place to ask questions about using Base.

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
Personal tools