AVFP REST Service JSONDB to save and retrieve json data

Topics: Developer Forum
Coordinator
Jun 22, 2014 at 5:20 AM
I just finished the first version of an AVFP REST service called JsonDB. This REST service allows to easily save and retrieve JSON data on a ActiveVFP server.

Please check the test program here:
http://cl.ly/461g0H2h2t04

This REST service needs a customized version of AVFP I am working on since last year. I hope the next release of AVFP will include this customizations. You can check what is new on this customized version of AVFP here: http://victorespina.com.ve/avfpsb/


Victor Espina
Coordinator
Jun 22, 2014 at 1:10 PM
Thank you, Victor. I will be evaluating this soon.
Coordinator
Jun 24, 2014 at 1:28 AM
I just finished a js client library for jsondb and uploaded a demo page to test it. This demo page (built on activeVFP using the new layouts plugin), shows how to use jsondb REST service to retrieve data from the server in JSON format very easily. Check it out here:

http://victorespina.com.ve/avfpsb/jsondbtest.avfp


For this test, I reconfigured the jsondb REST service to read a different data folder, so please download this modified version of the vfp jsondb test program because the original one won't work as it is:

http://cl.ly/220F2Y2O0c2e


Next step will be a more complete demo page, with all CRUD operations, as well as the version 2.0 or jsondb REST service with MySQL and SQL Server support.


Victor Espina