Tagged Questions
1
vote
3answers
91 views
Relational vs Non-Relational Database for Events Database
I'm trying to find out whether an SQL or no-SQL solution would be better for creating an events database. I'm creating a ticketing system, similar to ticket master. I know that for either ...
-2
votes
1answer
147 views
Compare MongoDB and MySQL
Can anyone help me to make right decision for choosing scalable and reliable database?
I have to create 3-4 tables with around 200 columns each and these tables will have around 5000 data records. As ...
1
vote
1answer
112 views
Where do caching servers conceptually fit in my architecture?
Given the simple well-known architecture below:
Where (conceptually) does the caching server(s) sit?
5
votes
1answer
168 views
How to store and query products the price of which depends on a complex set of conditions?
I haven't decided on a database. I have expirience with MySQl and I'm intrigued by MongoDB.
Let the products be packages of cable tv providers:
{
name: "Virgin TV",
price: 20
},
{
name: ...
4
votes
1answer
222 views
Would appreciate some suggestions on how I should model this data
I am setting up a website that will have users. Users can search for songs and (if signed in) save them to a playlist or their library of songs.
I want it to be like iTunes in that all the songs on ...
5
votes
1answer
438 views
In MongoDB, is having lots of small collections better than having one huge collection?
Huge collections have huge indexes that may not fit into RAM. Is that problem entirely solved with sharding ?
If I have lots of small collections with small indexes, what are the options for storing ...
