I was hoping someone might be able to explain how I could bypass having a MySQL (or other type of database) with JQGrid and just directly read/write to a JSON file that lives on the server.
You can just save the JSON data in the file. Depend on the jQuery version and from the settings on your web server it can be important which file extenstion you choose for the file having JSON data. Try to use .json file extension. See the demo which use the JSON file as an example.
OlegK, Thanks for the response but it made me think of a couple of questions I had.
=> If you allow the cells to be editable in the grid, with this also change the JSON file on the server when the changes were saved?
=> What would happen if another user edited the grid while I was viewing it, would the changes immediately be shown on my view?
=> (Similar) If the server modified the JSON file (I have bash scripts that occasionally change my JSON files) would the user see the changes right away.
I recommend you to use file instead of the database only in case of grid which has no editing features.
If you do want use JSON-file for editing the server code have to lock the file during the file modification. The exact implementation are depend on the language which you use.
The implementation of concurency is not exist per default if you use and database. Look at here to understand which things should be done to implement optimistic concurrency.
.
