[sqlite] More important details on synchronous PRAGMA - suggested changes

Hello sqlite users, Hello dr. Hipp, I've read the info you've provided. Thanks. 1. For Windows systems: in the CreateFileA call to open an sqlite database (os_win.c), could the file flag FILE_FLAG_WRITE_THROUGH also be specified? This flag is quite important and is also used by SQL Server when o

Re: [sqlite] SQLite on 64-bit unix

On my 64 bit Linux system (Opteron, Gentoo 2004.1 amd_64), the v3.0.6 code builds fine but seg faults during 'make test' in one of the blob tests. Today I built the code with debugging enabled and used gdb to get a traceback. It failed at line 411 of src/util.c, in a strlen() call. 407 nByt

Re: [sqlite] Open Command broken under OSX

Hi Rob, What about an absolute path name as opposed to a relative path name? This is the test i showed in the terminal example. This is where it breaks. A point you may understand better is that in our plugin we used the PA_StructPath to return a path to the 4D database structure, so that th

[sqlite] Locking in 3.0.6

I'm having difficulty understanding the locking regime in SQLite 3. I open the same database with 2 processes (sqlite3.exe for instance). In process 1 I begin a transaction and insert a row. In process 2 I also begin a transaction and insert a row - this fails on the insert with an expected "data

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 .d

[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 creat

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 2.8/3

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 hear

[sqlite] SQLite on 64-bit unix

I keep hearing rumors that SQLite is not working right on 64-bit unix. But lacking access to any 64-bit hardware, there isn't much I can do about it. Does anybody out there have a 64-bit unix box that they can give me ssh access to so that I can test and debug SQLite? Access can be intermittant (

[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 i

RE: [sqlite] One more question on the C API performance - Solved!

> -Original Message- > From: Griggs, Donald [mailto:[EMAIL PROTECTED] > Sent: Friday, September 03, 2004 3:56 PM > To: [EMAIL PROTECTED] > Subject: RE: [sqlite] One more question on the C API performance > > > Regarding: "... why the complex query takes x milliseconds > to execute fro

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, nu

[sqlite] 3.0.6, sqlite3_step.

Reading the API documentation is not an easy way to switch from v2 to v3... Changelog is better in fact: The sqlite3_step() interface returns SQLITE_BUSY if it is unable to commit a change because of a lock. Now i get the v3 full speed with a tiny call to my busy callback in threaded environment.

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 w

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

Thomas Buerdel wrote: Hello? thanks that i wnow bu i need in the SQL-Ouptut a new line (Carriage Return) between "\backup_path\artist.sql" and ".dump artist". SELECT '.output \backup_path\' || name || '.sql .dump' || name FROM sqlite_master WHERE type='table'; -- D. Richard Hipp -- [EMAIL PR

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

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 was returned to your app, >> but the new record was simply in RAM and not o

[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 type='table

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] PRAGMA default_synchronous not working?

George Ionescu wrote: > 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? > PRAGMA synchronous still works. But we made a deliberate decision to remove PRAGMA default_synch

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 as

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 for

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 I

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, and