pyDAL looks abandoned?

[Val K]

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

[Val K]

BTW:

if anyone is interested about WITH RECURSIVE here is my implementation:

https://github.com/web2py/pydal/issues/627

[AGRogers]

Hi Val. I can't add anything useful to this sorry... except to say that i have really enjoyed using the DAL in my current project. I have no experience with others and have not done anything tricky like I have had to do in SQL server procs and what not. But it has made development easy for me.

So i hope it hasnt been abandoned :-)

And i have spent a LOT of time in the book - extra examples and keeping that book up to date would be really helpful.

--
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+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/12e8a9c3-c855-419d-82e5-6bbe5e2c2e44%40googlegroups.com.

[villas]

Val, I empathize because I have been waiting for 3 months to include a test connect string for Firebird.

Firebird simply won't work without this, but no one even adds a comment. 

I imagine that there are not enough devs, and I understand it is difficult maintaining this code.  Maybe we users can help more in some ways, but the code still needs to be reviewed and committed by someone (Massimo?).

[Val K]

Thanks for your replies, guys! I just want to highlight the problem. I believe that Massimo is a very creative person, and like any creative person, he does not really like routine work ... especially if no one asks to do it;)

[Alexei Vinidiktov]

I was having the same issue with Firebird. I recently found your ticket on github and your fix worked for me too.

I saw the other day that your fix was finally merged.

I just wonder when the next version of pyDal will be released.

[villas]

Re: Firebird.  Yes, I prepared a pull-request and Massimo merged it.  That was great.  I just use the pydal from Github now and all works well for me. 

[Joe Barnhart]

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).

[Val K]

Yes, peewee is cool but too verbose, almost like pure SQL.

[Massimo Di Pierro]

yes Peewee is more actcie but I would not say pydal is abandoned. pydal is more mature and there were commits as recent as last week. In my opinion it needs very little work and I am reluctant to change things. Many of the issues are requests for new features, some are how to, or support for exhotic features. There are also many issue that have been fixed but the issue has not been closed. When I have time I will take a pass and close a bunch.

I do not think there are many bugs in pydal that need fixing excecpt for the need to support google cloud storage in py3.

[AGRogers]

That's good news.

--

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+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/8a858190-e078-44f8-bcff-c88c13dae0b6o%40googlegroups.com.