> 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.
Indeed. I think eventually the store should be rewritten with the primary
key being some sort of hash of the uri.
> -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).
Good idea. I'll try to add some parameters to specify this.
> 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).
Remy
