From: Murthy Girigowda (WT01 - TES-Access Networks)
Sent: Friday, February 08, 2008 12:25 PM
To: 'sqlite-users@sqlite.org'
Subject: VFS memory leak : During lock / unlock operations
Hi..
we are using sqlite3.3.4 with Integrity OS. we are facing a problem
Hi..
we are using sqlite3.3.4 with Integrity OS. we are facing a problem
where in the VFS memory is getting exhausted due
to large lock/unlock calls made by sqlite. Integrity support team
said that, for each file lock call made by sqlite, a definite amount
of memory is allocated, this
"Trey Mack" beautifully wrote...
> Is this what you're after?
>
> create table LSOpenJobs (PSubClass);
> insert into lsopenjobs values ('DOC-Trans');
> insert into lsopenjobs values ('DTP');
> insert into lsopenjobs values ('PM');
> insert into lsopenjobs values ('Post-Proc');
> insert into lsop
On Feb 8, 2008, at 11:31 AM, Rob Sciuk wrote:
>
> How do I sign up for the digest rather than the regular feed??
>
>
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Use the webpage linked above.
Dan.
___
sqlite-users mailing list
sqlit
Is this what you're after?
create table LSOpenJobs (PSubClass);
insert into lsopenjobs values ('DOC-Trans');
insert into lsopenjobs values ('DTP');
insert into lsopenjobs values ('PM');
insert into lsopenjobs values ('Post-Proc');
insert into lsopenjobs values ('Pre-Proc');
select * from lsopenjo
"P Kishor" asked...
>I don't understand your question at all.
I will answer it at the end.
> On 2/7/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
>>
>> Greetings.
>>
>> I would like to have the results of a select be returned sorted in an
>> specific way. Let me show you what I mean:
>>
Goto http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
"Would you like to receive list mail batched in a daily digest? No
Yes"
On Feb 8, 2008 5:31 AM, Rob Sciuk <[EMAIL PROTECTED]> wrote:
>
> How do I sign up for the digest rather than the regular feed??
>
> Cheers,
> Rob.
>
"jose isaias cabrera" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> I would like to have the results of a select be returned sorted in an
> specific way. Let me show you what I mean:
>
> sqlite> SELECT PSubClass FROM LSOpenJobs WHERE subProjID = 2190 GROUP
> BY PSubClass;
> DOC-Tra
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Lee Crain wrote:
> My response to your request for an example of a benefit is that I have
> always been an adherent of strict datatyping as a means of trapping
> inadvertent software development errors.
There are also a whole school of people who beli
I don't understand your question at all.
On 2/7/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
>
> Greetings.
>
> I would like to have the results of a select be returned sorted in an
> specific way. Let me show you what I mean:
>
> sqlite> SELECT PSubClass FROM LSOpenJobs WHERE subProjID = 2
Greetings.
I would like to have the results of a select be returned sorted in an
specific way. Let me show you what I mean:
sqlite> SELECT PSubClass FROM LSOpenJobs WHERE subProjID = 2190 GROUP BY
PSubClass;
DOC-Trans
DTP
PM
Post-Proc
Pre-Proc
sqlite>
What I would like is to have the SELECT
How do I sign up for the digest rather than the regular feed??
Cheers,
Rob.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Feb 8, 2008, at 6:10 AM, Jason Tudor wrote:
> Thanks for the quick feedback, you all have good points. The data
> transfer
> example that Sam provided is the most compelling to me.
Another reason is that a transaction that writes to
more than one attached database is still an atomic
opera
Hi,
I am interested in joining the sqlite-users mailing list.
Kindly add my name.
Thanks & Regards,
Mahalakshmi
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, February 08, 2008 8:22 AM
To: sqlite-users@sqlite.org
Subject: s
Trey,
Could you site a reference on this? I have been looking for documentation on
how SQL deals with quoted things for a while now, but have not found
anything.
Thanks,
Mike
On Feb 6, 2008 8:21 PM, Trey Mack <[EMAIL PROTECTED]> wrote:
>
> UPDATE listings SET buyer = 'Price' WHERE listnum = 12
DRH,
">> Can you explain why you think strict affinity mode
>> might be beneficial to you? If somebody can provide a good
>> enough rational to justify strict affinity mode, we might just put it
>> in."
My response to your request for an example of a benefit is that I have
always been an adheren
Jason Tudor wrote:
>
> In order to get the count from a particular table, I could do the following:
>
> SELECT COUNT id FROM main.table UNION
> SELECT COUNT id FROM db2.table
>
> I would then step through the result and add the two values to get a total
> count.
That would not be the optimal use in
On Thu, Feb 07, 2008 at 06:17:19PM -0500, Samuel R. Neff wrote:
> A blanket "stay away" is pretty extreme. I would rather be able to have
True. One use case discussed before would be to archive history data
from one DB to another, then reset the history tables in the first one.
_
A blanket "stay away" is pretty extreme. I would rather be able to have
triggers across attached databases, but without that will use them less, but
still there are times when they're very useful and you have no need for
triggers.
Sam
---
We're Hiring!
Thanks for the quick feedback, you all have good points. The data transfer
example that Sam provided is the most compelling to me.
I was initially thinking that I could attach every database I had with the
same schema and execute queries without specifying database names. It's
good to know the
Given the restrictions on views and triggers (they cannot make reference
to tables from more than one database) I'd say "stay away from ATTACH
where possible" -- don't create new uses of it without good reason.
___
sqlite-users mailing list
sqlite-users@s
It's particularly valuable when you want to run queries across databases.
INSERT INTO main.table
SELECT *
FROM newdata.table;
Also if it's possible for you to segment out your data to multiple databases
but normally only work with one of them, then you can increase performance
and concurrency fo
On Feb 7, 2008 3:21 PM, Jason Tudor <[EMAIL PROTECTED]> wrote:
> In general, what is the benefit of attaching databases verses maintaining
> multiple connections?
Well, let's say that you don't have the same schema in both databases.
Attaching two databases allows you to do queries across multipl
I have been playing around with attaching databases. I'm not sure what the
point is.
Assume that I have two databases with the same schema, say db1 and db2, and
I attach them to one connection.
In order to get the count from a particular table, I could do the following:
SELECT COUNT id FROM main
Trey,
Thank you for the prompt reply.
Did not realize that double quote would denote column name. Will have to
check for column names when building sql statement and insert single quotes
around that part of data.
Thanks again
Walt Mc Whirter
- Original Message -
From: "Trey Mack"
Am attempting to create a few reports from SQLite data that is collected
in an application that uses SQLite as its data store. I'm using Visual
Studio 2005 in this effort, creating a Windows Forms application.
When I attempt to create an ORDER BY in my DataSet, I get an error as
such:
SQLit
___
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
The same here:
# wget http://sqlite.org/sqlite3-3.5.6-osx-x86.bin.gz
--12:29:52-- http://sqlite.org/sqlite3-3.5.6-osx-x86.bin.gz
=> `sqlite3-3.5.6-osx-x86.bin.gz'
Resolving sqlite.org... 67.18.92.124
Connecting to sqlite.org[67.18.92.124]:80... connected.
HTTP request sent, awaiting re
Hi All,
I cannot download the: http://sqlite.org/sqlite3-3.5.6-osx-x86.bin.gz
No problems with other downloads
Need help. Thanks
Coen J
Error:
Safari can’t open the page “http://sqlite.org/sqlite3-3.5.6-osx-
x86.bin.gz” because the server unexpectedly dropped the connection,
which sometimes
30 matches
Mail list logo