+1 on this. It's in our 2 year plan for a major client.
On Feb 16, 6:48 am, TheSweetlink <[email protected]> wrote: > Hello, > > I have been using OrientDB and web2py quite successfully for some > months now. > > While there are many great projects and efforts to combine these > powerful programs, I do not know of the current status of the web2py > <---> OrientDB adapter. > > Bulbflow is a great project too but I could not use it due to OrientDB > specific features that I needed for my project. > > Neo4j has had great progress as well. > > I ultimately chose OrientDB for several reasons which made it the best > fit for my projects. Here are some of those highlights: > > 1) multi-master (as far as I know you must pay for commercial license > to get multi-master in Neo4j) > > 2) the Apache 2.0 license is very liberal. > > 3) Luca and the OrientDB community are as turbo fast and helpful as > the web2py community. Luca can get patches out in hours to days, not > months to years. > > 4) SQL syntax + Gremlin graph traversal language = untold power to > grow/analyze your graph dbs. > > 5) Much more...for details see orienttechnologies.com and click "Learn > More". Do read the entire wiki as there is good documentation and > more coming frequently. > > As for getting OrientDB to work with web2py, I have had to write > custom modules to do basic CRUD and used OrientDB's built-in console > to create my schema/maintain the DB. > > I've experienced great success with using requests and ujson python > libs to move data back and forth from web2py <--> OrientDB > > For Auth I still use a db which will work with web2py's amazing DAL. > I'm sure with enough time you could hack the two to work together but > I prefer to use something proven for auth until such time OrientDB is > included in the DAL. > > Massimo has expressed interest in including OrientDB within the DAL > but I would assume that this will take quite some time as he has much > higher priorities for web2py to get to first. > > I highly recommend the combination of web2py and OrientDB. It will > take some customization, but once running you will be able to do > things that web2py + traditional RDBMS simply cannot do. > > Some of my apps have experienced 10-100x performance boost due to no > longer using JOINS to get data but rather traversing my graph. > > Best of luck, > David > > On Feb 13, 12:54 pm, Nolan Nichols <[email protected]> wrote: > > > > > > > > > I'm researching the nosql and graph database landscape for a web2py > > application that will require the schema to evolve over time and > > provide network/graph analysis metrics. > > > I started by looking at the Tinkerpop (http://tinkerpop.com/) stack > > and the Bulbflow (http://bulbflow.com/) python library for interacting > > with Tinkerpop graph databases like Neo4j and OrientDB. > > > It looks like there was interest a few months back in adapting > > OrientDB's sql interface for web2py, and there is an open issue: > > > -http://code.google.com/p/web2py/issues/detail?id=407 > > > A few questions: > > > What is the current status of an OrientDB/web2py adapter? > > Is anyone currently using a graph database with web2py? > > Any suggestions for using web2py DAI/templates with non-rdbms sources? > > > Cheers, > > > Nolan
