Re: [sqlite] trigger on update bug in 3.6.20?

On Tue, Nov 24, 2009 at 12:28 PM, Pavel Ivanov wrote: > > I am not what you mean by Oracle's Before triggers have different > concept? > > care to explain? > > Sure. When Oracle calls your before update trigger it provides you old > values of the row and storage for new

Re: [sqlite] multiple threads with shared cache mode

On 24 Nov 2009, at 9:17pm, Pavel Ivanov wrote: > Indeed, it's weird. And I've just realized that if we have two > simultaneous write transactions they both have to write their own > journal whenever they wish to write something to disk. SQLite database > cannot have two different journal files,

Re: [sqlite] multiple threads with shared cache mode

--- On Tue, 11/24/09, Nicolas Rivera wrote: > From: Nicolas Rivera > Subject: [sqlite] multiple threads with shared cache mode > To: sqlite-users@sqlite.org > Date: Tuesday, November 24, 2009, 12:22 PM > Hi, > > It is my understanding, per >

Re: [sqlite] multiple threads with shared cache mode

Indeed, it's weird. And I've just realized that if we have two simultaneous write transactions they both have to write their own journal whenever they wish to write something to disk. SQLite database cannot have two different journal files, so it should serialize transactions whenever they want to

Re: [sqlite] multiple threads with shared cache mode

>No, it's one write transaction per table. Wierd, according to the doc : "At most one connection to a single shared cache may open a write transaction at any one time. This may co-exist with any number of read transactions" -- View this message in context:

Re: [sqlite] trigger on update bug in 3.6.20?

> I am not what you mean by Oracle's Before triggers have different concept? > care to explain? Sure. When Oracle calls your before update trigger it provides you old values of the row and storage for new values of the row. You can change whatever you like in this storage and be sure that it will

[sqlite] Recursive TRIGGERs: depth-first or width-first

This new implementation of recursive TRIGGERs. Is it depth-first or width-first ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] trigger on update bug in 3.6.20?

On Tue, Nov 24, 2009 at 11:25 AM, Pavel Ivanov wrote: > > yes it is risky, in general. but in this specific case, I expect no > > problems. > > just as a reference, this works just fine on mysql and oracle.. > > and used to work quite well until sqlite 3.6.16. > > I don't

Re: [sqlite] Corrupted SQLITE database recovery

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Griggs, Donald wrote: > You may want to try >.dump mytable1 >.dump mytable2 >etc > On individual tables to see if some are salvageable. That is what the underlying dump code does anyway. > For failing tables, if you *can* read a certain

Re: [sqlite] trigger on update bug in 3.6.20?

On Tue, Nov 24, 2009 at 11:49 AM, D. Richard Hipp wrote: > > On Nov 24, 2009, at 1:15 PM, Vasu Nori wrote: > > > wondering if this is a known issue in 3.6.20. > > http://www.sqlite.org/lang_createtrigger.html#undef_before > > "If a BEFORE UPDATE or BEFORE DELETE trigger modifies

Re: [sqlite] trigger on update bug in 3.6.20?

On Nov 24, 2009, at 1:15 PM, Vasu Nori wrote: > wondering if this is a known issue in 3.6.20. http://www.sqlite.org/lang_createtrigger.html#undef_before "If a BEFORE UPDATE or BEFORE DELETE trigger modifies or deletes a row that was to have been updated or deleted, then the result of the

Re: [sqlite] trigger on update bug in 3.6.20?

On Tue, Nov 24, 2009 at 10:25 AM, Pavel Ivanov wrote: > > create table t1(_id integer primary key, v integer, d integer); > > CREATE TRIGGER t1_trig BEFORE UPDATE ON t1 > > BEGIN > >update t1 SET v=OLD.v+1 WHERE NEW._id=OLD._id AND NEW.d!= OLD.d; > > END; > > I guess

Re: [sqlite] Is it possible for SQLite to notify anapplicationconnected to it of database changes?

On 24 Nov 2009, at 6:17pm, Erin Drummond wrote: >> What, precisely, do you poll ? > A few mutually exclusive tables in the database to check for changes. Depending on what you care about, you might find it easier to check PRAGMA count_changes either instead of what you currently poll, or as

Re: [sqlite] trigger on update bug in 3.6.20?

