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

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

https://sites.google.com/view/metricrat-ai2/guides/tinywebdb-encrypted-on-a-spreadsheet

3 Likes

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

I had to look it up :wink:

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();
2 Likes