Re: [web2py] Re: pyDAL looks abandoned?

[AGRogers]

That's good news.

On Mon, 17 Aug 2020 at 17:08, Massimo Di Pierro 
wrote:

> 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.
>
>
> On Monday, 11 May 2020 13:27:14 UTC-7, 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/8a858190-e078-44f8-bcff-c88c13dae0b6o%40googlegroups.com
> 
> .
>

-- 
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/CACWMBMNT4SbbjjKeWNT015pWMm44%3Di77mYgWEBYWpwppxK7LVQ%40mail.gmail.com.

[web2py] Re: pyDAL looks abandoned?

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


On Monday, 11 May 2020 13:27:14 UTC-7, 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/8a858190-e078-44f8-bcff-c88c13dae0b6o%40googlegroups.com.

[web2py] Re: pyDAL looks abandoned?

[Val K]

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

-- 
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/f408eca2-dc3b-4976-94b4-60ac0f1aaa79o%40googlegroups.com.

[web2py] Re: pyDAL looks abandoned?

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

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.

[web2py] Re: pyDAL looks abandoned?

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



On Wednesday, 20 May 2020 07:50:30 UTC+1, Alexei Vinidiktov wrote:
>
> 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.
>
> On Wednesday, May 13, 2020 at 10:33:45 PM UTC+7, villas wrote:
>>
>> 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?).
>>
>>
>>

-- 
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/29facb9f-982b-4183-91c0-54449b2aef95%40googlegroups.com.

[web2py] Re: pyDAL looks abandoned?

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

On Wednesday, May 13, 2020 at 10:33:45 PM UTC+7, villas wrote:
>
> 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?).
>
>
>

-- 
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/d7f0ddc3-3222-453c-acde-38d1b045a817%40googlegroups.com.

[web2py] Re: pyDAL looks abandoned?

[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;)

-- 
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/1cab9745-38d8-4143-8cf5-90444f9c35cf%40googlegroups.com.

[web2py] Re: pyDAL looks abandoned?

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


-- 
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/54321c9c-be92-4926-88d1-76c0e01b38ce%40googlegroups.com.

Re: [web2py] Re: pyDAL looks abandoned?

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

On Tue, 12 May 2020 at 09:37, Val K  wrote:

> BTW:
> if anyone is interested about WITH RECURSIVE here is my implementation:
> https://github.com/web2py/pydal/issues/627
>
>
>
>
> On Monday, May 11, 2020 at 11:27:14 PM UTC+3, 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/12e8a9c3-c855-419d-82e5-6bbe5e2c2e44%40googlegroups.com
> 
> .
>

-- 
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/CACWMBMM1pROd_z%2Bz1X19V7Pw-u3m3-snTe4cVs0kDpQMZRddXg%40mail.gmail.com.

[web2py] Re: pyDAL looks abandoned?

[Val K]

BTW:
if anyone is interested about WITH RECURSIVE here is my implementation:
https://github.com/web2py/pydal/issues/627




On Monday, May 11, 2020 at 11:27:14 PM UTC+3, 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/12e8a9c3-c855-419d-82e5-6bbe5e2c2e44%40googlegroups.com.