Any programs for maintaining a large .json file?

[noisebomb44]

Does anyone know any program where you can automate a json text file, by automatically creating new entries using templates, so you don't have to type it all again every time you want to create annother entry and auto update the id of the new entry to match its position in the text document?

 

This should describe it well enough

[Samistine]

Have a template of copy-pastable strings. Look at AutoHotKey

[vorticalbox]

Just now, Samistine said:

Have a template of copy-pastable strings. Look at AutoHotKey

You could just make a function to take variables and add them to the end of a file, I don't know if on exists.

[noisebomb44]

9 minutes ago, Samistine said:

Have a template of copy-pastable strings. Look at AutoHotKey

Thats what i've done until now, but it gets pretty fiddely as the database begins to grow, with multiple layers and a lot of variables with no color coding, and combine that with how hard it is to find where there is a "," is missing and how hard it sometimes gets to spot where one entry ends and annother starts without things like comments or regions from c# it gradually becomes more of a nightmare to look through each time you add something

[noisebomb44]

8 minutes ago, vorticalbox said:

You could just make a function to take variables and add them to the end of a file, I don't know if on exists.

I guess it would work by using autohotkey like @Samistine mentioned, but i would like something with a UI for the reasons mentioned above

[vorticalbox]

11 minutes ago, noisebomb44 said:

I guess it would work by using autohotkey like @Samistine mentioned, but i would like something with a UI for the reasons mentioned above

I'm sure you could do this in java script with a web ui or c# for windows. I would give this a go for you but im super busy just now.

 

if you went the js route I would have the id as a global and then store your data in an array then at the end encode that into json.

 

You would also need to load the json and great the forms to edit them.

[mathijs727]

Just write a program that deserializes the json, appenda a new item to the lost and than serializes the list again.

Not the fastest solution but it should do the job if the jsn file doesnt get ridiculously big.

[vorticalbox]

9 minutes ago, mathijs727 said:

Just write a program that deserializes the json, appenda a new item to the lost and than serializes the list again.

Not the fastest solution but it should do the job if the jsn file doesnt get ridiculously big.

these sorts of files are never that fast as they have to be read line by line. Which does bring up the question is a big json file is best way to actually solve the problem?

[mathijs727]

28 minutes ago, vorticalbox said:

these sorts of files are never that fast as they have to be read line by line. Which does bring up the question is a big json file is best way to actually solve the problem?

You dont actually need to read line by line, there are work arounds.

Like storing the line index of the last item somewhere.

You could than use that to directly seek to the line and insert a (JSON) string.

 

This way is less robust and more work, but it is fast.

[noisebomb44]

After googleing some more, if found a few programs that does just what i want (without having to create my own)

 

(gets the job done, much more manageable than using a text editor)

http://jsoneditoronline.org/

 

(don't have time to test this one now, but looks maybe even better than the one above)

http://jsonmate.com/

 

(more professional, but not free)

https://www.liquid-technologies.com/json-schema-editor

 

EDIT:

I also found this, a plugin for notepad++ which seems really useful if you want to edit json files easily without having to download a new program or use your web browser, also you can just edit right off your file instead of having to copy-paste back and fourth

http://www.sunjw.us/jstoolnpp/

 

also:

http://scraping.pro/7-best-json-viewers/