tcl-sqlite3

[Ryan Schmidt]

On Aug 25, 2018, at 11:18, Joshua Root wrote:

> On 2018-8-26 01:22 , joerg van den hoff wrote:
> 
>> On 25.08.18 06:21, Joshua Root wrote:
>>>> currently, this port is at version
>>>> 
>>>>     tcl-sqlite3 @3.6.22_3
>>>> 
>>>> sqlite3, however, is already at 3.24. there have been relevant changes
>>>> to sqlite between versions 22 and 24, so I now see "malformed schema"
>>>> errors with the tcl package for databases generated with current sqlite3
>>>> (identical to those I see with the sqlite3 at 3.22 port).
>>>> 
>>>> question: any chance to see an update of the tcl-sqlite3 package soon?
>>> 
>>> The tcl-sqlite3 port could probably be updated if a ticket is filed. I
>> I could do that, of course, if required.
>> 
>>> think it may have languished in part because there was a question of how
>>> useful it is now that Tcl 8.6 has sqlite3 built in.
>> has it? I am not aware of this: there is no command `sqlite3' available
>> in my tclsh 8.6.8 (the one provided by macports) before I do `package
>> require sqlite3' (which loads the separately installed sqlite3 package,
>> e.g. the ports-provided one). of course, if you issue "sqlite3" at the
>> tlcsh prompt, you usually fire up the standalone `sqlite3' comand line
>> utility and get it's prompt. but that is of course not the same thing...
>> 
>> so if I have missed something: could you please elaborate a bit on this?
> 
> If you uninstall the tcl-sqlite3 port, you should find that 'package
> require sqlite3' loads a newer version of the package.
> 
> % port contents tcl | grep sqlite
>  /opt/local/lib/sqlite3.21.0/libsqlite3.21.0.dylib
>  /opt/local/lib/sqlite3.21.0/pkgIndex.tcl
>  /opt/local/lib/tcl8/8.6/tdbc/sqlite3-1.0.6.tm
>  /opt/local/share/man/mann/sqlite3.n.gz
>  /opt/local/share/man/mann/tdbc_sqlite3.n.gz

Soo... that loads the sqlite 3.21.0 version of the extension, which as you say is bundled with Tcl.

It seems like it would be better if we updated the tcl-sqlite3 port to match the version in the sqlite3 port, which is 3.24.0, and remove these parts from the tcl port.

We could make updates to tcl-sqlite3 automatic by making it a subport of the sqlite3 port.