Re: [sqlite] stored procedures implementation for SQLite

On Wednesday, January 26, 2011 5:38 PM, Chris Wolf wrote: > but if anyone is interested, I checked in my work on GitHub, including > pre-compiled > binaries for MacOS and Linux. > > http://chriswolf.heroku.com/articles/2011/01/26/adding-stored-procedures-to-sqlite/#extended > Yes, very

[sqlite] Multi-file Atomic Commit issue.

> > So really it is if there are transactions: The first transaction by SQLite > completes exactly as it said it would. Then the second transaction (the > "rm" command) deletes the ATTACHed database. > > If you want to interrupt a transaction, use the "kill -9" command on the > SQLite process at

Re: [sqlite] Multi-file Atomic Commit issue.

On Thu, Jan 27, 2011 at 10:22 AM, Dennis Suehr wrote: > > BEGIN TRANSACTION; > REPLACE INTO main.Table values (X,Y,Z); > REPLACE INTO attachedDbName.Table values (X,Y,Z); > COMMIT TRANSACTION; > > Using GDB, I put a breakpoint on the unixSync() function and then call my C >

[sqlite] Multi-file Atomic Commit issue.

Hello, I have been trying to verify SQLite's Multi-file Atomic commit functionality, but unfortunately have been unable to do so. My test scenario is as follows: SQLite 3.7.4 (amalgamation) built into a C library. Fedora 12. Two databases residing on an ext4 filesystem. One database attached to

Re: [sqlite] sqlite3 command line utility

From: BareFeetWare list@barefeetware.com Sent: Thu, January 27, 2011 8:50:15 AM > >INSERT INTO "Microscopes" VALUES(null, 'nSpec', 'default'); > >create temp table "Store" (MicroscopeID); > >insert into "Store" select last_insert_rowid(); > >INSERT INTO "Objectives"(ObjectiveID, MicroscopeID,

Re: [sqlite] sqlite3 command line utility

On 27/01/2011, at 3:30 AM, Jeff Archer wrote: > INSERT INTO [Microscopes] VALUES(@MicroscopeID, 'nSpec', 'default'); > > INSERT INTO [Objectives](ObjectiveID, MicroscopeID, TurretPos, Name, > Description, Magnification, NA, WD) VALUES( 1, @MicroscopeID, 0, '5X' , 'CFI > LU > Plan Fluor BD

Re: [sqlite] sqlite3 command line utility

Jeff Archer wrote: > Is it possible to use parameter binding from the sqlite3 command line utility? No. > In my code I have tried making 1 bind to @MicroscopeID and I have tried it > with > appending the digits 1 to 6 and making 6 calls to bind with same

Re: [sqlite] Multiple threads sharing one DB

On Wed, Jan 26, 2011 at 10:56 AM, Ian Hardingham wrote: > Hey guys. > > I am under the impression that there is no concurrent access to a single > SQLite DB. Ie if thread A is performing a query, and thread B trys to > query, it will block until thread A is finished, no

[sqlite] how to turn off autocommit in C interface?

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to create sqlite3_value structure to be used with sqlite3_bind_value()?

I am already doing the prepare_v2/reset/bind_int/step/finalize set. Before I do more intensive testing to confirm my earlier findings about not much time difference between using the separate statement compared with using exec, I want to confirm that it is true that I can't do bind_int on

[sqlite] sqlite3 command line utility

Is it possible to use parameter binding from the sqlite3 command line utility? I would like to make a small illustration of my problem but it only seems to have an issue with I am doing an insert and using a bound parameter for a column which is a foreign key. I have foreign key on by: PRAGMA

[sqlite] Multiple threads sharing one DB

Hey guys. I am under the impression that there is no concurrent access to a single SQLite DB. Ie if thread A is performing a query, and thread B trys to query, it will block until thread A is finished, no matter the query. 1. Is this correct? 2. Are there any fairly general workarounds of

Re: [sqlite] forcing flush of journal

Thats what I thought, thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users