[Webware-devel] Middlekit Questions

[Jeffrey C. <jcl...@bl...>]

Hi there,

I've been looking at using Middlekit for some projects, not necessarily
with WebKit, and am having some problems.  First off I'm really
impressed by it.  It seems quite simple to use and works nicely.
Unfortunately I don't really like MySQL.  I usually use Firebird or
Postgres.  Neither of which have an equivalent to the "lastInsertedID"
as far as I can tell.  I'm also not a huge fan of autonums.  They often
seem to cause me grief and they make merging databases impossible.  

My proposal is to try changing the way the MiddleKit deals with object
IDs.  Instead of having the database generate them which is bound to
limit it's cross-platform-ness what if the objectID fields were turned
into varchar(50)'s or something like that and anytime we need a new ID
we generate a GUID or similar.  Then we just have a generateKey method
in the SQLObject and call that on inserts.

I don't imagine this should be too much of a change from the way it
works nw but it would make it much easier to port to other systems.  I
would be willing to do this if it is of interest.  Either way I probably
will try it but if it sounds like something that might be useful I would
like to have some input.

Jeff

-- 
Jeffrey Clement 
Website         : http://jclement.ca
GPG key         : 0x6F087FB9 / wwwkeys.pgp.net
GPG fingerprint : 2956 42A8 ED8A 91F4 8CE0  A5DF 5293 8E10 6F08 7FB9