Posts by Gonçalo • 109 points
5 posts
-
1
votes1
answer794
viewsQ: Reference collections in mongodb
I have a model of an airport in mysql and I intend to upload it to mongodb via links between collections. In the following images are examples of documents from my collections. (Airplane, Airport…
-
2
votes1
answer225
viewsQ: Reference or embed documents in mongodb and couchdb
I’m thinking of creating referenced documents instead of embedded because I have a database where a plane has flights and flights have airports. Someone experienced enough to tell me the best…
-
1
votes1
answer266
viewsQ: Query to multiple tables in mysql
My model is the following, I have 4 tables Avião (tailnum (PK), year) Voos (id_voo (PK), cancelled) Modelo (idmodel (PK), nome) Fabricante (id_fabricante (PK), nome) Airplane is with a 1:M…
-
4
votes1
answer518
viewsQ: How to upload data to Mysql faster?
I have a DER that represents an airport and I have to upload data from several csv. for example I have a 1-to-many connection, by plane for flights. If I have this table connected with the foreign…
-
2
votes1
answer1038
viewsQ: How to load JSON in Mysql, including JSON specific fields
I wonder if someone could help me with a question that’s been slaughtering me? First, I am trying to upload this JSON to Mysql { "business_id": "fNGIbpazjTRdXgwRY_NIXA", "full_address": "1201…