I'm creating a program for end-users, that's already written using MySQL and some OpenOffice.org Star Basic Macros. I was wondering if there was an open source single user database that would be easy enough for the average Joe to install, (or that I could write a macro to install it for him...)
The OpenOffice.org Base Wikipedia article briefly describes the database module in openoffice.
OpenOffice.org users, however, can choose to connect to external full-featured SQL database such as MySQL, PostgreSQL and even Oracle through ODBC or JDBC drivers. OpenOffice.org Base can hence act as a GUI frontend for SQL views, table design and query.
A simple, single-user database library that needs no install is SQLite, that had been considered by the openoffice team. It is used in many mainline applications, e.g. Mozilla Firefox.