[TW5]Using Google spreadsheets like free hosting for Tiddlywiki Shop. Demo.

[Siniy-Kit]

Hi! I found an interesting idea to use Google spreadsheets like data base. I create empty TW5 Shop on my site and write little script. This script read id parameter from URL and get all data from my spreadsheets if they are public and shared.

It mean, that everybody can open my spreadsheet, make copy of it to their google drive, modify and "render" it by new id on my site. So we have something like free an very simple hosting for everybody on one static page :)

Current demos

http://novye-podarki.ru/frame.html?id=1GzZFzmgF-vBrRYOyz5VqjJC8QAQcOHnFBa1PEW9NhcU

on start loads data from

      https://docs.google.com/spreadsheets/d/1GzZFzmgF-vBrRYOyz5VqjJC8QAQcOHnFBa1PEW9NhcU/

and the same page, but different id

http://novye-podarki.ru/frame.html?id=1Oaeue_pQWn01EY5f2ghiTgkLsq5Rm7xbFr89_R801JQ

data from

       https://docs.google.com/spreadsheets/d/1Oaeue_pQWn01EY5f2ghiTgkLsq5Rm7xbFr89_R801JQ/ 

and other  variant first spreadsheet on different templates

http://novye-podarki.ru/black.html?id=1GzZFzmgF-vBrRYOyz5VqjJC8QAQcOHnFBa1PEW9NhcU

http://novye-podarki.ru/grey.html?id=1GzZFzmgF-vBrRYOyz5VqjJC8QAQcOHnFBa1PEW9NhcU

without id you will see empty TW5 Shop

this "hosting" has ban system. It checks g-mail of spreadsheet, and not render it, if it is in ban list.

in spreadsheet you can add your own colons and sheets, all of them will be read and converted to tiddlers with fields.

But I rename some fields names in tables

id=title

name=caption

_canonical_uri=url

the names of other fields will be same as the colons headers. All tiddlers from "images" sheet  will have type="image/jpeg"

All changes in spreadsheet are show on site immediately after page refresh F5

So you can make your own spreadsheet and test it on my site. External images we can share from google photos.

[Mat]

Thanks for sharing Siniy-Kit!

Is it possible to somehow make that script into a TW plugin? 

And, if "yes", then would it also work in single-file TW?

Is this a solution for multi-user TW!!!???

<:-)

[Siniy-Kit]

I don't know how to make plugin of it. Script is on javascript http://novye-podarki.ru/frame.html#%24%3A%2Fboot%2Fbootprefix1.js 

And I take it from lesson about JSONP  so you can save my demo (it is single file TW) from V menu and it will load data local too.

We can use it as multi-user, because I can give editing permission for any google user and, as far as I know,  google spreadsheets support multi-user editing .

воскресенье, 7 января 2018 г., 21:16:54 UTC+3 пользователь Mat написал: