Developing with Just OOo Base's HSQL engine

Comatose51 · Newbie Joined: 16 Jul 2005 Posts: 1

I'm about to to my project on a GPLed calender program and am looking for a simple database as a backend. OOo Base looks perfect for this except for the following issues:

1. Is there a way to use just the DB part of OOo Base? I want to include it with my program but I don't want to require people to install OOo just to run my program. In short, I need a light SQL DB to be packaged with my program.

2. What is the best way to call OOo Base's HSQL engine from C# if that is possible at all?

3. Where can I get a guide to using the HSQL engine?

Thanks.

bryancole · OOo Advocate Joined: 13 Jun 2003 Posts: 305

OO-Base is a DB "frontend" (i.e. GUI) rather than a "backend" (DB management system). Sounds like you just want the "backend" bit for your own application.

HSQL (OO-Base's embedded DB) is written in java so doesn't seem a good fit for a c# application (all clients would need a Java VM installed).

Why not try SQLite instead. It has C# bindings on both .net and mono.

BC