Re: [sqlite] Error: Can't find package sqlite

Cena, Resty wrote: Hi, I'm trying to use TclSqlite, but when I try to load sqlite with the command: % package require sqlite I get the following error: can't find package sqlite Try load path/tclsqlite3.dll sqlite3 rather than the package require, where "path" is the proper path to the

[sqlite] Error: Can't find package sqlite

Hi, I'm trying to use TclSqlite, but when I try to load sqlite with the command: % package require sqlite I get the following error: can't find package sqlite Is this the way to load the package into Tcl? I'm using ActiveState Tcl 8.4.6, Sqlite 3.0.4 on Windows NT 4.0 with SP 6. I have

Re: [sqlite] SQLite on 64-bit unix

Do the rumors apply to 64-bit Linux or do they apply elsewhere? I can give you access to either my 64-bit Fedora Core 2 desktop (self-built) or Fedora Core 2 laptop (eMachines M6805) and I have access to an Apple G5 (unfortunately I can't give you access to it). I remember trying to compile

RE: [sqlite] SQLite on 64-bit unix

You can try HP TestDrive (www.testdrive.compaq.com) or the sourceforge.net compile farm. >>-Original Message- >>From: D. Richard Hipp [mailto:[EMAIL PROTECTED] >>Sent: Tuesday, September 07, 2004 1:01 PM >>To: [EMAIL PROTECTED] >>Subject: [sqlite] SQLite on 64-bit unix >> >> >>I keep

[sqlite] Is PRAGMA SYNCHRONOUS= inherited by ATTACHed databases?

Using version 2.8.15, I'm doing the equivalent (via the API) of this: sqlite /tmp/db1 PRAGMA SYNCHRONOUS=OFF; ATTACH '/tmp/db2' AS db2; db2 has previously had the command "PRAGMA default_synchronous=FULL" applied to it. Will the writes to db2 be synchronous or not? If db2 does

Re: [sqlite] 3 tables in relation, really slow ...

Have you tried to change the order of the conditions in the WHERE clause? I don't know the internal working of SQLite so they might actualy give worst results. You can try something like that: SELECT date_ext.mydate as MyDate, city_ext.city as MyCity, number_ext.mynum as MyNumber FROM city_ext,

Re: [sqlite] Risks involved with using synchronous=OFF (was 'Single INSERT is very slow')

Tue, Sep 07, 2004 at 12:59:37PM +0100: Christian Smith wrote: > On Tue, 7 Sep 2004, Guillaume Fougnies wrote: > > >Mon, Sep 06, 2004 at 11:56:21PM -0700: Darren Duncan wrote: > >> > >> What you probably saw with the 3ms is the time between when you > >> issued the insert command and when control

[sqlite] Re: hello... little short SQLite Question

Thomas Buerdel wrote: Does SQLite Support Carriage-Returns in select-Statements?? I try to made this a little dynamic with a select from the Sqlite-Data-Dictionary... sounds like: .output test.sql SELECT '.output \backup_path\'|| name || '.sql .dump ' || name FROM sqlite_master WHERE

Re: [sqlite] Risks involved with using synchronous=OFF (was 'Single INSERT is very slow')

George Ionescu wrote: > > If the database becomes corrupted after a power failure while inserting > records, is there any way of repairing the database? > No. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] Risks involved with using synchronous=OFF (was 'Single INSERT is very slow')

Mon, Sep 06, 2004 at 11:56:21PM -0700: Darren Duncan wrote: > At 9:20 AM +0300 9/7/04, George Ionescu wrote: > >as Nuno Lucas suggested, I've tried inserting one record using > >synchronous = OFF. That makes a *huge* difference: 150 ms > >(synchronous=FULL) vs. 3 ms (synchronous=OFF) !! So I'm

Re: [sqlite] Open Command broken under OSX

Hi Jeff, I think you forgot to put the "/' in front of the path name. I just compiled the command line tool version of sqlite3 using XCode. This is version 3.0.6. I then ran the following line: ./sqlite3 /Users/roblaveaux/Documents/robbie.db And the file was created at the right directory. So

Re: [sqlite] Re: Cursor naming conflict

Jeff, There are several solutions to this naming conflict: 1. Don't use the Carbon headers as your prefix file. Name conflict solved. Instead you can create your own prefix file and include only the headers/symbols you need. 2. Build a static library of sqlite and link to that. This is the way

RE: [sqlite] How to get the list of rows that were changed during the last UPDATE SQL-command

> From: CARIOTOGLOU MIKE > Subject: RE: [sqlite] How to get the list of rows that were changed during the last UPDATE SQL-command > Date: Mon, 06 Sep 2004 03:22:45 -0700 > IMHO, you should not do this at the SQL level, but at the OO level. > your "clients" should not change rows, but objects,

Re: [sqlite] Risks involved with using synchronous=OFF (was 'Single INSERT is very slow')

At 9:20 AM +0300 9/7/04, George Ionescu wrote: as Nuno Lucas suggested, I've tried inserting one record using synchronous = OFF. That makes a *huge* difference: 150 ms (synchronous=FULL) vs. 3 ms (synchronous=OFF) !! So I'm asking this: anyone has had any real-word experience with multi-user

[sqlite] Risks involved with using synchronous=OFF (was 'Single INSERT is very slow')

Hello sqlite users, Hello dr. Hipp, as Nuno Lucas suggested, I've tried inserting one record using synchronous = OFF. That makes a *huge* difference: 150 ms (synchronous=FULL) vs. 3 ms (synchronous=OFF) !! So I'm asking this: anyone has had any real-word experience with multi-user access and

[sqlite] PRAGMA default_synchronous not working?

Hello sqlite users, Hello dr. Hipp, using v3.0.6, I've discovered that PRAGMA default_synchronous directive is not working. Will this be implemented in the next version? Regards, George Ionescu