|
| [WD19] Using big data NoSQL |
| Iniciado por guest, 02,nov. 2014 19:23 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 02,noviembre 2014 - 19:23 |
Hi.
I have WD 19.
One of the new features is:
Quote
WX19-NewFeatures
162.Using big data, NoSQL
Big Data data management can be done with WINDEV or
WEBDEV.
A use example for Big Data via the MongoDB Nosql database is
provided
But I cannot find the provided example anywhere.
Thanks.
José Antonio Garrido. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,noviembre 2014 - 09:51 |
Hi José,
Try looking in the; "Windev 19 > Training" folder I can see the "WD MongoDB" project. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,noviembre 2014 - 10:43 |
Thanks.
It comes with an Internal Componenet and I tested it and works OK.
I Tested with two distinct system:
-Ubiquiti UNIFI Controller. Centralized management of Wifi infrastructure.
-Ubiquiti mFi Controller: Centralized management of domotic devices (sensors, power plugs, etc).
Both of them stores all the information in a MongoDB database.
Regards,
José Antonio. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 04,noviembre 2014 - 16:08 |
Hello Jose:
Can you explain how do you use this component with Ubiquiti mFi Controller?
Thanks
Gus |
| |
| |
| | | |
|
| | |
| |
| Publicado el 04,noviembre 2014 - 18:26 |
Hi. Gus.
The mFi Controller database has about 30 tables and I don't know in which of them is stored the usefull information.
I only checked if I could access and read one of them.
So these are the changes I did to the sample project:
CONSTANT CtMongo = "CtMongo" //not changed DatabaseName = "ace" //changed CollectionName = "day" //changed END // Connection to the database MongoDBConnect(CtMongo,"127.0.0.1",*,30000) //changed
STConsuReview is Structure //new elements Time is 8-byte int Type is string Tag is string Size is int Ttltime is DateTime Max is real Min is real Ave is real Last_val is real Last_val_time is real //old elements. not deleted to avoid compilation errors since some controls are using them. Mark is int // Mark given by the customer (out of 10) Recommend is boolean // Would you recommend the product ReviewDetails is string // Opinion details ProductName is string // Name of the product ProductMake is string // Brand of product Characteristics is associative array of strings // Object characteristics OpinionDate is DateTime // Date of review UserName is string // Name of the user who posted the review Price is numeric // Price of product END
PROCEDURE DisplayLastReviews() //LooperDeleteAll(LOOP_LastReviews) MongoDBInitBrowse("Search",CtMongo,DatabaseName+"."+CollectionName,"",10) stOpinion is STConsuReview WHILE MongoDBReadNext("Search",stOpinion) Trace(stOpinion.Type) Trace(stOpinion.Last_val) END
Regards,
José Antonio. |
| |
| |
| | | |
|
| | | | |
| | |
|