Skip to main content
O
osgood_
Legend
July 3, 2018
Answered

json - file management

  • July 3, 2018
  • 1 reply
  • 1941 views

Is there some kind of app software to manage json files like phpMyAdmin manages mysql data?

I mean how do you arrive at a finished formatted json file without doing it manually........surely there must be some user friendly app UI which inserts, updates and deletes info from a json file or exports as a json file right?

Cheers

Os

    This topic has been closed for replies.
    Correct answer BenPleysier

    Ok l think its becoming a bit clearer now.......surprisingly there are no real tuts out there that address such issues. Plently which cover dealing with data in an already defined json file but they never exactly say how the information was formated like that in the first instance because yes you are correct....manually defining info in a json file, even small amounts, is a PITA and mistakes are easily made, so thats why l was wondering how larger json files were created and managed because they seem highly unmanagable unless the process is somehow automated


    This may help Create dynamic JSON file in PHP Mysql - YouTube

    1 reply

    pziecina
    pziecina
    Legend
    July 3, 2018

    You can use c# and mssql to autogenerate a json file, (including overwriting an old json file so the file name remains the same) on-request, hourly, daily, weekly, etc, to use in html pages, (does not have to use server side code).

    I don't know for certain, but php/mysql probably has a similar feature.

    O
    osgood_Author
    Legend
    July 3, 2018

    I dont know any c# or mssql.......so there's no simple user interface off the shelf app to create and manage json file data?

    How is an API json file created and managed, 100s of entries. If a bit of information is outdated or needs to be updated youre not expected to open the json file and find the entry and delete it or update it so in what form does the original information exist and as for php/mysql why would you even need a json file you would surely use php/mysql if it was available in that format, right?

    pziecina
    pziecina
    Legend
    July 3, 2018

    The info for inclusion is taken from the database.

    The main reason for using json, (for me) was when i did not want a page to include server side code, (better security). Entering/updating/deleting the info into the database was done via a cms, with a flag to indicate json and an expire date being set in the cms system, so the server would know when to include and when to archive.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices