On how to obtain the connection string to be applied in the “Connect” section of the tool, we can always refer to the “Academy section” (3). This is of course the basic condition to be able to work with Studio 3T. We previously mentioned that there is a direct connection with MongoDB that simply means that you must have an account on MongoDB. I think is a “little bug” that GUI developer could fix in next releases.įig.3 Data View Interfaces with MongoDB – Connection, Query and shell Enlarging it you lose part of the main export window. The “output preview” window is again a good idea but is not well managed on window distribution rel 1.7.1. You can export query result data from any MongoDB environment to any other MongoDB environment. Just a mention also to the export feature.
That is a very useful option in order to keep data aligned from any source. Import operation can also be executed by means of programmed task. In that case my upload speed was 29.1 Mbps (from a wireless endpoint).
It has taken across 20 seconds to be imported and sent to the DB on server.
#DOWNLOAD STUDIO 3T FOR MONGODB UPDATE#
To get fun I tried to import a csv file with more than 18K lines (7 MB) to measure the update speed. When running the import wizard you need to keep in mind that due to the continuous connection with the MongoDB account you will have the new collection imported immediately available on the remote DB. So be careful here.Īnother thing to pay attention to is the handling of the import procedure. The paste operation on the GUI works perfectly, but the copying operation is completely left to the user, and this could be a source of errors. Regarding data import, there is a short but explanatory tutorial (4) in addition, a copy-paste pattern can be used to import data into a collection. A preview is always displayed, and this is for certain another help to the developer. It is possible to set how to treat empty fields or spaces based on the control characters used in textual files to import for example. When importing raw data, this is certainly a help to the developer. Particular attention is also paid to data integrity. I find this to be an efficient and safe approach. 3) allow the modification of the fields intended as value of the key-value pair according to the Json construct, but prevent any modification of the structural part. This is also well explained in one of the youtube lesson in the academy section (3).” The Json view and the tree view are more explanatory of the flexible nature of the data structure of a NoSql DB. The Data Type check is very easily because it could be managed by using separate colors in the table view. Furthermore offers graphic support to view how data are expressed in terms of type. This view offers the opportunity to see the data expressed as if it were the records of a table in a relational DB. The “table view” is the view that is most familiar to developers, as me, coming from the world of relational databases. This tool implements a very powerful system to view, edit and analyze data.Įditing of data is quite simple and available in three possible view: Table view, Json View and Tree View. Speaking of databases, of course we are talking about data and the possibility of manipulating them.
0 kommentar(er)
