Like a tinywebdb, but encrypted, and on a spreadsheet!

TIMAI2 · January 8, 2020, 12:02pm

Having created a php server tinywebdb, I was tempted to try it out with google apps script and store the data on a spreadsheet!

ABG · January 8, 2020, 4:02pm

I like the documentation and the atomicity improvement.
Thanks for the post!

TIMAI2 · January 8, 2020, 4:16pm

I had to look it up

It is easy to lock the data just put the following at the beginning and end of the main function (this for google apps script):

//lock sheet to prevent concurrent changes
var lock = LockService..GetPublicLock();
lock.waitLock(5000);

<...script code here....>

//release spreadsheet for editing
lock.releaseLock();