Hi,

although I have the same problem as Avraham with getting a close view on your schema I will try to add my 2 cents to your question.

Alex Mandel schrieb:
Unless you have a specific need of a NoSQL feature the fact that you have many related tables seems a better use case for SQL relational database.

In general I Think Alex is right that one should use NoSQL only if there is a special need to do so (like scalability or frequently changing schemas, you name it ...).

So what might be the options in a NoSQL-world:

Either a document store or a key-value store.
With both there is no native support for relations. With a document store you might use something like nesting related entities but that reaches its limits when it comes to m:n-relationships. With a key-value-store you can of course store relations by storing the related object's id under the parent's key. This should also work for many-to-many-relationships.
But to me both tools seems to be abused using them this way.

What imho might be an option is a graph-database because by definition this is highly normalized and has all the relations already in place. Maybe you want to have a look at Neo4j (http://www.neo4j.org/) which provides you with a property-graph-engine.

There is a library which claims to integrate Neo4j into Django (https://github.com/scholrly/neo4django). There are other python libraries as well (s. http://www.neo4j.org/develop/python).

I tried py2neo but not enough to finally judge it.

I played with Neo4j using their Webinterface and I liked the idea of storing data as graphs very much.

So maybe you find a way to fit your model into a graph structure and can find out if your typical queries will be supported by Neo4J.

Feel free to send me your schema and I will try to have a look at it with regard to Neo4j (but w/o promising that this might be of much help ;-) ).

With best regards

Carsten Reimer


--
Carsten Reimer
Web Developer
carsten.rei...@galileo-press.de
Phone +49.228.42150.703

Galileo Press GmbH
Rheinwerkallee 4 - 53227 Bonn - Germany
Phone +49.228.42150.0 (Zentrale) .77 (Fax)
http://www.galileo-press.de/

Managing Directors: Tomas Wehren, Ralf Kaulisch, Rainer Kaltenecker
HRB 8363 Amtsgericht Bonn

--
You received this message because you are subscribed to the Google Groups "Django 
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to