Re: [dba-dev] HSQLDB 1.9 Testing needed

2009-10-30 Thread Andrew Jensen
Well, I was thinking simple. Place a Base file with the sakila table definitions (sans indexes, triggers) in a directory. Place the file sakila-data.sql in the same directory. In the Base database create a TEXT table, with a single column per record for each line in the file. CREATE TEXT TABLE SA

[dba-dev] Re: Example Database for OpenOffice/StarOffice

2009-10-30 Thread J. David Boyd
Valden Longhurst writes: > Good day Christoph, > > After reading about the Music database project at > http://wiki.services.openoffice.org/wiki/MusicDataBase_Main I am > wondering if the team is looking for a few other small database > examples for inclusion. > > I created one that I am willing t

Re: [dba-dev] HSQLDB 1.9 Testing needed

2009-10-30 Thread Ocke Janssen
Hi, On 10/29/09 19:08, Andrew Jensen wrote: Data! Here is what I was thinking. Option 1 - Just push the data into the odb file(s) and be done with it. Pros - Doesn't get any easier then downloading one file. Cons - The download is big. Option 2 - refer users to the existing sakila data file a

Re: [dba-dev] HSQLDB 1.9 Testing needed

2009-10-30 Thread Drew Jensen
On Thu, Oct 29, 2009 at 2:08 PM, Andrew Jensen wrote: > Data! > > Here is what I was thinking. > > Option 1 - Just push the data into the odb file(s) and be done with it. > Pros - Doesn't get any easier then downloading one file. > Cons - The download is big. > > Option 2 - refer users to the exis