Forum OpenACS Development: TDBC drivers?

Collapse
1: TDBC drivers?
Posted by Antonio Pisano on 12/14/15 12:50 PM
Hello there,

Tcl 8.6 introduced SQL integration. What do you think about adding other possible db platforms to OpenACS by exploiting this new API? What is the quality of native tcl connectivity compared to naviserver integrated one?

Something one could achieve, for instance is SQLite support, or maybe even MS SQL Server, through odbc. Technical argumentations aside, this would be very neat.

http://www.tcl.tk/man/tcl8.6/TdbcCmd/contents.htm

Collapse
2: Re: TDBC drivers? (response to 1)
Posted by Gustaf Neumann on 12/15/15 08:26 AM
If it is the intention to use TDBC, then it should be possible to use it out-of-the box (for e.g. accessing a few tables, needed for certain applications).

If it is the intention to use the core data model of OpenACS in other than the supported databases, the major hurdles are probably stored procedures/functions, handling of tree queries (e.g. recursive queries), the supported SQL functions, datatypes, ....

Collapse
3: Re: TDBC drivers? (response to 2)
Posted by Antonio Pisano on 12/15/15 09:21 AM
A lot of work indeed... It came from a request for feasibility I received. Too much to be expected at the moment (probably any moment), but I was curious to understand what was possible now.