Igor Tandetnik wrote:
> "Ulrich Schöbel"
> <u...@bmu.office-on-the.net> wrote in
> message news:4997ddb2.9070...@bmu.office-on-the.net
>> I have a very simple table 'friends' with only one column
>> 'link':
>>
>> create table friends (link text);
&
John Machin wrote:
> On 15/02/2009 8:17 PM, Ulrich Schöbel wrote:
>> Hi all,
>>
>> I'm stuck with my problem. Hopefully someone here can help.
>>
>> I have a very simple table 'friends' with only one column
>> 'link':
>>
>> create table friends (l
Hi all,
I'm stuck with my problem. Hopefully someone here can help.
I have a very simple table 'friends' with only one column
'link':
create table friends (link text);
Lets assume there are 2 rows, 'abc' and 'def'.
Then there is a Tcl variable x containing a string. If $x
starts with either
Hi Yves, hi Filip,
thanks a lot for your help. You solved my problem
and I learned something new.
Kind regards
Ulrich
Am Wednesday 11 July 2007 20:00 schrieb [EMAIL PROTECTED]:
> Ulrich Schöbel a écrit :
> > As this list has excellent SQL wizards, I hope someone can help
> > me
It's the other way round: Your database is 3.x, your SQLite library
used by PHP is 2.8.14. Upgrade your PHP.
Ulrich
On Thursday 10 May 2007 14:46, Brandon Eley wrote:
> Thank you for this information. How would I access the 2.8.x database
> from within PHP? is it even possible?
>
> The database
Hi Pavan,
try
http://reddog.s35.xrea.com/wiki/TkSQLite.html
It's excellent.
Ulrich
On Thursday 26 April 2007 10:26, Pavan wrote:
> Hi Ralf,
>
> Thanks for the link. My OS is Linux. Is there something available on
> these lines for linux ?
>
> Best Regards,
> Pavan.
>
> On 4/26/07, Ralf
On Sunday 22 April 2007 18:01, Joe Wilson wrote:
> > I've used SQLite-3.3.4 for quite a while, mostly the Tcl binding.
> > A few days ago I installed 3.3.15 and the Tcl binding worked fine.
> > Tonight I downloaded 3.3.16 and compiled it without any errors
> > or warnings and then installed it.
On Saturday 21 April 2007 17:52, [EMAIL PROTECTED] wrote:
> Ulrich =?iso-8859-1?q?Sch=F6bel?= <[EMAIL PROTECTED]> wrote:
> > On Saturday 21 April 2007 15:40, Joe Wilson wrote:
> > > Apply this patch to fix this problem.
> >
> > Thanks for the patch, but there is still something wrong in the
> >
On Saturday 21 April 2007 15:40, Joe Wilson wrote:
> > I've used SQLite-3.3.4 for quite a while, mostly the Tcl binding.
> > A few days ago I installed 3.3.15 and the Tcl binding worked fine.
> > Tonight I downloaded 3.3.16 and compiled it without any errors
> > or warnings and then installed it.
Hi all,
I've used SQLite-3.3.4 for quite a while, mostly the Tcl binding.
A few days ago I installed 3.3.15 and the Tcl binding worked fine.
Tonight I downloaded 3.3.16 and compiled it without any errors
or warnings and then installed it. When I tried to execute sqlite3
the following error
I suspect that --with-PDO-sqlite is a default and you have to define
> --without-PDO-sqlite to defeat it.
>
> My dim memory suggests that I used grep to ferret out the sqlite options
> rather than the --help.
>
> The utf8 is to do with the character set. Others here are better
> equipp
Thanks, John, this is much better, although still not what I want.
It now has (mysteriously) a sqlite version of 3.3.3. No idea where
this is originated, maybe part of the bundle.
I compiled sqlite-3.3.13, it's running fine, the lib is in /usr/local/lib,
the headers are in /usr/local/include,
8.x.
> To use 3 or greater, you must use the PDO object to connect. Also make
> sure that you extension is enabled for pdo_sqlite.
>
> -Original Message-
> From: Ulrich Schöbel [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 05, 2007 1:40 PM
> To: sqlite-users@sqlite.org
Hi all,
my apologies if this is the wrong list to ask:
I'm trying to get php5 with sqlite3.3.13 running, but I'm completely stuck.
Whatever I tell configure, it always configures the bundled 2.8.x sqlite.
Is there anybody in the know?
Thanks
Ulrich
SQLite includes a Tcl API. Tcl does all these conversions with ease.
See the encoding convertto/convertfrom commands and fconfigure.
On Tuesday 05 December 2006 20:42, Nicolas Williams wrote:
> On Tue, Dec 05, 2006 at 06:53:28PM +0100, Marten Feldtmann wrote:
> > Perhaps it would be nice to
On Wednesday 23 August 2006 21:45, John Salerno wrote:
> Hi everyone. Can someone tell me the proper syntax for running a sql
> script when starting up sqlite from the command line interface?
>
> Thanks,
> John
>
> ---
>-- To
On Wednesday 16 August 2006 12:55, Christian Nassau wrote:
> Ulrich Schöbel wrote:
> > I thought about that, but I didn't want to include
> > the selects into the locked phase, keeping lock
> > times as short as possible. Shouldn't it work
> > correctly with a deferred
On Wednesday 16 August 2006 12:16, [EMAIL PROTECTED] wrote:
> "Christian Nassau" <[EMAIL PROTECTED]> wrote:
> > I would guess that your requests acquire (shared) read locks when the
> > transaction starts and then fail/deadlock when they try to upgrade this
> > to a write lock in your
Hi all,
I'm using sqlite3 inside a Tcl module (mod_websh) of
apache. Everything works fine, except when it comes
to concurrent write accesses.
There's a small transaction where I update two rows.
When I stress the web server it generates a
"database locked" error. I invoke a "db timeout 2000"
Hi Richard,
I'm no windows expert, but why don't you use something like
the tcl stubs mechanism? Build a static sqlite_stubs.a library
and link all loadable dynamic libs against it.
Kind regards
Ulrich
On Wednesday 07 June 2006 16:30, [EMAIL PROTECTED] wrote:
> I'm trying to add the ability
How about asking a new subscriber to copy some magic number
from the body to the subject of his reply? AFAIK autoresponders
can't do that.
Kind regards
Ulrich
On Wednesday 31 May 2006 17:17, Clark Christensen wrote:
> > And yet somehow, the spammer still managed to get signed up
> > using a
Hi David,
if you're looking for a truly portable tool, you should consider
Tcl/Tk. SQLite has a builtin interface to Tcl, Starkits are portable
between many OSes without any code change and the tktable widget
ot tablelist should be what you are looking for to present your data.
Visit
Hi Danilo,
take a look at
http://aspn.activestate.com/ASPN/docs/ActiveTcl/tcl/TclCmd/re_syntax.htm
Kind regards
Ulrich
On Friday 17 March 2006 10:13, Danilo wrote:
> Hi to All ,
> I'm looking for further information about REGEXP
> (http://www.sqlite.org/lang_expr.html).
> Someone knows how to
Hi David,
I don't know wether it's faster, but try
select a,b,c from d where c in (select c from d except select c from e)
Maybe you're lucky and it's faster.
Kind regards
Ulrich
On Wednesday 15 March 2006 22:44, CARTER-HITCHIN, David, FM wrote:
> Hi Brett,
>
> Many thanks for replying.
Hi John,
there isn't really much to remove, but nevertheless I
followed your advice and replaced the sqlite select
by a small standard tcl procedure. Maybe that set me
on the right track.
There were also some exceptionally high execution
times in between, but not in every test run and not
always
On Wednesday 22 February 2006 15:59, Adrian Ho wrote:
> > Do you come to similar results?
>
> Nope, mine were a lot more consistent (Centrino 1.6GHz laptop, 512MB RAM):
>
> t(1)=254 microseconds per iteration
> t(5)=186.6 microseconds per iteration
> t(10)=156.1 microseconds per iteration
>
Hi Richard,
thanks for trying to reproduce my 'problem'.
I'm using Linux 2.6.12 (Ubuntu Breezy Badger, a debian distro),
Tcl/Tk 8.4.12, sqlite 3.3.4, all pretty recent versions.
I made the same tests today with the same results.
Nevertheless, sqlite is by far faster than mySQL, so I'm going
to
Hi all,
out of curiosity I made the same timing tests as described
in my posting 'Strange execution times' with mySQL.
There's no reason to whine about the 300 microseconds
at 100 selects. MySQL, connected by mysqltcl to Tcl, delivers
after about 26305 microseconds, decreasing for 1
runs to
tions, the time calculation is less accurate), but mmm... maybe it
> could explain part of the phenomena?
>
> Ran
>
> On 2/22/06, Ulrich Schöbel <[EMAIL PROTECTED]> wrote:
> > Hi Adrian,
> >
> > I tried your script and got, after a slight modification, quite
> &g
Hi Adrian,
I tried your script and got, after a slight modification, quite
consistent results. When I tried it as is, I got slightly varying
time results with a peak in the 50 to 100 region. Then I
commented out all lines concerning the deletion, creation
and filling to get the pure retrieval
Hi Nathaniel,
even if it is not absolutely accurate, a factor of about 5
is beyond accuracy tolerances.
Kind regards
Ulrich
On Wednesday 22 February 2006 01:38, Nathaniel Smith wrote:
> On Wed, Feb 22, 2006 at 01:13:19AM +0200, Ulrich Schöbel wrote:
> > I tried the 10 reps expecting
Hi Thomas,
no, I can't reproduce it in C. The problem is not worth the effort,
I can live with these timings, it's just strange.
I don't think it's an interface problem. I'm using Tcl, more or less
the 'natural' language for sqlite. Tcl doesn't have a garbage
collection.
The strangest thing is,
Hi all,
I just made my first steps into sqlite (3.3.4).
I created a small table, filled it with two rows of data
and timed a select. Those were the results:
% time {db eval {select * from cust_persons where first_name='Ulrich'}} 1000
75.498 microseconds per iteration
% time {db eval {select *
33 matches
Mail list logo
