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.