Tagged Questions
-1
votes
0answers
20 views
optimizing MySQL for traffic analytics system
background :
I've developed a URL shortener system like Bitly with same features , so the system also tracks clickers info and represent as graphs to the person who has shorten the link as ...
-2
votes
2answers
39 views
Converting from a SQL Syntax to MongoDb Syntax Issues [duplicate]
I have been doing my Homework regarding mongodb and PHP and honestly, I'm fairly new at this and this is my first post at SO.
What does"." operator do in PHP?
For example
$cmd = "SELECT ...
0
votes
0answers
16 views
How to easily switch database type (MySQL and MongoDB) in rails without duplicate models code?
For a project, i need to be able to deploy it with either MySQL or MongoDB (I'm currently using mongoid for that). My question is, is it possible to make "standard" models (especially about the ...
0
votes
1answer
19 views
How to: log and anlyze clicks, pageviews and sessions to optimize conversion
We have a medium size e-commerce site. We sell books. On said site we have promotions, user recommendations, regular book pages, related books, etcetera. Quite similar to amazon.com except ofcourse ...
-2
votes
1answer
25 views
Need help converting a mysql syntax to mongodb
I am trying to convert the following mysql syntax to mongodb syntax, pretty much confused. Can someone englighten?
Moreover, is there any reference which I can take while doing this?
MySQL:
$cmd = ...
0
votes
1answer
45 views
mySQL tree relationships with complex entities
I'm busy putting together a database with a structure as follows:
Table named articles has a 1-to-many relationship with the table named field_groups. field_groups has a 1-to-many relationship with ...
0
votes
0answers
26 views
How to model table in order to query large amounts of dependent data
I have many log records in the following format
a_id, b_id, c_id, count, x_id, y_id, z_id
The object relations are as follows
a has_many b
b has_many c
c has_many y
y has_many z
I am looking to ...
1
vote
2answers
20 views
Do categorical fields need indexing? (MySQL or MongoDB)
For a table(let's say 'food'), there is a column 'type' with potential value [1,2,3,4] that specifies the type of that entry (e.g. fruit). As I expect selection like
SELECT name FROM food WHERE ...
-1
votes
1answer
28 views
Filesystem backend
I am building an project where users can store files. They can also create folders in them. I am going to use AWS S3 for storing the files. These files can be shared with other users also. Now looking ...
-1
votes
0answers
29 views
How much will I pay if I use Amazon RDS for my 70 million data per month, and what if I use DynamoDB [closed]
I am thinking about to host my DB to Amazon, because for some stages I need to receive 100 million data per day and I don't wanna build my own Datacenter...
In the experiment, if saved in MongoDB, ...
1
vote
1answer
28 views
Can grails work with MySQL and MongoDB in the same application?
I am planning to write an application. Some data I plan to place in a relational database, while others on MongoDB. Is it possible to use both database in a single Grails application?
2
votes
2answers
35 views
How to fix a table size in MySQL?
Is there a way or an option available in MySQL to fix the size of a table? Which will work as a circular buffer and overwrites the old data whenever a new data gets inserted. This is useful when an ...
0
votes
0answers
37 views
Personal newsfeed architecture with groupping, pagination and filters
We are building large newsfeed with groupping events by object, filters, pagination.
Use case1: user comment meet. Then he will get updates about this meet (comments, somewho joined to it, photos ...
0
votes
2answers
64 views
MongoDB for small datasets
Are there any benefits to using MongoDB for a Node.js application rather than a traditional SQL database such as MySQL, if I'm not planning to have large (>1000 item) collections and am already ...
0
votes
1answer
63 views
Should I use MongoDB for website email marketing?
I have just researched Mongo DB & see that it has many advantages. I’m working in a web project providing email marketing service. In the previous email marketing script I used (ActiveCampaign), ...
