b.bum wrote:
Is there a way to do a 'begin transaction' directly at the RESERVED
locking level?
I've been thinking about adding a PRAGMA that would cause this
behavior. Another option is added a keyword to the end of BEGIN,
for example "BEGIN EXCLUSIVE" or something like that.
--
D. Richard Hipp
Dennis,
Thank you for the thoughtful reply. My position is that, anywhere type
information is available or can otherwise be determined by the engine it
should be provided. Views that are direct SELECT statements certainly
fall into this category. Derived results should be too. Think of MS
A
I would suggest a dummy update or insert just after the BEGIN
TRANSACTION that does not do anything meaningful, just creates the
RESERVED lock.
On Sat, 2004-09-25 at 00:30, b.bum wrote:
> Is there a way to do a 'begin transaction' directly at the RESERVED
> locking level?
>
> A typical usage pat
Is there a way to do a 'begin transaction' directly at the RESERVED
locking level?
A typical usage pattern-- correct me if there is a better way-- is to:
- start a transaction (NO LOCK TAKEN)
- do a series of selects to gather or verify state (SHARED)
- do a series of inserts/updates (with inter
I noticed that sqlite uses || as a string concatenation operator, but I
am curious if they also support the concat(arg1,arg2...argn) function as
well, and if so, since what version? I couldn't find anything related
to this documented, but after doing some tests it seems as though the
concat functi
>-Original Message-
>From: Mauricio Piacentini [mailto:[EMAIL PROTECTED]
>Sent: Friday, September 24, 2004 1:42 PM
>To: [EMAIL PROTECTED]
>Subject: Re: [sqlite] Lock files
>
>
>Fred Williams wrote:
>> I picked SQLite for its minuscule (by today's standards) footprint,
>> simplicity, a
>-Original Message-
>From: b.bum [mailto:[EMAIL PROTECTED]
>Sent: Friday, September 24, 2004 1:34 PM
>To: [EMAIL PROTECTED]
>Subject: Re: [sqlite] Lock files
>
>
>On Sep 24, 2004, at 11:16 AM, Fred Williams wrote:
>> I picked SQLite for its minuscule (by today's standards) footprint,
Fred Williams wrote:
I picked SQLite for its minuscule (by today's standards) footprint,
simplicity, and ease of deployment.
Why do I get the feeling I've bought into a product like any model in the
American car market. With each passing interation the vehicle gets bigger,
fatter, and less efficie
On Sep 24, 2004, at 11:16 AM, Fred Williams wrote:
I picked SQLite for its minuscule (by today's standards) footprint,
simplicity, and ease of deployment.
Why do I get the feeling I've bought into a product like any model in
the
American car market. With each passing interation the vehicle gets
I picked SQLite for its minuscule (by today's standards) footprint,
simplicity, and ease of deployment.
Why do I get the feeling I've bought into a product like any model in the
American car market. With each passing interation the vehicle gets bigger,
fatter, and less efficient. This continues
On Fri, 24 Sep 2004, Eddy Macnaghten wrote:
An attraction of SQLite is that it is all client based - making almost
practically zero cost administration. Although this is not an issue on
implementations that have an IT department, it makes a BIG difference in
supporting the penny-ally implementatio
Is this correct behavior for natural join?
I have 2 tables:
CREATE TABLE table_1 (rowid integer primary key, name string, join_code
string)
CREATE TABLE table_2 (rowid integer primary key, join_code string, type
string)
insert the following values:
insert into table_1 (name, join_code) values ('
On Sep 24, 2004, at 10:42 AM, Eddy Macnaghten wrote:
I am getting some tests together now. As soon as I have got it ready
enough I will put it on my site and inform the list...
As a part of your tests, it would be helpful to have some abuse tests
that involve multiple processes reading/writing ag
On Fri, 2004-09-24 at 16:50, Ara.T.Howard wrote:
> On Fri, 24 Sep 2004, Eddy Macnaghten wrote:
>
> > There is no way I can guarantee the "nfs" to be good. Also, a mixture of
> > Linux and Windows clients need to be allowed for, I do not know how SAMBA
> > supports the fcntl functionality, or how
Hi,
I'm currently trying to get SQLite 2.8.15 running on QNX 6.2.1 compiled
for the SH4 processor. One big problem is the paging/locking algorithm.
It only works when I defined __DJGPP__ otherwise SQLite says "Database
is locked". But that means that I can't concurrently access a database
from
On Fri, 24 Sep 2004, Matt Sergeant wrote:
On 24 Sep 2004, at 17:43, Ara.T.Howard wrote:
On Fri, 24 Sep 2004, Matt Sergeant wrote:
On 24 Sep 2004, at 14:51, Ara.T.Howard wrote:
What are people's views on this?
i think it's sufficiently common to merit discussion on best practices
at
least.
More tha
EzTools Support wrote:
> I'm just wondering why I have not received any comment regarding this
> issue...?
>
> EzTools Support wrote:
>
>> Hello DRH. This is further to the previous query regarding no type
>> information being returned with Views. I had previously asked if
>> this could be added,
On 24 Sep 2004, at 17:43, Ara.T.Howard wrote:
On Fri, 24 Sep 2004, Matt Sergeant wrote:
On 24 Sep 2004, at 14:51, Ara.T.Howard wrote:
What are people's views on this?
i think it's sufficiently common to merit discussion on best
practices at
least.
More than that, I'm thinking there might be a call
On Fri, 24 Sep 2004, David Fletcher wrote:
Hi all,
http://opendlm.sourceforge.net might be an interesting place to
start.
great link. thanks!
-a
--
===
| EMAIL :: Ara [dot] T [dot] Howard [at] noaa [dot] gov
| PHONE ::
On Fri, 24 Sep 2004, Matt Sergeant wrote:
On 24 Sep 2004, at 14:51, Ara.T.Howard wrote:
What are people's views on this?
i think it's sufficiently common to merit discussion on best practices at
least.
More than that, I'm thinking there might be a call for an os_nfs.c that uses
this NFS clean lock
Hi all,
http://opendlm.sourceforge.net might be an interesting place to
start.
--
David Fletcher Tuscany Design Automation, Inc.
[EMAIL PROTECTED] 5875 S. Danube Circle
303.690.4309Aurora, CO 80015-3169 USA
> "MS" ==
On 24 Sep 2004, at 14:51, Ara.T.Howard wrote:
What are people's views on this?
i think it's sufficiently common to merit discussion on best practices
at
least.
More than that, I'm thinking there might be a call for an os_nfs.c that
uses this NFS clean locking mechanism.
Matt.
___
On Fri, 24 Sep 2004, Eddy Macnaghten wrote:
There is no way I can guarantee the "nfs" to be good. Also, a mixture of
Linux and Windows clients need to be allowed for, I do not know how SAMBA
supports the fcntl functionality, or how well it interfaces with the Windows
Server or Client locking mecha
On Fri, 2004-09-24 at 14:51, Ara.T.Howard wrote:
> On Fri, 24 Sep 2004, Eddy Macnaghten wrote:
>
> > However, reading the documentation it seems that SQLite is not hot on
> > concurrent access through networks, or across platforms, due to the funnies
> > of fcntl, or incompatibilities between Wind
On Fri, 24 Sep 2004, Eddy Macnaghten wrote:
However, reading the documentation it seems that SQLite is not hot on
concurrent access through networks, or across platforms, due to the funnies
of fcntl, or incompatibilities between Windows and Linux and so on.
it works o.k. if your nfs impl is good (n
Hello sqlite users,
Hello dr. Hipp,
I was wondering if there is a way to find table(s) name(s) from a precompiled
statement, e.g.
Similar to sqlite3_column_count and sqlite3_column_name to have
sqlite3_table_count and sqlite3_table_name.
Thanks.
Regards,
George Ionescu
> I'd probably initially do it for 3.x, as 2.x is basically in feature
> freeze, I believe. Are you 2.x based?
Yes, I am, for it was the only stable version when the project was started.
And I'd prefer to stay on it since version 3 is too young, its docs are not
complete (AFAIK). So, if possible,
On Thu, 23 Sep 2004, Alex wrote:
>> If I have time at the weekend, I might have a bash at producing a patch
>> that will implement what is required. No promises, mind.
>>
>> What would be preferred? Convert the trigger to an update trigger, or fire
>> a delete trigger followed by an insert trigger
I'm creating a few prepared statements using sqlite3_prepare; making
that call seems to set db->pVdbe to the newly compiled statement,
which seems reasonable. However, calling sqlite3_create_function
after this results in SQLITE_ERROR, with an error message indicating
that the library functions we
29 matches
Mail list logo