This looks fantastic. A great example of a fantastic real-world app developed
with Web2py. Great job!
John
--
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)
For authentication, Okta, Azure AD B2C, etc. are options that offload a lot
of trouble, but I like having a fully-functional Auth built-in and we do
use it in some projects. It needs full OIDC support. YMMV. We build
scalable back ends with Web2py using Postgres and Nginx.
John
On
João,
No, SQLite transactions are not only ACID, the Isolation is Serializable,
which means even if the execute concurrently, the result should be same as
if they executed in series (on after the other). What @Anthony describes
should not be necessary, since you already in a transaction.
Thanks, Massimo. Will this work for multiple tables? When I write:
formargs={'Wordlist': dict(separator=': '), 'Wordlist2word': dict(separator=':
')}
this works for the first table, but when I navigate into the second table
via a linked field, the arguments don't seem to be picked up. I ask
dvdb = setupdb(gethostconfig(servername), getappconfig("devicecontrol"))
dvdb.Wordlist.longdescription.widget = SQLFORM.widgets.text.widget
form = SQLFORM.smartgrid(dvdb.Wordlist, args=request.args[:1], paginate=100,
formargs=dict(separator=': '), breadcrumbs_class='breadcrumbs')
Works, but
Joe, I'd be curious to know how you feel MySql performs in comparison to
Postgres.
On Friday, September 16, 2016 at 2:28:09 PM UTC-7, Joe Barnhart wrote:
>
> I've been using PostgresSQL for my production site for quite awhile. My
> future improved site, however, will feature MySql for its
Greetings. db.executesql() is taking 10 times longer than it should to run
a query in Web2py, and I can’t figure out why. This is causing a huge
bottleneck in my application.
In the example below, the Web2py times are all over the map, ranging from
10ms to 500ms, whereas the query runs
7 matches
Mail list logo
