[SQLObject] FloatCol, distinct+count and others

[Marcin W. <wo...@un...>]

Hi,
I will write about a few things, that make me not 100% happy
with SQLObject, in one mail.

First about MultipleJoin: as Robert wrote in
http://sourceforge.net/mailarchive/forum.php?thread_id=3D5435228&forum_id=
=3D30269
person.addresses will generate n+1 queries to DB.

About FloatCol, what do you think should be a type of FloatCol?
I think double precision in every database (but I'm not sure if other
people agree), as I wrote in
http://sourceforge.net/mailarchive/forum.php?thread_id=3D5604389&forum_id=
=3D30269

About count() in distinct'ed select: now it silently returns not-distinct=
ed
count. As Jeremy wrote, SQLite doesn't support count(distinct ...),
but I think the patch from
http://sourceforge.net/mailarchive/forum.php?thread_id=3D5545866&forum_id=
=3D30269
would work fine - it works as expected in dbms that support count(distinc=
t),
and probably raises exception in SQLite, what is better than returning
wrong value.

And when I found SQLObject, I first downloaded "Mostly Live CVS Tarball".
It took me a while to realize, that it is outdated. Now it seems to be
older than 0.5.2 tarball.

Anyway, I'm quite happy with SQLObject :)

Marcin

--=20
Marcin Wojdyr  |  http://www.unipress.waw.pl/~wojdyr