I'm building a PHP/MySQL website and I'm currently working on my database design. I do have some database and MySQL experience, but I've never structured a database from scratch for a real world application which hopefully is going to get some good traffic, so I'd love to hear advices from people who've already done it, in order to avoid...
Hi, Is it possible to use Lucene as full fledged data store (like other(mongo,couch) nosql variants). I know there are some limitations like newly updated documents by one indexer will not be shown in other indexer. So we need to restart the indexer to get the updates. But i stumble upon solr lately, it seems these problems are avoid...
One of those questions that's difficult to google. We were running into issues the other day with speed of our svn repository. The standard solution to this seems to be "more RAM! more CPU!" etc. Which got me to wondering, are there any source-control systems that use a document/nosql database (mongodb, couchdb etc) for database? It se...
I'm building a simple accounting system where a user has many bills. Now I'm trying to decide if bills should be its own collection, or nested within the user. I'm leaning towards the former but I've NEVER done any noSQL stuff so I'm just going by trial and error and what I think makes sense to me. I understand that Mongo has a 4mb ...
Possible Duplicate: moving to NoSql Hi, What are the top reasons for using no-sql solutions rather than rdbms? Thanks! ...
Is there comparation which NoSQL is designed for what purpose? I'm especially interested in querying large amount of data practically read-only. Edit: I mean comparation between NoSQL databases not about comparation with SQL databases. ...
Had gone through some NoSQL concepts and MongoDB & CouchDB articles. It seems they will give more scope to build scalable web applications. But need some clarity whether they will support the following features as SQL Server does? Whether it supports database mirroring? Is there any size limitation of NoSQL database? Is it better to ig...
I think one of the advantages of no-sql such as MongoDB is that it can scale horizontally automatically: just add a cheap machine and the data can "spread over" to the new machine. How about for RDBMS, does any RDBMS do that automatically too? ...
I want to store a graph of millions of nodes where each node links to another in an undirected manner (point A to B, automatically B points to A). I have examined Neo4j, OrientDB as possible solutions but they seem to be oriented in directed graphs, and Neo4j not being free for >1 million nodes is not a solution for me. Can you help me...
What do you think would be the best non-sql database for storing info of players in a real-time MMO game that runs on a C++ server? ...
I know this is another question on this topic but I am a complete beginner in the NoSQL world so I would love some advice. People at SO told me MySQL might be a bad idea for this dataset so I'm asking this. I have lots of data in the following format: TYPE 1 ID1: String String String ... ID2: String String String ... ID3: String String...
I am inserting my data into MongoDB and had 240 such files. Instead of inserting everything into one big collection, I was thinking of inserting the files as a collection by themselves. Is this a good idea if I do a lot of queries on a commonly indexed column? If so, how can I initiate a query to query all the collections in my databas...
I am playing with MongoDB since yesterday and absolutely love it. I am trying to import lots of data (2 billion rows) and index it but it doesn't seem to be using the 8 cores that my system has adn the import is going at normal rates (60000 records/sec). I can only imagine how long it might take to index two columns in this collection. A...
I've been hearing a lot of talk about schema-less (often distributed) database systems like MongoDB, CouchDB, SimpleDB, etc... While I can understand they might be valuable for some purposes, in most of my applications I'm trying to persist objects that have a specific number of fields of a specific type, and I just automatically think ...
Looking around for a noSQL database implementation that has an ORM syntax (pref. like Django's), lets me store and retrieve nested dictionary attributes but written entirely in Python to ease deployment and avoids Javascript syntax for map/reduce. Even better if it has a context-aware (menus), python-based console, as well as being able ...
Good afternoon all, I'm interested in trying to use Voldemort from a windows C++ application. The example provided only works on Linux. ...
I'm currently evaluating possible NoSQL WideTable systems for use as a storage backend for an experimental project I'm working on but I'm struggling with the fact that many of these seem to have vague/incomplete documentation and it's hard to determine whether a specific feature is supported. Specifically I need to be able to do queries...
Is there some NoSQL solution written in PHP (perhaps NoSQL front end to MySQL or PostgreSQL)? I need to store and search for key/value pairs in my PHP scripts, but I need to run it on webhosing where I cannot to install anything (so CouchDB, MongoDB etc. is not solution for me). I need something that supports somethinq like this: // se...
I'm having a very hard time getting this working; not even totally sure that it's possible. Let's imagine a simple scenario: class Employee { List<ITask> Tasks {get;set;} } And say we have two different implementations of tasks. If I want to save the Employee object in MongoDB as a single document (the right way to do it I think)...
Hi! Sorry for maybe stupid question;) I am trying to model records like if they were modeled for twitter. It is interesting for me how big or small they are? Is it normal that they can be bigger than 512 bytes per record? And what methods do you know for optimization records within json documents? I mean especial for json;) Maybe some...