[web2py] Re: is the auto-increment integer primary key field indexed?

2015-10-22 Thread Anthony
Yes, I think most databases automatically index the primary key. Note, web2py stores the database timings for the queries in a given request (which can be viewed in response.toolbar(), so you can compare the speed of different queries). Anthony On Thursday, October 22, 2015 at 7:22:35 PM UTC-4

[web2py] is the auto-increment integer primary key field indexed?

2015-10-22 Thread Alex Glaros
is the default primary key indexed? I mean if I had 1 million addresses, with countryID as a foreign key, would the look-up be faster searching on primary key or would it take same time as searching on something like foreign key country_code "US", "MX", etc.? thanks Alex Glaros -- Resources:

Re: [web2py] Re: nginx setup: [Errno 13] Permission denied: '/root/.python-eggs'

2015-10-22 Thread Luciano Laporta Podazza
Hello again, So I did recreate the VPS and everythng worked as expected :/ Even so, it still throws the "setup.sh: 5: setup.sh: [[: not found". I just logged in as r...@mydomain.com and call the setup.sh script. Thanks a lot for your help!!! :) On Thu, Oct 22, 2015 at 6:22 PM, Niphlod wrote:

[web2py] Re: Oracle drivers.

2015-10-22 Thread Michael M
Is it Possible that the DAL is talking Python 3.4 when my driver is Python 2.7. So when I call it in Web2py from CLI it works but when the framework is running its trying to call 3.4 to talk to cx_Oracle? See below: 2.12.3-stable+timestamp.2015.08.19.00.18.03 (Running on Apache/2.4.6 (Red Hat E

[web2py] Re: Oracle drivers.

2015-10-22 Thread Michael M
Tried it again. This time I tried on another RHEL 7 server. Downloaded Oracle's Instant Client Zips and extracted all of them instead of installing RPMs Same with the cx_Oracle Module. didnt install the RPM got the source and complied. I set the envoirment variables export ORACLE_HOME=/usr/i

[web2py] Re: nginx setup: [Errno 13] Permission denied: '/root/.python-eggs'

2015-10-22 Thread Niphlod
this log smells about a not-so-fresh installation (seems more like a second run of the same script). Apart from that (drop the VPS and recreate a fresh one), there is a weird error at the top which points to being in an unusual environment (setup.sh: 5: setup.sh: [[: not found) how did you get

Re: [web2py] Re: Enabling Google Sign-In

2015-10-22 Thread Michele Comitini
yup it would be nice if it were maintained and moved to github... 2015-10-22 17:40 GMT+02:00 Niphlod : > I didn't know about w2p-social-auth and I'm starting to thinking that we > should "promote it" and discourage all social-own-cooked pieces inside > contrib/login_methods... > > > On Thursday,

[web2py] Re: How to update db record using ajax?

2015-10-22 Thread Edward Shave
Thanks a bunch for your very detailed reply. After reading your post I have managed to get a version working just the way I want. Thanks again, Ed -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/

[web2py] Re: Table migration problem on GAE Cloud SQL (locally)

2015-10-22 Thread Sébastien
Might this be a bug on GAE? Could someone confirm that on GAE migration is fine? On Saturday, 17 October 2015 13:13:21 UTC+2, Sébastien wrote: > > Hello, > > I am working locally on GAE (with Cloud SQL) and I can't seem to be able > to add a new field to a table. I keep having 'xxx.table appear

[web2py] Re: Google Cloud SQL: Unable to connect

2015-10-22 Thread Sébastien
Is it happening locally? Did you install MySQLdb? I app.yaml you have to add under "libraries" - name: MySQLdb version: "latest" Finally you have to add your MySQL credential to dev_appserver.py like: dev_appserver.py [root folder of web2py] --mysql_user=[mysql user] --mysql_password=[mysql

[web2py][share] usefull snippet for enhance list of tags to be displayed in a table cell (or TD)

2015-10-22 Thread Richard
Hello, When building from scratch an HTML Table with web2py helper I found myself needing to split list of A() tags with CAT(', ') tag to proper display of tags list in HTML. So, I have write this little snippet that I found usefull for that : def cat_comma_snippet(tag_to_be_split_with_cat_com

Re: [web2py] Re: Enabling Google Sign-In

2015-10-22 Thread Niphlod
I didn't know about w2p-social-auth and I'm starting to thinking that we should "promote it" and discourage all social-own-cooked pieces inside contrib/login_methods... On Thursday, October 22, 2015 at 1:27:35 PM UTC+2, mcm wrote: > > > http://web2py.com/books/default/chapter/29/09/access-contro

Re: [web2py] Re: Ractive and Single Page Apps

2015-10-22 Thread Rod Watkins
This looks cool. I had not found this. I plan to study it today. Rod On Thursday, October 22, 2015 at 3:17:00 AM UTC-7, mcm wrote: > > This ractive extension could be of interest to you IMHO: > > http://ractive-require.codecorico.com/ > > 2015-10-22 10:11 GMT+02:00 p a >: > >> Two more comments: >

[web2py] Re: Ractive and Single Page Apps

2015-10-22 Thread Rod Watkins
The redirection trick is good to know. Little gotchas like that can drive you nuts. I'll put this in my vault for later when I try to learn how to use ractive for my app. On Thursday, October 22, 2015 at 1:11:13 AM UTC-7, p a wrote: > > Two more comments: > > - I don't intend to push all logic

Re: [web2py] DAL alternatives

2015-10-22 Thread António Ramos
I agree with you except for the "kept secret" because it keeps away people that could help make it even better. and yes, i meant pyDAL 2015-10-22 14:53 GMT+01:00 Richard Vézina : > Do you mean pyDAL? > > If so, you have to consider that it is very young and may still seems to > be web2py related

Re: [web2py] DAL alternatives

2015-10-22 Thread Richard Vézina
Do you mean pyDAL? If so, you have to consider that it is very young and may still seems to be web2py related which may make poeple think that they can't use it without web2py... I use to refer many StackOverflow asker to pyDAL as a way to solve their issue, I guess word of mouth is not in use en

[web2py] DAL alternatives

2015-10-22 Thread António Ramos
Why is there very litle interest in the DAL github repo (very litle forks and stars) ? Are people using better alternatives or does it suffer from some lack of publicity or even worse, people dont like it because they dont like web2py either. Regards António -- Resources: - http://web2py.com -

Re: [web2py] Setting up database table with date.

2015-10-22 Thread Garry Smith
Hi I am using MySQL database, the default format for date is is -00-00, which is *-MM-DD*. I read you could change the format, which I tried with no effect. What I did in the end, is change all the dates in a spreadsheet to match -mm-dd, which then let me import the data. Thanks f

Re: [web2py] Fwd: aiosmtpd 1.0a1 - asyncio-based implementations of SMTP/LMTP

2015-10-22 Thread Michele Comitini
Works on python2.7? or only 3.5? 2015-10-20 16:06 GMT+02:00 Massimo DiPierro : > This is nice if you want a pure python SMTP server > > Begin forwarded message: > > *From: *Barry Warsaw > *Subject: **aiosmtpd 1.0a1 - asyncio-based implementations of SMTP/LMTP* > *Date: *October 20, 2015 at 8:51:

Re: [web2py] Re: PostgreSQL

2015-10-22 Thread Michele Comitini
Couldn't agree more. Well engineered from the ground up. Been using it for 20+ years, I saw it steadily improving by giving little attention to the fuzz of the moment. I must admit that I become so spoiled, that if something new and really useful appears on the scene of DBs I wait postgres to impl

Re: [web2py] Re: Enabling Google Sign-In

2015-10-22 Thread Michele Comitini
http://web2py.com/books/default/chapter/29/09/access-control?search=oauth#Other-login-methods-and-login-forms Grab the file google_auth.json from the google developer console and put in private dir of your app put code similar to the one below in db.py: from gluon.contrib.login_methods.oauth2

Re: [web2py] Re: Ractive and Single Page Apps

2015-10-22 Thread Michele Comitini
This ractive extension could be of interest to you IMHO: http://ractive-require.codecorico.com/ 2015-10-22 10:11 GMT+02:00 p a : > Two more comments: > > - I don't intend to push all logic to the server, but only the "view" part > in web2py. My long term goal is to have a working API, and many r

Re: [web2py] Voting In Massimo's Week 2 Video

2015-10-22 Thread Vinicius Assef
Do you have the link for the videos? -- Vinicius Assef On 22 October 2015 at 02:49, Joffrey Baratheon wrote: > In Massimo's week 2 video for Web2py, he went over a Reddit style app. He > never explained how to implement the vote button even though he created the > infrastructure for doing so. H

[web2py] Re: Enabling Google Sign-In

2015-10-22 Thread Leonel Câmara
I would try to use this: https://code.google.com/p/w2p-social-auth/ -- 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

[web2py] Re: Ractive and Single Page Apps

2015-10-22 Thread p a
Two more comments: - I don't intend to push all logic to the server, but only the "view" part in web2py. My long term goal is to have a working API, and many ractive components that can be combined in different ways, and allow to show data and/or interact with it independently. Then a person jo