On Mon, 2009-06-22 at 10:33 +0300, Burak Arslan wrote:
> Gene Amtower wrote:
>
> >
> > Thanks for the encouragement - at least I hope you're not suggesting
> > by your comment that I should be discouraged.
> >
>
>
> no no not at all. i just can't find a proper way of saying "bon
> courage" in english.
>
>
> > > >
> > > > Oracle can support reading and writing of XML strings, so it would
> > > > conceivably be easy to add both xmlrpc and soap support at some later
> > > > point in time. I don't know how much demand there is for XML formats
> > > > over JSON within the current Qooxdoo community. I also think SOAP
> > > > might be too heavy for a standalone application. I think it's more
> > > > appropriate where several existing applications need to be able to
> > > > query each other to minimize re-development effort.
> > > >
> > > > I see that your SOAP contribution uses Python on the server. So does
> > > > it just add another layer into the request/response process that would
> > > > call Oracle via HTTP through mod_plsql or would it connect to the
> > > > Oracle database through an Oracle client driver within Python,
> > > > providing all of the RPC processing internally?
> > >
> > > i think the latter would be the optimal solution.
> > >
> >
> >
> > I agree with you in the context of a Python-based SOAP client; I
> > just wasn't sure which approach your solution took in order to
> > manage different transmission protocols. I haven't seen anything on
> > a python-based Oracle client, but maybe you know of something out
> > there. I'm also not experienced at all in Python development, using
> > it solely for the Qooxdoo tools at the present time.
> >
>
>
> i'm only doing transmission over http(s). i connect to the database
> via native database libraries.
>
> sqlalchemy is the de facto orm and a cross database imperative sql
> generation library for python. it's a good start that handles lots of
> things for you.
>
> it has a feature called "database reflection" that deduces the table
> structure by directly looking at the database -- the exact thing i
> imagine you'll need as your database schema is defined somewhere else.
>
> http://wiki.oracle.com/page/Python
>
> could also be of interest, but i'd imagine most of the work depicted
> there is already done by sqlalchemy devs.
>
>
> best regards,
> burak
Hmmm, brain churning on new input (state:lowCaffieneLevel)...
Result:
Since your python solution only supports http(s), I don't think it
offers distinctive advantages over a mod_plsql solution.
I think I'll proceed down my current path of an Oracle RPC via mod_plsql
rather than adding another code environment that requires an external
connection to the Oracle database. I think most of the performance
results I've achieved with my mod_plsql web development is because of
the tight integration that Oracle provides between the code and database
layer, and I've seen this difference dramatically in the past.
Thanks for all your input - I'm off to drown in RPC-land now.
Gene
------------------------------------------------------------------------------
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
_______________________________________________
qooxdoo-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