Vasu Nori wrote: > wondering if this is a known issue in 3.6.20. > > create table t1(_id integer primary key, v integer, d integer); > CREATE TRIGGER t1_trig BEFORE UPDATE ON t1 > BEGIN >update t1 SET v=OLD.v+1 WHERE NEW._id=OLD._id AND NEW.d!= OLD.d; > END; Realize that

Re: [sqlite] trigger on update bug in 3.6.20?

> create table t1(_id integer primary key, v integer, d integer); > CREATE TRIGGER t1_trig BEFORE UPDATE ON t1 > BEGIN >update t1 SET v=OLD.v+1 WHERE NEW._id=OLD._id AND NEW.d!= OLD.d; > END; I guess your trigger does something different from what you wanted to do: it changes value of v in

[sqlite] multiple threads with shared cache mode

Hi, It is my understanding, per http://www.hwaci.com/sw/sqlite/sharedcache.html section 2.1, that only one write transaction may exist while in shared cache mode. Is that correct? If so, then I am trying to figure out what is the advantage of having table level locks in shared cache mode.

Re: [sqlite] Is it possible for SQLite to notify anapplicationconnected to it of database changes?

> if your application is the one making changes, can't it just notify itself at > the same time? Actually, come to think of it, it probably could. *facepalms self*. The application is going to expose a web interface which the user interacts with (this is how the database gets changed in the first

[sqlite] trigger on update bug in 3.6.20?

wondering if this is a known issue in 3.6.20. create table t1(_id integer primary key, v integer, d integer); CREATE TRIGGER t1_trig BEFORE UPDATE ON t1 BEGIN update t1 SET v=OLD.v+1 WHERE NEW._id=OLD._id AND NEW.d!= OLD.d; END; insert into t1 values(1, 1,0); update t1 set d= 2 where

Re: [sqlite] behavior of "collate" on views changed from 3.6.2 to 3.6.16 and beyond - intentional?

On Nov 24, 2009, at 12:26 PM, Vasu Nori wrote: > this bug doesn't appear in 3.6.20. > I didn't find a specific bug fix that actually addressed this bug > between > 3.6.16 and 3.6.20. > must be a side-effect fix from some other fix.. anyone knows HOW it > got > fixed in the code?

Re: [sqlite] behavior of "collate" on views changed from 3.6.2 to 3.6.16 and beyond - intentional?

On Nov 25, 2009, at 12:26 AM, Vasu Nori wrote: > this bug doesn't appear in 3.6.20. > I didn't find a specific bug fix that actually addressed this bug > between > 3.6.16 and 3.6.20. > must be a side-effect fix from some other fix.. anyone knows HOW it > got > fixed in the code? would be

Re: [sqlite] behavior of "collate" on views changed from 3.6.2 to 3.6.16 and beyond - intentional?

this bug doesn't appear in 3.6.20. I didn't find a specific bug fix that actually addressed this bug between 3.6.16 and 3.6.20. must be a side-effect fix from some other fix.. anyone knows HOW it got fixed in the code? would be good to know. On Wed, Nov 18, 2009 at 10:31 PM, Vasu Nori

[sqlite] AUTO: Bret Patterson/Austin/IBM is out of the office (returning 11/30/2009)

I am out of the office until 11/30/2009. I'm out of the office but checking email once or twice a day and will respond to any high importance issues as quickly as possible. Note: This is an automated response to your message "sqlite-users Digest, Vol 23, Issue 24" sent on 11/24/09 5:00:01.

Re: [sqlite] ATTACH & Shared cache

> So if I want to perform a query with the connection with the 2 db attached > does the query will search data to the shared cache to have the fresh data ? Yes, this 3rd connection will use the same cache as 1st connection for db1 data and the same cache as 2nd connection for db2 data. Pavel On

Re: [sqlite] ATTACH & Shared cache

In fact I want to work on 2 different database. 1 connection (cx1) with the db1 for write operations (shared cache enabled, read uncommited) 1 connection (cx2) with the db2 for write operations (shared cache enabled, read uncommited) And another connection (or cx1) with both db1 and db2

Re: [sqlite] ATTACH & Shared cache

What difference does it make for you? What do you call "shared cache" here? Two different files cannot share cache anyway because they're different files with different pages. Or do you call caches shared if they can use the same memory? Then cache in SQLite is always shared. Or do you ask whether

Re: [sqlite] Corrupted SQLITE database recovery

Regarding: I have a small corrupted sqlite 3 database. ... Are there any tools for a more detailed analisys? I'm not aware of any, Marko. You may want to try .dump mytable1 .dump mytable2 etc On individual tables to see if some are salvageable. For failing tables, if you *can* read a

