*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

Reply via email to