There are plenty of advices even in just UT: Wavemaker, Web2py, qooxdoo, Jrapid, Ruby on Rails and Dabo. Everyone say "mine is best"... What will I do... :(

>>PS: As far as I am concerned, I have used python on the web and liked it and on my way back to use it via wxpython to translate a significant code base from foxpro to plain vanilla python:) I'd be glad to get pointers on "best practices" to replace cursor-based and local sql DML operations within python. I'be be glad to avoid running via additional database layers whenever possible!
>
>I realize you said that you did not want added overhead with an added layer. But I have found Dabo (www.dabodev.com) to be everything I need to create large CRUD apps (I completely replaced a 200,000+ line VFP app using Dabo). I find it easy (matches the thinking and why "code book" worked) to use. Most people that complain about Dabo don't like the installing issues, Sizers, and the learning curve. For me - I had used several of the VFP frameworks and found that after a short period I was able to create good strong apps - the same can be said for Dabo. One of the nice things about Dabo is there is nothing in the way that would prevent the developer from using the underlying lib's - wxPython, the database connection or any other required lib for your project.
>
>That said, I use Postgres and use psycopg2 daily. I discovered early on that Postgres is as good (if not better) than any other database and that includes MS-SQL, Oracle, and MySQL. Each of those databases have special features but so does Postgres. BTW Dabo supports those databases and others. I used psycopg2 from the start - but I also like pg8000 (pure python). One of the nice things about python is the fact data access returns cursors (not exactly the same as VFP but similar). This immediately made using data easy. BTW Dabo adds the ability to use the return cursor just like a VFP table (scan, filter, SQL statements, etc..).
>
>The next problem you will face is associating the data with the screen controls. I have seen many examples of how to get that done. But Dabo has all of that built-in. In Dabo it's easy - just add the table and the field to the control (DataSource = 'tableName', DataField ='fieldName'). Dabo even has a screen/form builder (includes the properties etc... for any object). I don't use it - but others do daily.
>
>Then you'll need a report writer. Dabo has one built-in. I use it all the time but it does not completely meet all my needs. I need to output PDF's, excel spreadsheets, IM, phone texting, and email. Turns out all of the python lib's are available to get all of it done. Dabo even has a remote solution availabe (I haven't use it yet).
>
>I you are replacing VFP desktop apps I believe there is nothing better than python and Dabo.
>Johnf