[web2py] Is there a way to use postgresql v 8.4?

2014-05-07 Thread David Rager
My IT group assures me they are unable to install a more recent version of PostgreSQL than v. 8.4 because of SSL compliance issues and web2py isn't happy with that version. I have been developing on v. 9.3 without issue but once I switch to v. 8.4 selects on any table do not work: File "/U

[web2py] Re: A couple question on the scheduler

2014-04-29 Thread David Rager
f queuing something that gets fired > every once in a while and schedules the task only when it's needed > > > > On Friday, April 25, 2014 7:00:18 PM UTC+2, David Rager wrote: >> >> I'm just a tad confused about the scheduler - just 3 items I haven't been &g

[web2py] web2py scheduler assigned worker

2014-04-29 Thread David Rager
I have a scheduled task with an assigned worker name of MNG-IT-M-035.local#930 - however I do not see that name in the schedule_worker table and the task did not run when scheduled. Am I correct in assuming the missing schedule worker is why the task did not run? Is there a best practice to in

[web2py] Re: web2py conference, next week!

2014-04-25 Thread David Rager
Is there an online option (if you don't tick the "will attend in person")? On Thursday, April 24, 2014 9:20:56 AM UTC-6, Massimo Di Pierro wrote: > > There is one more to the first web2py conference > > http://www.experts4solutions.com/web2py_conference > > We got a bigger room and we can take 10-

[web2py] A couple question on the scheduler

2014-04-25 Thread David Rager
I'm just a tad confused about the scheduler - just 3 items I haven't been able to figure out and handle: 1. When a scheduler_task times out I see the status of TIMEOUT. It appears the task will not run again for the next scheduled run. Is this the expected behavior or am I misinterpreting?

[web2py] Re: web2py hanging after DB error - Windows / rocket / pyodbc / SQL Server

2012-08-20 Thread David Rager
PM UTC-6, Niphlod wrote: > > it's pretty obscure the way you describe those errors: "certain DB errors" > are what ? unique constraints not respected? db migrations ? heavy > complicated queries ? file uploads ? > > On Monday, August 20, 2012 6:35:10 PM UTC+2, Davi

[web2py] Re: web2py hanging after DB error - Windows / rocket / pyodbc / SQL Server

2012-08-20 Thread David Rager
y > complicated queries ? file uploads ? > > On Monday, August 20, 2012 6:35:10 PM UTC+2, David Rager wrote: >> >> Hey all - we have a persistent issue in our staging environment where our >> site will hang after certain DB errors. It feels like a transaction is >&g

[web2py] Re: whats the state of NoSQL in web2py 2.0

2012-08-20 Thread David Rager
Having worked a number of years on MongoDB it generally leads to a good amount of denormalization to get it to work in any framework. If you have used web2py on GAE with the datastore it will probably be a very similar experience. Unless you have large datasets and high concurrency MongoDB m

[web2py] web2py hanging after DB error - Windows / rocket / pyodbc / SQL Server

2012-08-20 Thread David Rager
Hey all - we have a persistent issue in our staging environment where our site will hang after certain DB errors. It feels like a transaction is hanging on the DB but am still confused as we instruct rocket to use multiple threads, so am unsure why it would block other requests. Is it possible

[web2py] Re: Congratulations to Bruno and Mariano

2012-08-20 Thread David Rager
Whoot! Contrats! web2pythorific On Friday, August 17, 2012 8:13:45 AM UTC-6, Massimo Di Pierro wrote: > > Congratulations to Bruno Rocha and Mariano Reingart, > > New members of the Python Software Foundations. > > http://pyfound.blogspot.com.br/2012/08/welcome-new-psf-members.html > > > --

Re: [web2py] Looking for web2py help - is there a group for recruiting?

2012-05-10 Thread David Rager
Thanks for the replies! We have a project building a solar monitoring solution to be used by an O&M group which is going to be installed for about 10 different solar plants around the world - probably expanded past that next year. It is a system that ingests data from multiple devices on a so

[web2py] Looking for web2py help - is there a group for recruiting?

2012-05-09 Thread David Rager
We will be looking for some web2py programming help in June - curious where the best place is to find folks. Is it here? Thanks!

Re: [web2py] MSSQL bit does not evaluate to True for boolean datatype

2012-05-01 Thread David Rager
, 2012 7:26:41 AM UTC-6, Johann Spies wrote: > > > > On 1 May 2012 10:33, David Rager wrote: > >> All - >> Am starting a large-scale project to monitor solar plants using web2py >> and python as the main app layer. >> >> I am also using mssql so I can take

[web2py] MSSQL bit does not evaluate to True for boolean datatype

2012-05-01 Thread David Rager
All - Am starting a large-scale project to monitor solar plants using web2py and python as the main app layer. I am also using mssql so I can take advantage of the column storage indexing as we are logging a large amount of data. The issue I am facing is that MSSQL boolean datatypes (which tra