SID-01838: using database plugin to do updates/deletes to the database

Status:	Answered	TWiki version:		Perl version:	perl-5.18.1
Category:	DatabasePlugin	Server OS:	Centos 6.4	Last update:	10 years ago

All,

I'd like to have a simple module which allowed for two way communication with the twiki - something like DatabasePlugin presenting a table as a wiki page - except:

• the table that is presented is editable,
• and can in effect be used to do both updates and deletes on the database that it references as well as presenting the row.

IMO, This would be an very quick-and-easy way to make twiki an application engine, and for simple sqls I think it would be straightforward to implement (more complicated sqls admittedly may pose a challenge, but even there, with row_ids it may be doable)

Anyways, if there is anything out there please let me know - if nothing like this exists, I may end up implementing something like this if it was simple enough and I had pointers to do it...

Thanks much,

Ed

-- Ed Peschko - 2013-12-06

Discussion and Answer

Do you envision to store the data in an external SQL database or internally in TWiki?

If internally, TWiki has two approaches:

1. Use TWikiForms with FormattedSearch - how-to blog at BlogEntry201009x1

2. Use EditTablePlugin to edit a table and SpreadSheetPlugin to add spreadsheet calculations.

For the second option I envision a combined solution that has the ease of use of Google docs spreadsheet.

-- Peter Thoeny - 2013-12-07

Closing this question after more than 30 days of inactivity. Feel free to reopen if needed. Consider engaging one of the TWiki consultants if you need timely help. We invite you to get involved with the community, it is more likely you get community support if you support the open source project!

-- Peter Thoeny - 2015-12-03

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.