DB front end in Foswiki

I consider building simple 'front end' for CRUD operations by means of Foswiki extensions.

Is it a good idea or maybe I should use different tool? Is there anyone who tries to accomplish that? What was the result? Is there any connection/configuration issues?

-- RomanAndrzej - 26 Jun 2014

Has been done a couple of times on intranets using SqlPlugin.

-- MichaelDaum - 26 Jun 2014

Could you tell me SqlPlugin will be able to connect to MS SQL Server database? Unfortunately I need to use it.

-- RomanAndrzej - 23 Sep 2014

There is no direct requirement to use a specific database server in SqlPlugin. Try the DBD::Sybase driver installed on your Foswiki server.

-- MichaelDaum - 24 Sep 2014

Alternatively you could use the DBD::ODBC driver. We have that is use in production connecting to an MS SQL database.

-- JulianLevens - 25 Sep 2014

Thank you for answer. Unfortunately, my biggest issue is that I wish to query MS SQL Database which is on different server. Moreover, this server is on our internal corporate network and Wiki on Amazon. I think that it might be very tricky to configure or even impossible.

-- RomanAndrzej - 06 Dec 2014