[sqlite] "select disctict" calles tcl functions twice?

Hi All, In my example code here the function "fun" is called twice for each row. The first set of calls is made in the initial evaluation of the sql statement, then "fun" is called again as the tcl body is evaluated for each row. I wasn't expecting this. Thanks, John

Re: [sqlite] COUNT() extremely slow first time!

On Sun, Feb 27, 2011 at 3:11 PM, Max Vlasov wrote: > Hmm, yesterday something struck me I can do similar tests on an Asus T91MT > having SSD as the storage. I got similar timings to Greg's. So it seems like > page size is a very sensitive parameter for solid state drives.

Re: [sqlite] COUNT() extremely slow first time!

On Sat, Feb 26, 2011 at 1:03 AM, Greg Barker wrote: > harddrive. Can you confirm this? > > > Giving this, if the fastest is 3.6 seconds, you have a very fast > I can confirm this, my tests were run on a machine that uses a solid state > drive. > > Hmm, yesterday something

Re: [sqlite] Best practices fo web interface

As example, you can build JSON services and use a lot of javascript widgets. I use tclsqlite on my servers and jQuery on clients (desktop brawsers, Google Android applications). Small example: http://mobigroup.ru/service/jsontest/ 2011/2/27 Matt Young : > I am a regular

Re: [sqlite] Best practices fo web interface

On 27 Feb 2011, at 5:51pm, Matt Young wrote: > I am a regular user of sqite at the office, but I want to progress to sqlite > web access via the web. Who has the best widgets for that? Web space not a > problem. Widgets that work in blogger pages would be nice, but I can start > fresh also.

[sqlite] Best practices fo web interface

I am a regular user of sqite at the office, but I want to progress to sqlite web access via the web. Who has the best widgets for that? Web space not a problem. Widgets that work in blogger pages would be nice, but I can start fresh also. ___