|
|
NeoBase
From NeoWiki
(Difference between revisions)
| Revision as of 19:25, 15 July 2007 (edit) Lorinda (Talk | contribs) (→Tutorials - link to new wiki Base tutorials) ← Previous diff |
Revision as of 00:22, 17 July 2007 (edit) (undo) Lorinda (Talk | contribs) (adding tips and hints links) Next diff → |
||
| Line 1: | Line 1: | ||
| {{Fixme}} | {{Fixme}} | ||
| - | ''This page is very much under construction'' | + | <!--''This page is very much under construction''--> |
| - | 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 | + | 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. |
| + | |||
| + | ==Tips and Hints in the Wiki== | ||
| + | ''Note that some of the pages are "stubs" consisting mostly of links to discussions on trinity.''<br> | ||
| + | [[Configuring MySQL using JDBC and NeoOffice 2.0]]<br> | ||
| + | [[Configuring postgresql]]<br> | ||
| + | [[Configuring FileMaker Pro]]<br> | ||
| + | [[Using a Calc spreadsheet as a data source]]<br> | ||
| ==Documentation, Tutorials, etc.== | ==Documentation, Tutorials, etc.== | ||
| Line 19: | Line 26: | ||
| * [http://www.oooforum.org/forum/viewforum.phtml?f=10 OOoForum.org discussion forum for Base] | * [http://www.oooforum.org/forum/viewforum.phtml?f=10 OOoForum.org discussion forum for Base] | ||
| ::Probably the best place to ask questions about using Base. | ::Probably the best place to ask questions about using Base. | ||
| - | |||
| ===Tutorials=== | ===Tutorials=== | ||
| - | * [[To Base and Back Again]] 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. | + | * [[To Base and Back Again]] |
| + | :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. | ||
| * [http://sheepdogguides.com/fdb/fdb1main.htm Collection of smaller Base tutorials] | * [http://sheepdogguides.com/fdb/fdb1main.htm Collection of smaller Base tutorials] | ||
| - | * [http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Base tutorial] | + | * [http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Base tutorial] |
| + | :step-by-step construction of a small relational database for employees, with some advanced concepts like forms toward the end | ||
| * [http://inpics.net/base2.html Visual tutorial for Base] from InPics | * [http://inpics.net/base2.html Visual tutorial for Base] from InPics | ||
| * Two-part introduction to Base for database beginners: [http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1148271,00.html Part 1], [http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1151013,00.html Part2 ] | * Two-part introduction to Base for database beginners: [http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1148271,00.html Part 1], [http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1151013,00.html Part2 ] | ||
| - | + | <br> | |
| ===Miscellaneous=== | ===Miscellaneous=== | ||
| *[http://en.wikipedia.org/wiki/OpenOffice.org_Base Wikipedia article on Base] | *[http://en.wikipedia.org/wiki/OpenOffice.org_Base Wikipedia article on Base] | ||
| :includes lots of good links to documentation and tutorials | :includes lots of good links to documentation and tutorials | ||
Revision as of 00:22, 17 July 2007
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.
Configuring MySQL using JDBC and NeoOffice 2.0
Configuring postgresql
Configuring FileMaker Pro
Using a Calc spreadsheet as a data source
Documentation, Tutorials, etc.
User Guides and Documentation
- OpenOffice User Guide Chap 7
- HSQLDB User Guide (HSQLBD is the underlying database engine in Base)
- Good guide on SQL
- Suggested by the HSQLDB User Guide
Books
- Books on database design from OOoForum.org
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
- Visual tutorial for Base from InPics
- Two-part introduction to Base for database beginners: Part 1, Part2
Miscellaneous
- includes lots of good links to documentation and tutorials