Re: [sqlite] Sqlite Java blob

What is failing at line: [DB.prepareStatement() 686] Connection.prepareStatement("INSERT INTO delay_forms (...) VALUES (...)"); OR ps.executeUpdate() Your code (between ) seem fine. Ulric -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] another Feature Request: char from codepoint? (with some additional thoughts on the demerits of Unicode intelligence in the database)

Not that you haven't had the debate before, but I hope this discussion of my enhancement request for a raw flip() or reverse() function helps to highlight some basic issues relating to Unicode in the database; I don't mean to be beating any dead horses. Roger Binns wrote: My point was that

[sqlite] ATTACH & Shared cache

Hi, With shared cache enabled, if we want to attach a database to the current connection does sqlite create a new shared cache for the new attached database or does it share the same shared cache ? Thanks -- View this message in context:

Re: [sqlite] Data converting

Jean-Denis Muys wrote: > On 11/24/09 14:08 , "Igor Tandetnik" wrote: > >> Renato Oliveira wrote: >>> Hello, I'm new to SQLite, and need a query to convert a number of int format >>> to format date and date format to format int. >>> In PostGres the query is as follows: >>>

Re: [sqlite] Data converting

On 11/24/09 14:08 , "Igor Tandetnik" wrote: > Renato Oliveira wrote: >> Hello, I'm new to SQLite, and need a query to convert a number of int format >> to format date and date format to format int. >> In PostGres the query is as follows: >> >> SELECT 14652:: bit (16))>>

[sqlite] How to deal with non 'normilize-able' tables

(Sorry to target this at sqlite users, as this is a general db problem, but if anyone could point me in the right direction...) I have a database that is well structured, but various clients have different information they need which means some info won't fit into a standard table. For example,

Re: [sqlite] Data converting

Renato Oliveira wrote: > Hello, I'm new to SQLite, and need a query to convert a number of int format > to format date and date format to format int. > In PostGres the query is as follows: > > SELECT 14652:: bit (16))>> 9): int + 1980) | | '-' | | > ((14652:: bit (16) & B'0000

Re: [sqlite] Is it possible for SQLite to notify an application connected to it of database changes?

On 24 Nov 2009, at 4:12am, Erin Drummond wrote: > Currently it finds changes by constantly polling the database What, precisely, do you poll ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Corrupted SQLITE database recovery

I have a small corrupted sqlite 3 database. sqlite> pragma integrity_check; SQL error: database disk image is malformed sqlite> .dump BEGIN TRANSACTION; COMMIT; sqlite> Is there any change of some data recovery? If i take a look with a hex viewer i can still see the CREATE TABLE declarations.

Re: [sqlite] Is it possible for SQLite to notify anapplicationconnected to it of database changes?

Erin Drummond wrote: > @Igor: I think you misunderstood. I only have one connection to the > database (provided by the JDBC driver). I only care about and use that > one connection (no other applications access the database). I was > wondering if database trigger could be used to notify the

Re: [sqlite] Data converting

You should read http://www.sqlite.org/datatype3.html , may help you. On Tue, Nov 24, 2009 at 10:48, Virgilio Fornazin wrote: > SQL does not have a specific datetime field type and also does not store it > in binary format. > You should perform the data type

Re: [sqlite] Data converting

SQL does not have a specific datetime field type and also does not store it in binary format. You should perform the data type conversions by yourself. On Tue, Nov 24, 2009 at 09:50, Renato Oliveira wrote: > Hello, I'm new to SQLite, and need a query to convert a number

[sqlite] Data converting

Hello, I'm new to SQLite, and need a query to convert a number of int format to format date and date format to format int. In PostGres the query is as follows: SELECT 14652:: bit (16))>> 9): int + 1980) | | '-' | | ((14652:: bit (16) & B'0000 ')>> 5):: int | |' - '| | (14652::

Re: [sqlite] temp directory?

The nice thing is, that i have this variable and it output my temp path, but my hoster doesn't has this. Only "open_basedir" has the option for the "temp directory". But i don't know, if this would work. At least i didn't know if my code with the pragma's work. Because i cannot see it or is there

Re: [sqlite] temp directory?

I am unsure of the syntax, as I don't use the sqlite API directly. I would say that seems correct as long as "'.$_SERVER['TMP'].'" resolves to a directory in which the user under which the application is running, has read and write access. Artur Reilin wrote: > >> You can try setting a temp