FWIW there's nothing stopping you from using peewee inside web2py instead of DAL, if you desire. It's kind of an advanced topic, but it's possible. I notice peewee relies on cascaded message sends. Being an old Smalltalker I actually like cascaded message sends, but I recall that pypy really does not like them. They can leave chains of objects that are harder for pypy's storage reclamation to deal with (unless that's changed in pypy -- It moves pretty fast).
On Monday, May 11, 2020 at 3:27:14 PM UTC-5, Val K wrote: > > > There are 131 issues on pyDAL-GitHub, but the problem is not in the amount > but in that more than half of them without any response. Look at peewee > that has 7.5k stars and only 2 open issues!... yes, this is impolite > comparision - sorry. > I've just need to implement CTE + WITH RECURSIVE (like this > http://docs.peewee-orm.com/en/latest/peewee/querying.html#recursive-ctes) > and I wasted 2 days to figure out how I can do very simple thing like '1 > AS foo' in right way that is (as I suppose): > Expression(db, '1', type='integer').with_alias('foo') > > So, the question is: why is there nothing about that in the book? > Why does pyDAL have no that very simple but very necessary method which > allows to do cool things like: > db(...).select( > ..., > db.exp( > 'max(product.price) OVER(PARTITION BY product.category)', > type = 'decimal(n, m)' # the same as Field(..., type = 'decimal(n, > m)') > ).with_alias('most_expensive_in_category') > ) > > here is used WINDOW-function that allows to get products list with > 'most_expensive_in_category' in *one* plain query > *without using subquery* with GRUOP BY product.category + join > > Also there is my PR on web2py book > https://github.com/web2py/web2py-book/pull/424 > it hangs for almost a year - it is just a book, not code > I'm sad > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/ce42fcb5-0e14-459a-af80-da635d5ef173o%40googlegroups.com.
