> > The last question is, it looks like hsql is no longer being
> worked on. Are
> > there any plans to convert to a different database
> (postgres, mysql, or
> > oracle)?
>
> The store should run reasonably well with Oracle and mySQL,
> but you'll have
> to create the tables yourself (the types supported by each
> database can vary
> a lot).
>
> Note : If someone could contribute SQL scripts for the
> database creation on
> DBs other than hSQL, I would appreciate it. Thanks !
>
Hi all,
I've tried using slide with other databases, first off I tried Interbase.
-It doesnt like a varchar primary key longer than 252 characters.
This may be a problem for some people as it limits the URI to 252 chars
long. You could remove the Primary key constraint, and you could use 4000
chars, but I'd say your performance would be appaling after some time.
-doesnt like the use of "action" as a name in the Permissions table
-doesnt like the use of "type" as a name in the Locks table
-doesnt like the use of "value", "type" and "protected" in the
Property table
So if you thinking about using Interbase, it's gonna need some work. :)
(Most of this could be worked around without changing code if there was an
ability to map column names to custom values in slide, ie so you could
arbitarily choose column names of your liking, it would also make it more
portable too).
Attached is a script to create the tables in Oracle 8i, I havent any chance
to test it though so your mileage may vary. (Not sure if it works in other
version of oracle either).
Cheers,
Dave
oracle.sql
