Re: [sqlite] INTEGER PRIMARY and Triggers

2008-11-15 Thread Craig Smith

On Nov 16, 2008, at 2:14 AM, [EMAIL PROTECTED] wrote:

> Do you mind specifying what are the "odd things" that happen?
>
> I have used TRIGGERs on tables with INTEGER PRIMARY KEY and have had
> no odd things happen at all.

Right.  I should have put more details up originally.  Actually, the  
problems have all been related to the Objective-C / Cocoa interface  
that I have been working on.  It is a small project with a small  
database consisting of 4 tables, one of which is a startup table with  
two integers.  Those two integers correspond to primary keys of two  
other tables with the AUTOINCREMENT, precisely because I do not want  
recycling of id numbers.  Originally, I had written Obj-C code to  
update the startup table integers whenever an UPDATE or INSERT was  
performed on the two tables with the AUTOINCREMENT id numbers, then I  
thought it would be much more efficient to have the triggers do the  
job, and result in less code in the actual front end.

Well, all was working fine until I installed the triggers.  My Obj-C  
code did indeed update the startup table, and then correctly read  
those integers to present the proper data to the GUI.  After  
installing the triggers, and commenting out the relevant Obj-C code,  
it did not matter whether I did the INSERT or UPDATE via my GUI or via  
the command line; the startup table was consistently correct (i.e.,  
the triggers were working), but my Obj-C code kept returning the  
integer 2, even when the startup table contained a 17.  It was even  
more maddening when the same behavior was exhibited after dropping the  
triggers and un-commenting the Obj-C code.  I ended up having to erase  
the database file completely and write a new one to get everything to  
function correctly as the original had.

Yes, I am a beginner with both Obj-C and SQLite (6 months or so with  
both), so it is certainly possible that there is something involved  
with the timing of my commands within my Cocoa project that is doing  
this.  The weird thing is that even when I shut down the sample app  
(running inside of XCode), and then re-launched it to read the tables  
fresh on startup, I would still consistently get a 2, regardless of  
what integer was actually residing in the startup table.

In case you are wondering, I use 3 different Macs, depending on where  
I am during the month, and I want the startup table so that the  
database file can move from machine to machine, and my app will always  
have the same data and setup.  The file will eventually reside on a  
flash drive, although for development purposes, right now I am keeping  
it on my desktop(s).

Thank you again.

>

Craig Smith
[EMAIL PROTECTED]



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


Re: [sqlite] rowid for my first 2 rows is always the Same.

2008-11-15 Thread Igor Tandetnik
"LordEricO" <[EMAIL PROTECTED]> wrote
in message news:[EMAIL PROTECTED]
> For some reason, the rowid of the first the 2 rows in my table always
> matches.  Whether it's one and one, two and two, 20 and 20 etc...  No
> matter if I delete one of the rows.
> Do you know why that would be?

With all due respect, I find this hard to believe. As far as I can tell, 
this is a physical impossibility in SQLite's data structures.

Can you show a small sample that demonstrates the problem? How do you 
create the table, insert rows, and read them back in a way that suggests 
to you there are duplicate rowids?

Igor Tandetnik



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


Re: [sqlite] Sqlite3Explorer Sqlite Report Designer

2008-11-15 Thread Rajesh Nair
Hi Merv

Thanks for your sharing If you can share it through this dissussion 
forum then that will be counted as a great work from you. Because those who 
are using Sqlite with windows and visualstudio 6 will face the problem of 
reporting. They have to depend up on Crystall Reports or some other tools 
which will require ODBC/ ADO.

I have tested OOFile but was not worth enough. So please share what you have 
with all of us. I am tired of searching such a thing.

Rajesh Nair

- Original Message - 
From: "Merv" <[EMAIL PROTECTED]>
To: "General Discussion of SQLite Database" 
Sent: Saturday, November 15, 2008 9:03 PM
Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer


