Re: pyDO 2 alpha

Jacob Smullyan wrote:
 > (I am highly
 > suspicious of "database portability" for applications of any
 > sophistication.)

Exactly.

 > I think, from reading Bicking's blog, that in fact
 > he more or less shares my view that an ORM should not aspire to be an
 > opaque layer over a database, but instead be a way of facilitating the
 > creation of an application layer with one, so SQLObject's portability
 > features may perhaps be best thought of as vestigial or at least
 > inessential.

That's what I thought, too, until I talked with him about this.
He definitely wasn't interested in seeing SQLObject becoming less 
intrusive in this respect.  So in this instance at least I felt mislead 
by the blog (I think I know the entry you're referring to).  Oh, well.

 > Other uniqueness constraints are necessary to
 > distinguish updateable from non-updateable instances (and PyDO accepts
 > multiple-column constraints here, unlike SQLObject).

I don't follow what you mean here.  What do you mean by a non-updateable 
instance?

 > PyDO does not actually enforce the uniqueness constraint; it simply
 > uses it to know that it can expect to get just one thing under certain
 > circumstances.

So basically it's being used to tell pyDO which values are legal to 
treat as a key?  I can see how that makes sense.

 >>The one thing I did like about SQLObject was the _fromDatabase option.
 >
 > Which I assume is the schema introspection part.

Right.

 >  It is entirely
 > possible to add and I have stubbed out methods to do it, but it isn't
 > implemented yet.  I got a bit stuck on implementing it for sqlite, and
 > thought I'd need to write a SQL parser to do it, but I recently found
 > that isn't the case.

I got far enough into the SQLObject code to think this won't be a 
problem.  Guess we'll see.

 > I released the alpha because I thought it could take as well as
 > benefit from some scrutiny.  I've been working on other things, but
 > I'm going to start writing an application with it and hopefully that
 > will have the usual effect of flushing out problems.

Thanks again for the answers.

-Jonathan


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click