Concept question of Best Practice... JSON display in a jQuery Grid.



  • What development environment do you feel is BEST to create a process of displaying data.

    With so many development options - should one begin with Eclipse and develop Java Spring apps, or?

    I am seeking a solid approach to take csv data and display it in a jQuery grid, such as ParamQuery.

    Any suggestions greatly appreciated.


  • administrators

    @Tahor-Sui-Juris I think that your requirement is to display data from your database in a website using ParamQuery Jquery plugin and also save the data back to the database if changes are made in the ParamQuery grid.

    You can create a simple API like this - https://jsonplaceholder.typicode.com/ in any language. Let's say you build an API called myawesomeapi.com. You can create 2 API endpoints, one endpoint to fetch data - myawesomeapi.com/get and one to save data myawesomeapi.com/save

    So everytime when someone loads your website, you make an ajax call to myawesomeapi.com/get which will respond with JSON data, use it and initialize paramQuery. When user makes changes to data and clicks save data then make a call to save endpoint which saves the data. This is how It's done in most of the apps.

    Because You don't have experience building APIs, I would suggest you to get started using myjson.com

    myjson.com is a simple json storage service which supports storing and updating json data. But all the data is public (Use it only for testing). You can use this with some fake data to store some json, pull it on your website, display the data in paramquery and also update data using a PUT request. Check the documentation here - http://myjson.com/api

    Once you understand how stuff works then you can build your own API in any language. Try Node.js for you first API

    Hope that helps!



  • Excellent! Yes it helps.

    Thank you, you are the BEST!



  • @ranjithkumar10

    Ranjith, your Forum is great for me. I appreciate knowledgeable persons of whom are kind to instruct and share.

    I am hoping you can be my JSON person of whom, I can become an expert in all aspects of JSON.

    I am pursuing Certifications from W3 to begin, and expand from there with other earned credentials.

    Below is my curriculum:

    https://youtu.be/2mDhbMvtTk0
    coding KARMA - at least I am doing something about it!

    Lynda.com
    Udemy.com

    1. HTML5

    2. CSS

    3. JavaScript Essential Training - Joe Marini

    4. Mobile Web Fundamentals - Joe Marini

    5. jQuery Essential Training - Joe Marini
      5a. jQuery Code School http://try.jquery.com

    6. jQuery Mobile Essential Training - Joe Marini

    7. JSON - Ranjith Kumar - https://forum.codingislove.com/

    8. paramQuery PRO -- ? instructor / courses to be found

    9. XHR - XMLHttp Request -- ? instructor / courses to be found

    10. API - David Berlind - https://www.programmableweb.com

    11. Node.js / React / - Mike Dalisay - https://www.codeofaninja.com/

    Today, my focus is to complete the project you assisted me, regarding the second XHR with the jsession cookie.

    "That website is using JsessionId for security. I don't know what's their expiry period. If it is forever then this will work - https://bin.codingislove.com/ejacugimix.vbs

    If sessionId expires in a day or after few hours then you have to make one request for accepting the terms which sends jsessionId in cookie. Then you have to parse it using http.getAllResponseheaders() method and use it in further POST requests as mentioned.

    Am reviewing these instructions to resolve the jsessionid cookie.

    Any supportive links for instruction in this, greatly appreciated.

    Thank you.


Log in to reply
 

Looks like your connection to Codingislove Forum was lost, please wait while we try to reconnect.