Tagged Questions
0
votes
1answer
31 views
Transaction atomicity with MySQL, MongoDB, RabbitMQ
I have a Java project with these 3 datasources: MySQL, MongoDB, RabbitMQ.
I'm trying to find a way to execute "transactions" (because MongoDB isn't, in fact, transactional) on all 3 datasources as a ...
mongodb
0
votes
0answers
19 views
distribute AIR application attached with MYSql database
How can i distibute an AIR application attached with MySQL database. I actually want, that the user should not be bothered with setting up the database ( the way it needs to be done, when installing a ...
0
votes
0answers
20 views
Revers engineering from mysql to mongodb_most suitable method
In mysql we writes,
SELECT *
FROM Student , Course
WHERE Student.course_id = Course.id
AND Course.name = "English"
we can do the same thing in mongodb as(in PHP)
$m = new MongoClient();
$db = ...
-1
votes
1answer
29 views
MongoDB multiple/single collection and MySQL advice [on hold]
I have a project which is using NodeJS and I have different entities for example, people and places.
I need the ability to find both types of entities by location together so what I was thinking of ...
0
votes
0answers
27 views
Piping Javascript output to a custom MySQL table
My setup is as follows:
a) I am running Javascript on a set of figures (sourced from MongoDB) in a Linux command line and getting a set of values.
b) I have a table setup on the same Linux machine in ...
0
votes
0answers
18 views
How to run this is mysql query with mongoDB [duplicate]
I have this query as example:
SELECT id FROM ids WHERE ids IN (1,2) ORDER BY FIELD(id, 1,2)
How to do this in mongoDB ? Many thanks for any response.
0
votes
0answers
26 views
mongodb equivalent of SELECT field AS `anothername`
what is the mongodb equivalent of the MySQL query
SELECT username AS `consname` FROM `consumer`
2
votes
1answer
47 views
Can I move complete MySQL DB from PHP-based site to a Django application?
We have a php based site with MySQL database. We have lots of data there users, orders, invoices and etc. Now we wan to redesign our site application using Django and MySQL or even MongoDB.
It's ...
0
votes
1answer
25 views
MySQL PHP, table inside table (multiple rows per entry)
I have a setup shown below.
On my webpage, we are looking at DOCUMENT #83156. The user made multiple entries in the document. I will have thousands of these DOCUMENT numbers, and some may have no ...
0
votes
1answer
45 views
Select 2 random rows from DB but only select that combo once [closed]
I want to be able to select two random items from a table. I want to be able to continue doing this until every possible combo has been selected but without repeating any combination.
For example ...
1
vote
1answer
39 views
Fast database for big selects [closed]
Recently I encountered the following problem. I need a database in which I store only 4 columns (three fields of type INT and one binary field of length 512 or 1024 bits)
The issue is that i need ...
0
votes
1answer
45 views
Parse json to android applcation from data in mongodb by php web service
I am looking to pull data from by mongodb by the use of php, then convert it to a json object which i can parse to my android applcation.
I can do this for mysql without any problems, but i am ...
android
0
votes
0answers
138 views
Using database in AngularJS - where should I write DB connection code?
I'm now building up a web app using Node.js, AngularJS and either MySQL or MongoDB. However, when I tried to use AngularJS with a controller which includes datasets fetched from database, I wonder ...
0
votes
1answer
40 views
vagrant : chef_solo | how i can change log path from mysql server and mongodb?
I'm working with vagrant and chef .
As far as everything goes , only when I use the Logpath of mysql and mongodb change in the vagrant file , I get an error.
if anyone here has a tip and can help me ...
1
vote
2answers
42 views
Which database engine is most suitable to handle array values? [closed]
The often seen use case is when one store a list of tag to an item
tag: [123,233,...], and the result should be query-able like "getting all rows with tag 233".
Seems like the most advocated approach ...
0
votes
1answer
25 views
How to convert rogue query into Mysql ?
i found a code that written in Rogue that is
Rogue is a type-safe internal Scala DSL for constructing and executing find and modify commands against MongoDB in the Lift web framework
i found code ...
0
votes
0answers
36 views
MongoDB Storage Architecture (MySQL innodb_file_per_table equivalent to MongoDB)
I am new to MongoDB.I looked inside dbpath I found
users.0 - 16.8MB
users.1 - 33.6MB
users.ns - 16.8MB
Further when I dig deeper I found,
The .0, .1 files are datafiles. Each datafile is ...
0
votes
0answers
26 views
Mogo to mysql converting in pentaho PDI
I created on transformation in pentaho PDI which transfer my mongo collections into mysql
for this I used mongodb input and table output, in table output I selected truncate table true. Now my problem ...
0
votes
1answer
46 views
Voting system on NoSQL [closed]
Is it possible/reasonable to have a voting system on NoSQL database ?
For example how would be possible to store StackOverflow question into the NoSQL database.
I can easily imagine almost everything ...
0
votes
0answers
37 views
Mongodb update query using if else construct
I have requirement to update Mongodb collection’s document(i.e row) based on if else construct . Suppose I have collection like
{
"_id":0,
"internal": true,
"external":true,
...
0
votes
1answer
30 views
Manage relations among users in db
I am creating a mock app with user creation/auth/friend in a node js learning exercise. Having spent my time mostly at the front end of things, I am a n00b as far as DBs are concerned. I want to ...
-1
votes
1answer
166 views
Suitable Backend language social networking Node.js/mongoDb or PHP/Mysql [closed]
We are in the initial phases of developing one social networking project and off course have a tough time deciding between Node.js/mongoDb or PHP/Mysql for our backend.
I have read a tons about the ...
0
votes
0answers
23 views
Simulate geoNear or near from mongoDB in MySQL
In mongoDB there is a command called geoNear that return the distance to geospatial point store in DB. Also when I use find function in mongoDB I can use a near filter that return registers in DB that ...
0
votes
0answers
9 views
“Suggested Edit” feature? implementations?
For some content on my site I would like to let user submit suggested edit (just like in facebook when you edit the info of a venue).
I am thinking of having an extra table to store the suggestion ...
0
votes
0answers
6 views
Storing TimeZone and Current in Mysql and MongoDb
I need to store the Time Zone / currency preference for a user in the database.
How can i store the preference settings so that i can adjust the time based on that in MySQl and MongoDB
0
votes
0answers
49 views
mongodb and sql in Entity-Attribute-Value (EAV) pattern
I am trying to understand what applications is mongodb good for? I am working on a system in PHP to use both mongodb and sql to have less overhead on database that does the job not as efficient. For ...
0
votes
0answers
49 views
Multiple users try to change one record at one time
We have too many records in database.
Multiple users try to change one record at one time.
How to prevent the change if the record has changed since read by the client, who wants to change it? ...
0
votes
1answer
44 views
Symfony 2 : use MongoDB as session storage
I have an application built on Symfony 2 using DoctrineORM / MySQL to store data and PdoSessionHandler / MySQL to store sessions.
I am trying to replace DoctrineORM to DoctrineODM to use MongoDB ...
0
votes
0answers
13 views
doctrine does not abstract mysql and mongodb simple queries
Why is it not possible to execute mysql or mongodb queries without changing query? I thought doctrine made it possible, but in fact it does not.(or else I am using doctrine in a wrong way)
Let's say ...
1
vote
2answers
56 views
Start with MySQL and change to MongoDB in the future? [closed]
I'm new to node.js
I have plan to use database other than MySQL (lets say MongoDB), but I'm only familiar with MySQL.
Do you think better to use MySQL first and change to MongoDB in the future? or ...
1
vote
1answer
111 views
Considering a switch from MySQL to either Cassandra or MongoDB for ad-hoc metadata [closed]
I’m in a bit of a rut and considering a switch from SQL to NoSQL. I’m a bootstrap developer who is well-versed in MySQL looking for a potential alternative when considering a project with lots of ...
-1
votes
1answer
30 views
Connect to collections in mongoDB
i m trying to convert a mysql database into mongodb,also i,m use mongodb with php,so need to convert mysql query into mongodb form. but there are no joins in mongodb. if you know easy way to connect ...
1
vote
0answers
48 views
0
votes
1answer
71 views
Null Values by migration from MySQL to mongo
I need to migrate some tables from MySQL to mongoDB. After searching the web, for me it looks like an MySQL export to CSV and an import from that CSV to mongoDB should be the fastest and easiest way.
...
0
votes
2answers
58 views
Does mongoDB has a mechanism like mysql ,which simple import .sql file into database?
As the title goes , I wonder if MongoDB has a data file format to import directly ?I know that mysql has "sql" file format for it to import directly .I am now in a project has the same ...
1
vote
1answer
143 views
How to choose database between MongoDB and Cassandra
Now I want to design a database, and there will be some tables within some dynamic attributes. I can choose a traditional RDBMS like MySQL to implement them with the EAV design model. But now I want ...
0
votes
1answer
83 views
mongodb equivalent for MYSQL concat()
I would like to search the user collection by first_name and last_name keyed in as full_name in the search query. The search query for the full_name would be the first_name separated by a 'blank ...
1
vote
1answer
79 views
How to design a set of database tables with dynamic attributes?
Now I get a problem:
For some items in the same table(category), they may have different attributes.For example there is a table called Product with two items called A and B in it.
And the ...
0
votes
0answers
43 views
2
votes
1answer
122 views
Right database for machine learning on 100 TB of data
I need to perform classification and clustering on about 100tb of web data and I was planning on using Hadoop and Mahout and AWS. What database do you recommend I use to store the data? Will MySQL ...
0
votes
1answer
43 views
Can I serve media to web browser from MongoDB
I will try to keep this simple without lots of extra information. I have been investigating MongoDB and I believe it will work well for my next project. There is one thing I am fuzzy about though: ...
0
votes
1answer
35 views
My rails app use mysql database and AR-ORM, but I want impressionist single use MongoDB
I am using impressionist gem
In my rails app I am using both mysql database and AR-ORM, but I want to use impressionist only for MongoDB.
0
votes
1answer
38 views
1
vote
0answers
46 views
A good approach for writing a lot of data that can be liked or disliked [closed]
I am trying to find a good approach about writing an application that continuously needs to write a lot of data.
For example, it could be a continuous stream of comments for a specific article, with ...
1
vote
1answer
133 views
Count subquery in a select - mongoDB
I want to make a query to get a kind of ranking of users with more tweets in my database mongoDB:
var TeewtSchema = new Schema({
userId: Number,
twweetId : Number,
createdAt: Date,
...
0
votes
1answer
79 views
Risks in using Neo4j as a stand-alone database
I have seen quite a few products with graph-related data models built on both Neo4j and a relational or document database. The other db is generally used to store the metadata of each node.
I am ...
2
votes
1answer
37 views
Select statement where Users.ID=Forum.ID
Is it possible to select a document in MongoDB where one id equals the other? For example:
db.users Collection has the following Document
{ "_id" : 3, "username" : "abc", ..... }
and Collection ...
0
votes
1answer
38 views
Data validation after migrating from msql to mongodb [closed]
I was hoping someone could point me in the right direction. I have moved from a mysql db to mongodb. Is there any tools available to run against the two databases to ensure that the data is ...
1
vote
2answers
63 views
Is there a fast way to do a '%phrase%' search in any DB?
I have a large dataset with 5M rows. One of the fields in the dataset is 'article_title', which I'd like to search in real-time for an autocomplete feature that I'm building on my site.
I've been ...
0
votes
1answer
54 views
Yii: MySQL and MongoDB together
I'm starting quite big project in Yii framework and I'll need to work on MySQL and MongoDB together. And I wanted to ask, if someone have any experience working with this two databases and Yii ...
Community Bulletin
Related Tags
database × 90nosql × 72
php × 69
sql × 30
database-design × 24
node.js × 19
ruby-on-rails-3 × 14
ruby-on-rails × 13
couchdb × 13
javascript × 12
java × 11
postgresql × 11
performance × 10
redis × 10
cassandra × 9
python × 8
migration × 8
rdbms × 7
mongoose × 7
sphinx × 7
django × 6
solr × 6
mongoid × 6
scalability × 5
mapreduce × 5
