On 11.Mar.2003 -- 06:33 PM, Torsten Curdt wrote:
> But since this is only used for the "personal" datasource it doesn't > make any sense all to have it configurable in the properties. It's just > for the example database. Let's KISS :)
Well, the idea was to make it easy to switch to $MY_FAVOURITE_DBMS for the user. I believe a frequently asked question is "how do I make the samples work with (MySQL|PostgreSQL|Oracle|DB2|Sybase|Access)?"
Chris.
That's why I wouldn't give up too easily on making the db setup work from a normal sql script. Currently we have the .sql out there, but I'm not sure it's up to date (though it looks like it), and if it's not used, it's certainly in danger of getting out of date at some point.
Now that the samples are at least working again, how about considering some options for actually creating the samples "schema" from the .sql?
- Do it during build? HSQL block build? Database block build? Separate target?
- Could we have a pipeline to do this that would be the first link
on the database block samples page? Users could provide the db connection name, which would let them use hsql by default, or any other db they've already set up.
- Other ideas?
Geoff