>I have a program for Windows that may help you. It is not open-source
> but it is free to use and distribute.
> It has a simple report function that I am willing to modify based on
> input from users.
> We can continue to communicate this way or you can contact me directly
> at the above address or call 705-646-1076.
> Have a super one!
> Merv
>
> Rajesh Nair wrote:
>> Thank You..
>>
>> Java report builders are available on sourceforge.net and i have gone
>> through it long before. What I am looking is the one which any one can 
>> use
>> with VisualStudio 6 or ealier products. It should be handy. Not a
>> complecated one. Simple like "just design and port the report file and 
>> then
>> just view and print". Do you have any link which could help all of us.
>>
>>
>>
>> - Original Message - 
>> From: "Timothy A. Sawyer" <[EMAIL PROTECTED]>
>> To: "General Discussion of SQLite Database" 
>> Sent: Saturday, November 15, 2008 10:24 AM
>> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
>>
>>
>>
>>> If you want something that is Windows based like you describe, why not 
>>> use
>>> Java to build a Swing GUI? Delphi and Pascal are a little antiquated so 
>>> if
>>> you need to revise you may have a problem finding a resource. Also
>>> consider the platform independence if that is a concern
>>> Timothy A. Sawyer, CISSP
>>> Managing Director
>>> MBD Solutions
>>> Phone: (603) 546-7132
>>> Web: http://www.mybowlingdiary.com
>>> Email: [EMAIL PROTECTED]
>>>
>>>
>>> -Original Message-
>>> From: "Rajesh Nair" <[EMAIL PROTECTED]>
>>>
>>> Date: Sat, 15 Nov 2008 09:23:46
>>> To: General Discussion of SQLite Database
>>> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
>>>
>>>
>>> Thanks
>>>
>>> So I can't use it... Ok ... But I got some source code of  FastReport (
>>> some
>>> ealier version ) from the internet and it is in Dephi/Pascal. I don't 
>>> know
>>> both of the tools. Can you use the same code to build a dll which can be
>>> used with other windows programing languages? ( So that no one can raise
>>> their finger aganist me or YOU ).
>>>
>>> I don't want a very efficient-high-end report designer like FastReport. 
>>> My
>>> clients require very simple reports, which does not contain much
>>> caculations
>>> etc If you can help me  please. It won't be just for me. Those who 
>>> are
>>> using SqLite with windows will be happy with a simple report deisgner 
>>> and
>>> viewer. Also my company is not willing to puchase any product for just
>>> reporting, since our programs are supplied freely along with some of our
>>> products. So an extra cost is not feasible.
>>>
>>> A SIMPLE DISIGNER/VIEWER FOR WINDOWS USERS
>>>
>>>
>>> - Original Message - 
>>> From: "Cariotoglou Mike" <[EMAIL PROTECTED]>
>>> To: "General Discussion of SQLite Database" 
>>> Sent: Friday, November 14, 2008 7:14 PM
>>> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
>>>
>>>
>>>
 I am the author of sqlite3Explorer. Sorry I did not answer you previous
 post, reason is I did not motice it... :(

 I don't think what you want is feasible. the reason is this: the Dll
 expects a "dataset" which sqlite3Explorer builds internally, and the
 report engine takes it from there (Design, run, export etc). the dll
 itself does not contain data retrieval code, and relies on the host for
 this.

 this is ok, but the catch is here: the dataset format that the dll
 understands is a proprietary format developed by and only used by the
 company I work for. the dll engine is one the prime design/execute
 engines for our commercial projects.
 thus I cannot open-source it. and, since the dataset format in question
 cannot be produced without having access  to the proprietary libraries
 we use here, what you want cannot be done.

 sorry...


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Rajesh Nair
> Sent: Friday, November 14, 2008 2:12 PM
> To: General Discussion of SQLite Database
> Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer
>
> Hi all
>

[sqlite] rowid for my first 2 rows is always the Same.

2008-11-15 Thread LordEricO

For some reason, the rowid of the first the 2 rows in my table always
matches.  Whether it's one and one, two and two, 20 and 20 etc...  No matter
if I delete one of the rows.
Do you know why that would be?

Eric
-- 
View this message in context: 
http://www.nabble.com/rowid-for-my-first-2-rows-is-always-the-Same.-tp20522218p20522218.html
Sent from the SQLite mailing list archive at Nabble.com.

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


Re: [sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

2008-11-15 Thread Jeff Godfrey
Brown, Daniel wrote:
> Good afternoon list,
>
> If I would like to use the TCL based tests on my version of SQLite on
> Windows XP what would be the recommend TCL distribution to use?  Would
> ActiveTCL (http://tinyurl.com/5wl6uv) be compatible with the SQLite TCL
> scripts on Windows XP?
>
> Cheers,
>
> Daniel Brown | Software Engineer 
> "The best laid schemes o' mice an' men, gang aft agley"
>   
That'd definitely be my recommendation.  I use ActiveTcl for all of my 
Tcl development, which happens to be Windows XP based and often 
incorporates SQLite.

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


[sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

2008-11-15 Thread Brown, Daniel
Good afternoon list,

If I would like to use the TCL based tests on my version of SQLite on
Windows XP what would be the recommend TCL distribution to use?  Would
ActiveTCL (http://tinyurl.com/5wl6uv) be compatible with the SQLite TCL
scripts on Windows XP?

Cheers,

Daniel Brown | Software Engineer 
"The best laid schemes o' mice an' men, gang aft agley"



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


[sqlite] TRIGGER to disallow updates on condition

2008-11-15 Thread P Kishor
I want to create a TRIGGER (or some kind of constraint) that would
croak when an update is attempted without a WHERE clause (to prevent
accidental updates of the entire table). If a conscious update of the
entire table is requested then one could just add a WHERE 0=0 kind of
a dummy clause, but if there is no WHERE clause, the UPDATE attempt
should just fail.

Any hints would be appreciated.

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


[sqlite] INTEGER PRIMARY KEY and triggers

2008-11-15 Thread Craig Smith
I am addicted to using INTEGER PRIMARY KEY AUTOINCREMENT as the id  
fields in my SQLite projects, yet I would like to try some triggers as  
well.  Of course, every time I add a trigger that accesses a table  
with  these types of id fields, all sorts of odd things happen.  I  
read in the documentation about simply using PRIMARY KEY instead of  
INTEGER PRIMARY KEY, but then I lose my AUTOINCREMENT ability.

Does anyone have a solution that both provides AUTOINCREMENT (or a  
reasonable facsimile) to a PRIMARY KEY field and allows the usage of  
triggers on those tables?

Thank you very much.

Craig Smith



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


Re: [sqlite] Sqlite3Explorer Sqlite Report Designer

2008-11-15 Thread Merv
I have a program for Windows that may help you. It is not open-source 
but it is free to use and distribute.
It has a simple report function that I am willing to modify based on 
input from users.
We can continue to communicate this way or you can contact me directly 
at the above address or call 705-646-1076.
Have a super one!
Merv

Rajesh Nair wrote:
> Thank You..
>
> Java report builders are available on sourceforge.net and i have gone 
> through it long before. What I am looking is the one which any one can use 
> with VisualStudio 6 or ealier products. It should be handy. Not a 
> complecated one. Simple like "just design and port the report file and then 
> just view and print". Do you have any link which could help all of us.
>
>
>
> - Original Message - 
> From: "Timothy A. Sawyer" <[EMAIL PROTECTED]>
> To: "General Discussion of SQLite Database" 
> Sent: Saturday, November 15, 2008 10:24 AM
> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
>
>
>   
>> If you want something that is Windows based like you describe, why not use 
>> Java to build a Swing GUI? Delphi and Pascal are a little antiquated so if 
>> you need to revise you may have a problem finding a resource. Also 
>> consider the platform independence if that is a concern
>> Timothy A. Sawyer, CISSP
>> Managing Director
>> MBD Solutions
>> Phone: (603) 546-7132
>> Web: http://www.mybowlingdiary.com
>> Email: [EMAIL PROTECTED]
>>
>>
>> -Original Message-
>> From: "Rajesh Nair" <[EMAIL PROTECTED]>
>>
>> Date: Sat, 15 Nov 2008 09:23:46
>> To: General Discussion of SQLite Database
>> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
>>
>>
>> Thanks
>>
>> So I can't use it... Ok ... But I got some source code of  FastReport ( 
>> some
>> ealier version ) from the internet and it is in Dephi/Pascal. I don't know
>> both of the tools. Can you use the same code to build a dll which can be
>> used with other windows programing languages? ( So that no one can raise
>> their finger aganist me or YOU ).
>>
>> I don't want a very efficient-high-end report designer like FastReport. My
>> clients require very simple reports, which does not contain much 
>> caculations
>> etc If you can help me  please. It won't be just for me. Those who are
>> using SqLite with windows will be happy with a simple report deisgner and
>> viewer. Also my company is not willing to puchase any product for just
>> reporting, since our programs are supplied freely along with some of our
>> products. So an extra cost is not feasible.
>>
>> A SIMPLE DISIGNER/VIEWER FOR WINDOWS USERS
>>
>>
>> - Original Message - 
>> From: "Cariotoglou Mike" <[EMAIL PROTECTED]>
>> To: "General Discussion of SQLite Database" 
>> Sent: Friday, November 14, 2008 7:14 PM
>> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
>>
>>
>> 
>>> I am the author of sqlite3Explorer. Sorry I did not answer you previous
>>> post, reason is I did not motice it... :(
>>>
>>> I don't think what you want is feasible. the reason is this: the Dll
>>> expects a "dataset" which sqlite3Explorer builds internally, and the
>>> report engine takes it from there (Design, run, export etc). the dll
>>> itself does not contain data retrieval code, and relies on the host for
>>> this.
>>>
>>> this is ok, but the catch is here: the dataset format that the dll
>>> understands is a proprietary format developed by and only used by the
>>> company I work for. the dll engine is one the prime design/execute
>>> engines for our commercial projects.
>>> thus I cannot open-source it. and, since the dataset format in question
>>> cannot be produced without having access  to the proprietary libraries
>>> we use here, what you want cannot be done.
>>>
>>> sorry...
>>>
>>>   
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Rajesh Nair
 Sent: Friday, November 14, 2008 2:12 PM
 To: General Discussion of SQLite Database
 Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer

 Hi all

 How can I use the mkFrxEngine.DLL supplied along with the
 Sqlite3Explorer.
 The dll is a report designer and viewer. Please help me to
 use that dll if any one knows. I asked the same before 10-14
 days ago, but didn't get any reply. If even the author of the
 same is reading this please help me. I want to use it as a
 report viewer for my sqlite3 database.


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

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

Re: [sqlite] bug? like-search with german umlaut is case-sensitive, should not be

2008-11-15 Thread Peter Jacobi
I'm aware that ICU is able to provide a very general solution, but I'm
wondering about two other options:

(1) Just as an OS abstraction layer is in place for I/O, wouldn't it
be possible to use an OS abstraction layer for L14N? So that for
example uppercasing is forwarded to LCMapString(LCMAP_UPPERCASE) on
Win32. That would bring the Sqlite behaviour in line with the handling
in the application program itself (provided that it uses OS APIs and
not ICU).

(2) I'm under the impression, that the problematic cases (german
sharp-s, turkic i) are few compared with all the cases where a simple
lookup would things make work. If I'm not mistaken, a lookup table of
2048 entries handling all 2 byte UTF-8 characters would already cover
all the joint character repertoire of all ISO-8859-*  (and their MSFT
counterparts). Thai (in ISO 8859-11) is using three byte UTF-8 but
doesn't have upper/lower case.

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


[sqlite] How to remove SQLite profiling

2008-11-15 Thread Alexey Pechnikov
Hello!

Start console SQLite

$ sqlite3
SQLite version 3.6.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .q
profiling:/usr/src/sqlite3:Cannot create directory
profiling:/usr/src/sqlite3/sqlite-3.6.3/.libs/sqlite3.gcda:Skip

What is strings
profiling:/usr/src/sqlite3:Cannot create directory
profiling:/usr/src/sqlite3/sqlite-3.6.3/.libs/sqlite3.gcda:Skip

and how can I remove it?

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


Re: [sqlite] Sqlite3Explorer Sqlite Report Designer

2008-11-15 Thread Rajesh Nair
Thank You..

Java report builders are available on sourceforge.net and i have gone 
through it long before. What I am looking is the one which any one can use 
with VisualStudio 6 or ealier products. It should be handy. Not a 
complecated one. Simple like "just design and port the report file and then 
just view and print". Do you have any link which could help all of us.



- Original Message - 
From: "Timothy A. Sawyer" <[EMAIL PROTECTED]>
To: "General Discussion of SQLite Database" 
Sent: Saturday, November 15, 2008 10:24 AM
Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer


> If you want something that is Windows based like you describe, why not use 
> Java to build a Swing GUI? Delphi and Pascal are a little antiquated so if 
> you need to revise you may have a problem finding a resource. Also 
> consider the platform independence if that is a concern
> Timothy A. Sawyer, CISSP
> Managing Director
> MBD Solutions
> Phone: (603) 546-7132
> Web: http://www.mybowlingdiary.com
> Email: [EMAIL PROTECTED]
>
>
> -Original Message-
> From: "Rajesh Nair" <[EMAIL PROTECTED]>
>
> Date: Sat, 15 Nov 2008 09:23:46
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
>
>
> Thanks
>
> So I can't use it... Ok ... But I got some source code of  FastReport ( 
> some
> ealier version ) from the internet and it is in Dephi/Pascal. I don't know
> both of the tools. Can you use the same code to build a dll which can be
> used with other windows programing languages? ( So that no one can raise
> their finger aganist me or YOU ).
>
> I don't want a very efficient-high-end report designer like FastReport. My
> clients require very simple reports, which does not contain much 
> caculations
> etc If you can help me  please. It won't be just for me. Those who are
> using SqLite with windows will be happy with a simple report deisgner and
> viewer. Also my company is not willing to puchase any product for just
> reporting, since our programs are supplied freely along with some of our
> products. So an extra cost is not feasible.
>
> A SIMPLE DISIGNER/VIEWER FOR WINDOWS USERS
>
>
> - Original Message - 
> From: "Cariotoglou Mike" <[EMAIL PROTECTED]>
> To: "General Discussion of SQLite Database" 
> Sent: Friday, November 14, 2008 7:14 PM
> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
>
>
>>I am the author of sqlite3Explorer. Sorry I did not answer you previous
>> post, reason is I did not motice it... :(
>>
>> I don't think what you want is feasible. the reason is this: the Dll
>> expects a "dataset" which sqlite3Explorer builds internally, and the
>> report engine takes it from there (Design, run, export etc). the dll
>> itself does not contain data retrieval code, and relies on the host for
>> this.
>>
>> this is ok, but the catch is here: the dataset format that the dll
>> understands is a proprietary format developed by and only used by the
>> company I work for. the dll engine is one the prime design/execute
>> engines for our commercial projects.
>> thus I cannot open-source it. and, since the dataset format in question
>> cannot be produced without having access  to the proprietary libraries
>> we use here, what you want cannot be done.
>>
>> sorry...
>>
>>> -Original Message-
>>> From: [EMAIL PROTECTED]
>>> [mailto:[EMAIL PROTECTED] On Behalf Of Rajesh Nair
>>> Sent: Friday, November 14, 2008 2:12 PM
>>> To: General Discussion of SQLite Database
>>> Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer
>>>
>>> Hi all
>>>
>>> How can I use the mkFrxEngine.DLL supplied along with the
>>> Sqlite3Explorer.
>>> The dll is a report designer and viewer. Please help me to
>>> use that dll if any one knows. I asked the same before 10-14
>>> days ago, but didn't get any reply. If even the author of the
>>> same is reading this please help me. I want to use it as a
>>> report viewer for my sqlite3 database.
>>>
>>>
>>> --
>>> Regards
>>> Rajesh Nair
>>> ___
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 

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


Re: [sqlite] Non-exclusive reserved lock?

2008-11-15 Thread Kees Nuyt
On Sat, 15 Nov 2008 02:32:21 -0800, Roger Binns
<[EMAIL PROTECTED]> wrote in General Discussion of
SQLite Database :

>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Kees Nuyt wrote:
>> I assume the OP wants to collect updates from more than one
>> webpage into one logical transaction, where every webpage
>> contains another part of the data to be changed. In that
>> case a memory database wouldn't work because it would
>> disappear between page requests.
>
> More accurately the memory database has the same
> lifetime of the database connection in that process,
> and depending on how PHP is hosted there could be
> multiple different processes involved in requests, and
> processes could exit after processing a number of
> requests.  (It is important to clarify that SQLite
> doesn't spuriously disappear in memory databases :-)

Very true. To clarify some more: In general a database
connection (and thus an SQLite memory database) is lost as
soon as PHP has processed the request and sent a response
page.

>> That would work. I would use the main database all the way
>> though,
>
> The OP is trying to prematurely optimize access away from 
> a potentially busy/locked main database :-)

I secretly hope a complicated design pattern scared him away
from doing that ;)

>> One common design pattern
>
>It may be worth starting a section of the wiki with
>various design patterns for common tasks.

Yes, but I don't think the SQLite wiki is the appropriate
place, as this is a generic session and transaction
management (OLTP) issue, which has more to do with
application frameworks than with a specific database engine.

The SQLite wiki could contain links to relevant fora, but I
wouldn't know one from the top of my head.

Searching newsgroup comp.lang.php would be a good start.

>Roger
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users