*IF* you determine that web2py is too hard to integrate with your system...
You might look at repoze.BFG. It's a python-based framework that inherits some of the best features of Django and Pylons, and can integrate with "any" (R)DBMS or ORM, quite easily. Good luck with your project, -r. On May 14, 2010, at 10:21 AM, Jean6uy wrote: > Hi, > > I googled a lot on this topic before send this email. > > I am kind of postgresql newbie and of course also with web2py. > > I have already designed a database with PGAdminIII that respond to my > need that has already around 50 tables with many foreign key > relationship. I use schemas to group my tables... > > I need to manage all the constaints at the database level for > conformity questions and audit of database by authority agencies... I > will keep track of any modifications done in the database with > triggers to allow to keep the history of modifications in the > database. So I will have a second set of 50 tables... > > Now I need a GUI to let lambda user populate the database, so I am > looking at all python framework (Django, web2py, ...) to find the one > that will handle the job with ease and flexibility... > > Web2py seems a good choice for the task... But like Django, it create > table in public schema when used with postgresql (public.TABLE)... > > This post pointed out many of the requirements of data centric > application needs that are not yet fully implemented in web python > frameworks in general : > > http://it.toolbox.com/blogs/database-soup/stuff-id-love-to-see-from-django-36278 > > > I find here (http://nxsy.org/using-postgresql-schemas-with-sqlalchemy- > and-elixir) that it could be possible to use PostgreSQL Schema with > Elixir and SQL Alchemy. What I understand is that the DAL is the > equivalent of SQL Alchemy... I try this : > http://www.web2py.com/AlterEgo/default/show/189. > But it seems to me that it's only a way to let use the synthaxe of SQL > Alchemy in web2py models since SQL Alchemy is not installed. > > Is the explanation here can let me use SQL Alchemy instead of the > DAL : http://www.web2py.com/AlterEgo/default/show/150 ??? > > Can I use Elixir to allow web2py understand the postgresql schema? > > Is it planed to implement the management of postgresql schema in the > DAL as seems to suggest the answer of reingart in this post : > http://it.toolbox.com/blogs/database-soup/stuff-id-love-to-see-from-django-36278#3223746 > > > Please forgive me my dreadful english (thank to google translate) > > Thanks > > Johny Russ Ferriday - Topia Systems - Open Source content management with Plone and Zope ru...@topia.com - mobile: +1 805 234 6915 - skype: ferriday