On Tue, 22 Apr 2008 03:21:26 +0100, Daniel Fetchinson  
<[EMAIL PROTECTED]> wrote:

>> But have you given any thought as to positioning against SQLAlechemy?
>>
>> It's a totally appropriate answer to say that you'll just continue  
>> working
>> on SQLObject and not really pay attention to what others are doing, of
>> course.
>>
>> But I think that if we want to continue to get new users, we need to  
>> have a
>> reason to be chosen over SQLAlcehmy.  Perhaps because we're easier to  
>> use or
>> faster, or whatever.
>
> Sqlobject is easier to use and is more lightweight than sqlalchemy.
> Correspondingly the learning curve is much less steep so for small
> projects many would find it more appropriate. It's like bash vs.
> python. For simple things python is an overkill, for more complex
> things bash is not powerful enough and one should go with python.

Aye, that's true. I think SQLAlchemy has a better query construction  
language (although to be fair I haven't used SQLObject's all that much),  
but I much prefer SQLObject's ORM. Alchemy has the advantage of (as I  
found out recently) non-integer, multicolumn primary keys, a feature that  
I took advantage of in a previous project. However, the complexity of  
configuring it puts me off using it in favour of SQLObject nine times out  
of ten.

The difference to me is that SQLAlchemy requires you to know how SQL works  
in much greater depth, /and/ to learn how SQLAlchemy interfaces with it  
all, before you can start using it. I'm not a DB expert, and I like how  
SQLObject doesn't bother me with a lot of the details before getting on  
with it.


Nick


-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to