So I 'm working on a few projects that require data storage (basically, advanced config files t...

[G+_Ben Yanke]

So I'm working on a few projects that require data storage (basically,  advanced config files that are not really advanced enough to want a database). For the main one, I am creating a system to backup the database and filesystem associated with the websites I'm responsible for. This would run on my ubuntu server.

 

I was thinking of storing it in JSON (thanks to Fr. Robert Ballecer, SJ 's strong endorsement of it in past shows) because it appears to be by far the most flexible and robust way to store this, taking into account all the different options (ftp for some sites, sftp w/ pw for some, sftp with ppk auth for others),

 

Here is a link to the (sanitized) JSON I have so far: https://home.benyanke.com/temp-files/json/question/

 

Now, the important questions:

 

1) Is JSON a good way to store something like this?

 

2) Is it more secure to set the cred.json file permissions to 000 and run the backup script as root via sudo/root's croon, or set the permissions to 400 and not run the script elevated to root??

https://home.benyanke.com/temp-files/json/question

[G+_Ben Reese]

If you're using JSON, why not go with MongoDB? Mongo is a NoSQL DB that stores the data in JSON format.

 

Otherwise, I think JSON or XML are good options.

[G+_Ben Yanke]

Ben Reese Hmm! I'll check it out! Might be overkill for this, but I'll certainly check it out.

[G+_Ben Reese]

Ben Yanke if nothing else, it's fun to learn another DBMS.

[G+_Ben Yanke]

I'm learning mysql right now for a class, so I'll certainly Consider it!