[sqlite] tclsqlite3 db function exports not visible on other connections. Why not?

2017-03-19 Thread petern
Taking DRH's remarks about learning tclsqlite for the efficient coding to heart, I discovered a big problem. Here is the simplest example from the docs and DRH presentation: TCLSH % db function myhex {format 0x%X}; % db eval {select myhex(10);} x {parray x}; x(*) = myhex(10) x(myhex(10))

Re: [sqlite] tclsqlite3 db function exports not visible on other connections. Why not?

2017-03-19 Thread R Smith
On 2017/03/19 11:05 AM, petern wrote: Taking DRH's remarks about learning tclsqlite for the efficient coding to heart, I discovered a big problem. Here is the simplest example from the docs and DRH presentation: TCLSH % db function myhex {format 0x%X}; % db eval {select myhex(10);} x {parray

Re: [sqlite] tclsqlite3 db function exports not visible on other connections. Why not?

2017-03-19 Thread Daniel Kamil Kozar
You can use sqlite3_auto_extension for this. On 19 March 2017 at 11:35, R Smith wrote: > > On 2017/03/19 11:05 AM, petern wrote: >> >> Taking DRH's remarks about learning tclsqlite for the efficient coding to >> heart, I discovered a big problem. >> >> Here is the simplest

Re: [sqlite] Yet Another Why Doesn't Sqlite Use My Index question ...

2017-03-19 Thread Paul Sanderson
What is the average size of the text in the direction field? and what page size have you set for the database? If the size of a record is such that only a small handful fit into a page, or worse each record overflows (and your select includes the direction field) then this could impact

[sqlite] Subject: Re: sqlite with Java

2017-03-19 Thread dmp
> From: Sylvain Pointeau > > Why don't you provide an up-to-date version? this lib seems dead when we > look at the website, also why don't you put the sources on git it would be > easier to contribute or raise a bug if any... > > -- I first supported SQLite in my

Re: [sqlite] sqlite with Java

2017-03-19 Thread Sylvain Pointeau
On Sun, Mar 19, 2017 at 4:57 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > Why don't you provide an up-to-date version? this lib seems dead when we >> look at the website, also why don't you put the sources on git it would be >> easier to contribute or raise a bug if any... >> > > I

Re: [sqlite] sqlite with Java

2017-03-19 Thread Christian Werner
On 03/19/2017 05:38 PM, Sylvain Pointeau wrote: On Sun, Mar 19, 2017 at 4:57 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: Why don't you provide an up-to-date version? this lib seems dead when we look at the website, also why don't you put the sources on git it would be easier to

Re: [sqlite] sqlite with Java

2017-03-19 Thread Sylvain Pointeau
> > Why don't you provide an up-to-date version? this lib seems dead when we > look at the website, also why don't you put the sources on git it would be > easier to contribute or raise a bug if any... > I tried to compile the latest version of sqlite 3.17 with the latest sources of sqlitejava

Re: [sqlite] sqlite with Java

2017-03-19 Thread Sylvain Pointeau
On Sun, Mar 19, 2017 at 5:38 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > On Sun, Mar 19, 2017 at 4:57 PM, Sylvain Pointeau < > sylvain.point...@gmail.com> wrote: > >> Why don't you provide an up-to-date version? this lib seems dead when we >>> look at the website, also why don't

Re: [sqlite] sqlite with Java

2017-03-19 Thread Christian Werner
On 03/19/2017 06:38 PM, Sylvain Pointeau wrote: IMO it is no good idea to discuss specific issues of an only indirectly SQLite related library on this mailing list OK yes I agree, where can we discuss about it? C'mon, you apparently obtained the source code of this dead project, didn't

Re: [sqlite] Yet Another Why Doesn't Sqlite Use My Index question ...

2017-03-19 Thread Paul Sanderson
Oops - somehow misread the last message - 54 seconds down from 32 minutes - that's a result! Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite

Re: [sqlite] sqlite with Java

2017-03-19 Thread Sylvain Pointeau
> > > IMO it is no good idea to discuss specific issues of an only indirectly > SQLite related > library on this mailing list OK yes I agree, where can we discuss about it? > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] tclsqlite3 db function exports not visible on other connections. Why not?

2017-03-19 Thread Richard Hipp
On 3/19/17, petern wrote: > > In fact, according to the title of that presentation, SQLite is the most > popular TCL extension in the world! > > Furthermore, if the TCL byte code engine is already linked to the SQLite > binary, one would think user defined TCL byte

Re: [sqlite] sqlite with Java

2017-03-19 Thread Sylvain Pointeau
> OK yes I agree, where can we discuss about it? > > For information, we continued this discussion privately. I succeed to build this library and I will use it in my project. Additionally I would be glad contribute if Christian needs my help. Furthermore, I will assess my need to have SSE, and if

Re: [sqlite] tclsqlite3 db function exports not visible on other connections. Why not?

2017-03-19 Thread petern
Yes. I am aware of https://www.sqlite.org/loadext.html And that's a good point. However, one might be under the impression that SQLite is a TCL extension from DRH's presentation here:

Re: [sqlite] tclsqlite3 db function exports not visible on other connections. Why not?

2017-03-19 Thread petern
You wouldn't happen to have a TCL script you can share which approximates the SQLite interactive shell multiline input and .exit command to return to tclsh? Dot exit would be the only mandatory dot command needed. On Sun, Mar 19, 2017 at 12:28 PM, Richard Hipp wrote: > On