<story><title>SQLAlchemy and You</title><url>http://lucumr.pocoo.org/2011/7/19/sqlachemy-and-you/</url></story><parent_chain></parent_chain><comment><author>espeed</author><text>This article is by Armin Ronacher, the author of Flask. I use Flask for most of my projects because it&apos;s decoupled from the ORM and provides a clean way for you to use whatever database tool is right for the job.&lt;p&gt;But lately I have moved away from using the relational database as the primary datastore. When I do need a relational database, it&apos;s simple to use SQLAlchemy in Flask.&lt;p&gt;But I have been finding graph databases as a more elegant alternative to relational databases because you don&apos;t have to mess with tables or joins -- everything is explicitly joined.&lt;p&gt;Neo4j is one of the leading open-source graph databases, and it&apos;s pretty sweet -- it can store 32 billion nodes while doing 2 million traversals per second -- and you can use Gremlin with it (Gremlin is a graph query language, like SQL for graphs).&lt;p&gt;The graph-database world is starting to emerge, but most graph databases are Java based so non-JVM bindings are not always available.&lt;p&gt;However, there is a project called TinkerPop (&lt;a href=&quot;http://www.tinkerpop.com&quot; rel=&quot;nofollow&quot;&gt;http://www.tinkerpop.com&lt;/a&gt;) that has made most of the open-source software stack for graph DBs. TinkerPop is the project that developed Gremlin and Blueprints, and it released a REST service called Rexster that is tied to Blueprints so it lets you connect to any Blueprints-enabled graph database, including Neo4j, OrientDB, Dex, OpenRDF, and an InfiniteGraph implementation is being released next month.&lt;p&gt;Because the graph-DB world lacked Python support, I decided to write a Python persistence framework that connects to Rexster so you can now use any of those graph DBs from Python, and binary bindings are in the works. The framework is called Bulbflow, and you can find out more about it out at &lt;a href=&quot;http://bulbflow.com/overview&quot; rel=&quot;nofollow&quot;&gt;http://bulbflow.com/overview&lt;/a&gt;.&lt;p&gt;In a few weeks I&apos;m going to release Flask-based libraries that do authentication and authorization in a graph-DB way.</text></comment>
<story><title>SQLAlchemy and You</title><url>http://lucumr.pocoo.org/2011/7/19/sqlachemy-and-you/</url></story><parent_chain></parent_chain><comment><author>wulczer</author><text>SQLAlchemy supports multiple-column primary keys, Django ORM does not. What&apos;s more to think about?</text></comment>