Looking for a project based on Pyramid which gives JSON API to Oracle database.

[Piotr Dobrogost]

Hi!

I'm looking for a project based on Pyramid which would automatically (based on db reflection) give JSON API to Oracle database allowing for selecting, adding, updating and removing data.

Thank you in advance.

Regards,

Piotr

[Mikko Ohtamaa]

Hi Piotr,

Usually you speak to any SQL database using SQLAlchemy which also offers robust reflection capabilities. However there is usually some manual integration work to map things between JSON and SQL as due do differences in data formats there is no automatic 1:1 solutions.

For Pyramid + REST services Cornice is one of the more mature solutions out there https://pypi.python.org/pypi/cornice

Also check out pyramid_swagger https://github.com/striglia/pyramid_swagger - as a bonus you get the documentation tool and standard.

Another potential (Flask-based) project is Python EVE which offers it own configuration language to expose MongoDB and SQL databases to web: http://python-eve.org/

Cheers,

Mikko

--
You received this message because you are subscribed to the Google Groups "pylons-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pylons-discuss+unsubscribe@googlegroups.com.
To post to this group, send email to pylons-discuss@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/dcc6a84d-1363-466b-83fd-3f5dffafb9c0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Mikko Ohtamaa
http://opensourcehacker.com
http://twitter.com/moo9000

[Jonathan Vanasco]

Assuming that you simply want to create a json api to oracle as an internal service... there are many SqlAlchemy+Falcon projects out there too. 

[Jonathan Vanasco]

Just to clarify the above... there are a lot of incredibly lightweight "plug and play" projects in Falcon that simply expose a sqlalchemy database via json and a restful API.  as an internal service that your existing & secured pyramid app can talk to, they may be a better option than configuring a second pyramid app or framework to do the same.