Databases On Wikidot (old)
Helmut_pdorf 06 Jan 2009 15:57
I created a little database on our Community site relating to the "showcase" database.
I used the
- help:autonumbering-of-pages feature for unique "primary keys per row's of the 2 categories ("db1country:", "db1town:"),
- include:db1country for record insertion with "short source code in table "db1country"
- include:db1town for record insertion ijn the 2 table db2town
- db1country:_template for showing and creating records over prepared newpage modules
- db1town:_template for showing and creating records in the town table
- for Links "between the 2 tables" I used the
- "interwiki" technic ( [/page-name showname] in the variables of the "includes" -
- this prevents us of the "breaking" pipe in the link and the "breaking" 3 brackets..
I am awaiting your Comments!
regards
Helmut
Please give any suggestion on can any external database be used within wikidot site?
Yes, Zoho Creator is a web-based database which can be embedded in your wiki page. It one of the range of Zoho products which you can embed. I have done snippets on Zoho Show which is a powerpoint-like presentation application, and Zoho Sheet which is a spreadsheet. There are other applications as well and Zoho Creator is the database application.
Once you have created your application in Zoho Creator you embed in your wiki page in an iframe with the following syntax:
What is good is that once you have set up the database you can add, edit and delete the data from within the wiki without having to go back to the zoho site.
Here is a quick and basic database of Scottish town populations that I have done and it uses the iframe code above. You should be able to change the data (please do, nothing depends on it). During the weekend I will add a snippet giving step by step instructions.
Rob
Rob Elliott - Strathpeffer, Scotland - Wikidot first line support & community admin team.
Looking forward to where this is headed in the future
~ Leiger - Wikidot Community Admin - Volunteer
Wikidot: Official Documentation | Wikidot Discord server | NEW: Wikiroo, backup tool (in development)
So am I Shane. It could be that in future the work on forms will be sufficiently developed to become similar to a lite CMS which would open up some possibilities.
Rob
Rob Elliott - Strathpeffer, Scotland - Wikidot first line support & community admin team.
I like the idea!!!