Yes. web2py works with Oracle. Marcel Leuthi from Switzerland ported
it.

0) Install python 2.5

1) you need to install this driver http://cx-oracle.sourceforge.net/

2) download web2py source

3) In your apps, in the model(s) connect to oracle using

      db=SQLDB('oracle://[URI]')

where URI the URI of your oracle database, probably something like:
[EMAIL PROTECTED]

The URI is the same for SQLAlchemy or Django. They are all based on
Oraclecx driver.

web2py has better Oracle integration than those other systems. For
example

    db().select(db.table.ALL,limitby=(10,30))

does pagination (skips 10 records and returns the next 20). Oracle
does not have an API for pagination but all systems find a way around.
Django does it with two nested selects. web2py does it with 3 nested
selects, which is the fastest way, as explained in the official Oracle
documentation.

Massimo


On Nov 11, 9:02 pm, red <[EMAIL PROTECTED]> wrote:
> Does Web2py work with Oracle Rdb as the backend database?  If yes, how
> do I make this work?
>
> I am trying to search for Python Web frameworks that work with Rdb.  I
> am currently looking at Web2py, Zope Django and Webware.  I am new to
> Python and searching for web application tools.  Thank you for your
> input.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to