[web2py] Re: pyDAL looks abandoned?

2020-08-12 Thread 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 subsc

[web2py] Re: Migrate web2py sqlite application to mssql

2020-08-12 Thread Andrea Fae'
Wonderful! I will test. Thank you so much Il giorno mercoledì 12 agosto 2020 17:17:17 UTC+2, villas ha scritto: > > Here are some notes which you may find helpful... > > The basic idea is this: > >- Create a new DB using your preferred MSSQL management tool. >- Change your DAL connection s

[web2py] Re: pyDAL looks abandoned?

2020-08-12 Thread 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

[web2py] Re: Tip - Using multiple web2py templates

2020-08-12 Thread Joe Barnhart
Doesn't this have an unfortunate negative effect on "compiled" views? To be compiled, everything about the view needs to be known ahead of time and your dynamic use of templates seems to defeat that. I suspect when you choose to "compile" the application from the web2py admin interface, these

[web2py] Re: Migrate web2py sqlite application to mssql

2020-08-12 Thread villas
Here are some notes which you may find helpful... The basic idea is this: - Create a new DB using your preferred MSSQL management tool. - Change your DAL connection string and run the app. - Check that the new DB has all the tables. - Migrate your data Please read the following re

[web2py] Migrate web2py sqlite application to mssql

2020-08-12 Thread Andrea Fae'
Hello, can anyone tell me how to migrate a web2py application with simple sqlite database to a MSSQL 2016 database? Only change the DAL? the system create itself all the tables and database? Thank you very much to who can answer me! -- Resources: - http://web2py.com - http://web2py.com/book (