Re: [sqlite] Downloadable SQLite documentation

2007-11-21 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

[EMAIL PROTECTED] wrote:
>   (2) Downloadable documentation is a popular feature.

It would be nice if it also included some of the wiki pages.  For
example virtual tables are only documented in the wiki.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHRK7ZmOOfHg372QQRAv7IAJ9ogB+kGrp+lYoOHmyWuijMBztjMQCgv0GS
HRvIRm5jabmvWbxVXNmQ3Gk=
=Cxqk
-END PGP SIGNATURE-

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Multiple process using the same database

2007-11-21 Thread Prakash Reddy Bande
Hello,

 

I have more than one process using the same database. When process 1
modifies the database, I want to get some kind of notification to the
other processes. Ideally I would like to know the table and the rowid
that are affected by the change in the database. I need this to
synchronize any in memory cached data in my processes.

 

How do I go about achieving this?

 

Regards,

 

Prakash Reddy Bande

Altair Engg. Inc,

Troy, MI

 



Re: [sqlite] SQLite 3.5.2 - Unix - Memory issue?

2007-11-21 Thread drh
"Mark Brown" <[EMAIL PROTECTED]> wrote:
> I was using the noLocking style.  Is that essentially what you get with
> SQLITE_THREADSAFE = 0?
> 

The locking style has absolutely nothing to do with
threads.  Locking style is what kind of file locks
are used to prevent separate processes from updating
the same database as the same time.  SQLite uses
posix advisory locks by default.  Not all systems
support posix advisory locks correctly, which is the
reason for providing alternatives.
--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Detailed notes on compiling full-text search

2007-11-21 Thread Clark Christensen
DBD-SQLite, by default, builds using your installed version of SQLite by 
default (assuming it can find the SQLite headers it needs).

It might be as simple as just configuring/building like any other Perl module.

Maybe I'll fiddle with that over the holiday weekend :-))

 -Clark

- Original Message 
From: P Kishor <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Wednesday, November 21, 2007 8:53:24 AM
Subject: Re: [sqlite] Detailed notes on compiling full-text search


On 11/21/07, Clark Christensen <[EMAIL PROTECTED]> wrote:
> Were you able to build DBD-SQLite using the resulting library?

No, I haven't ventured that far. I discovered the Matt Sergeant has
already built fts2 into DBD::SQLite 1.14 (with SQLite 3.4.2), so my
problem was solved temporarily.

Yes, I would like to learn how to build DBD::SQLite with a different
version of the SQLite source code, so if someone on this list can give
me pointers, I would be happy to try it out, and if successful, post
the instructions for that as well on the wiki.

I have seen Matt on this list on occasion, so maybe if he reads this
he would be kind enough to provide some guidance.

I will also ask on Perlmonks.


>
> Thanks!
>
>  -Clark
>
> - Original Message 
> From: P Kishor <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Wednesday, November 21, 2007 7:18:20 AM
> Subject: [sqlite] Detailed notes on compiling full-text search
>
>
> http://www.sqlite.org/cvstrac/wiki?p=CompilingFts
>
> Not being very conversant with the ins and outs of compiling
 software,
> I had to do a lot of undue diligence to get this working, so I hope
> this is of help to someone.
>
> By the way, fts is the greatest thing since... since the world's most
> widely used database. My compliments to the chefs.
>
> Please consider making a Makefile for it so compiling or not
 compiling
> full-text search is just a matter of throwing a switch in configure.
>
> Many thanks,
>
> --
> Puneet Kishor
>
>
 -
> To unsubscribe, send email to [EMAIL PROTECTED]
>
 -
>
>
>
>
>
>
 -
> To unsubscribe, send email to [EMAIL PROTECTED]
>
 -
>
>


-- 
Puneet Kishor
http://punkish.eidesis.org/
Nelson Institute for Environmental Studies
http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo)
http://www.osgeo.org/
Summer 2007 S Policy Fellow, The National Academies
http://www.nas.edu/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] SQLite 3.5.2 - Unix - Memory issue?

2007-11-21 Thread Mark Brown
I was using the noLocking style.  Is that essentially what you get with
SQLITE_THREADSAFE = 0?

Thanks,
Mark


> 
> I recommend that you *not* use LOCKING_STYLE.  It is
> disabled by default.  Dan and I have a note to go back
> and get the LOCKING_STYLE stuff working, but we have not
> gotten around to that yet, being distracted by more
> pressing issues.



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Detailed notes on compiling full-text search

2007-11-21 Thread P Kishor
On 11/21/07, Clark Christensen <[EMAIL PROTECTED]> wrote:
> Were you able to build DBD-SQLite using the resulting library?

No, I haven't ventured that far. I discovered the Matt Sergeant has
already built fts2 into DBD::SQLite 1.14 (with SQLite 3.4.2), so my
problem was solved temporarily.

Yes, I would like to learn how to build DBD::SQLite with a different
version of the SQLite source code, so if someone on this list can give
me pointers, I would be happy to try it out, and if successful, post
the instructions for that as well on the wiki.

I have seen Matt on this list on occasion, so maybe if he reads this
he would be kind enough to provide some guidance.

I will also ask on Perlmonks.


>
> Thanks!
>
>  -Clark
>
> - Original Message 
> From: P Kishor <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Wednesday, November 21, 2007 7:18:20 AM
> Subject: [sqlite] Detailed notes on compiling full-text search
>
>
> http://www.sqlite.org/cvstrac/wiki?p=CompilingFts
>
> Not being very conversant with the ins and outs of compiling software,
> I had to do a lot of undue diligence to get this working, so I hope
> this is of help to someone.
>
> By the way, fts is the greatest thing since... since the world's most
> widely used database. My compliments to the chefs.
>
> Please consider making a Makefile for it so compiling or not compiling
> full-text search is just a matter of throwing a switch in configure.
>
> Many thanks,
>
> --
> Puneet Kishor
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>
>
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>


-- 
Puneet Kishor
http://punkish.eidesis.org/
Nelson Institute for Environmental Studies
http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo)
http://www.osgeo.org/
Summer 2007 S Policy Fellow, The National Academies
http://www.nas.edu/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Detailed notes on compiling full-text search

2007-11-21 Thread Clark Christensen
Were you able to build DBD-SQLite using the resulting library?

Thanks!

 -Clark

- Original Message 
From: P Kishor <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Wednesday, November 21, 2007 7:18:20 AM
Subject: [sqlite] Detailed notes on compiling full-text search


http://www.sqlite.org/cvstrac/wiki?p=CompilingFts

Not being very conversant with the ins and outs of compiling software,
I had to do a lot of undue diligence to get this working, so I hope
this is of help to someone.

By the way, fts is the greatest thing since... since the world's most
widely used database. My compliments to the chefs.

Please consider making a Makefile for it so compiling or not compiling
full-text search is just a matter of throwing a switch in configure.

Many thanks,

--
Puneet Kishor

-
To unsubscribe, send email to [EMAIL PROTECTED]
-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] SQLite 3.5.2 - Unix - Memory issue?

2007-11-21 Thread drh
"Mark Brown" <[EMAIL PROTECTED]> wrote:
> Hi-
> 
> I am currently migrating over from 3.4 to 3.5.2.  I am creating a custom
> VFS, but it is essentially the same as unix.
> 
> As I was going through the code, there was a particular section that =
> made me
> think that it may not have been migrated correctly.
> 
> In the fillInUnixFile() method (and assuming that
> SQLITE_ENABLE_LOCKING_STYLE is defined), 

I recommend that you *not* use LOCKING_STYLE.  It is
disabled by default.  Dan and I have a note to go back
and get the LOCKING_STYLE stuff working, but we have not
gotten around to that yet, being distracted by more
pressing issues.

--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] SQLite 3.5.2 - Unix - Memory issue?

2007-11-21 Thread Mark Brown
Hi-

I am currently migrating over from 3.4 to 3.5.2.  I am creating a custom
VFS, but it is essentially the same as unix.

As I was going through the code, there was a particular section that made me
think that it may not have been migrated correctly.

In the fillInUnixFile() method (and assuming that
SQLITE_ENABLE_LOCKING_STYLE is defined), my concern is at line 2196:

  pNew = sqlite3_malloc( sizeof(unixFile) );

(in context, the surrounding code is:)

  pNew->dirfd = -1;
  pNew->h = h;
  SET_THREADID(pNew);
  pNew = sqlite3_malloc( sizeof(unixFile) );  /* <--- This line */
  if( pNew==0 ){
close(h);
enterMutex();
releaseLockInfo(pNew->pLock);
releaseOpenCnt(pNew->pOpen);
leaveMutex();
return SQLITE_NOMEM;
  }else{
switch(lockingStyle) {

It seems like the allocation will wipe out previous set values and cause a
memory leak.  Could someone verify?

Thanks,
Mark



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Checking out the performance of sqlite3

2007-11-21 Thread Griggs, Donald
From: kirrthana M [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 21, 2007 4:25 AM

 "Just want to know the time it takes to read and write data,.."

-

Hello, Kirrthana,

  Much depends upon your data, your schema, your settings within SQLITE
(e.g. do you require ACID transactions?) etc., etc.

  For a lot of folks, the read/write speed is limited by the speed of
the hard disk drive (7500rpm and 15000 rpm).

  If you haven't already, you'll likely want to see:
http://sqlite.org/speed.html

Donald

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Detailed notes on compiling full-text search

2007-11-21 Thread P Kishor
http://www.sqlite.org/cvstrac/wiki?p=CompilingFts

Not being very conversant with the ins and outs of compiling software,
I had to do a lot of undue diligence to get this working, so I hope
this is of help to someone.

By the way, fts is the greatest thing since... since the world's most
widely used database. My compliments to the chefs.

Please consider making a Makefile for it so compiling or not compiling
full-text search is just a matter of throwing a switch in configure.

Many thanks,

--
Puneet Kishor

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Resetting a Primary Key

2007-11-21 Thread Dennis Cote

Mitchell Vincent wrote:

I found a solution - apparently the DB file was just hosed. There were
actually duplicates stored somehow.

I dumped the database to a flat file and modified the IDs by hand then
imported the data into a new SQLite database. That seemed to do the
trick. I'm not sure how the corruption happened but my users have been
known to do things like store the live data file on a USB flash drive
and use it so it's hard to tell!

Thanks to all for the information and suggestions!

  

I'm glad to see you got it resolved and didn't loose your data.

Dennis Cote

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Resetting a Primary Key

2007-11-21 Thread Dennis Cote

Mitchell Vincent wrote:

I'm not sure what it means, but here it is :

*** in database main ***
On page 2580 at right child: 2nd reference to page 2677
On tree page 9 cell 15: 2nd reference to page 2678
On tree page 9 cell 15: Child page depth differs
On tree page 9 cell 16: Child page depth differs
Page 2681 is never used
Page 2682 is never used
Page 2683 is never used
...


This means your database is hosed. :-)

If everything was correct, the integrity check would have simply 
returned "OK".


There is generally no practical way to resurrect a corrupt database 
file. It's time to get out your backup.


Dennis Cote




-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Can't checkout from cvs

2007-11-21 Thread Rael Bauer
I did find the source of the problem in the end.
   
  besides the windows firewall, the dsl router had it's own firewall. when I 
disabled this, I was able to connect to cvs without problems.
   
  Rael

   
-
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.

[sqlite] Downloadable SQLite documentation

2007-11-21 Thread drh
In response to ticket #2781, I put a ZIP archive on the
download site that contains all of the static HTML files
from the website.  That link has been up for about 12
hours now and was completely unadvertised.  Yet already
there have been 142 downloads, making it the 2nd most
popular download in terms of bandwidth consumed.  From 
this I infer two things:

  (1) Lots of people watch the CVSTrac timeline for
  changes.  (Perhaps using the RSS feed?)

  (2) Downloadable documentation is a popular feature.

Links:

   http://www.sqlite.org/cvstrac/tktview?tn=2781
   http://www.sqlite.org/download.html

--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] .dump returns error 32512... sometimes

2007-11-21 Thread Jevgenijs Rogovs
Hi everyone,

I have a script that does some backup. Amongst other things, it dumps
certain SQLite database, like sqlite3 /path/to/db/dname.db .dump > somefile.
When I run the script manually from the command line, it works like a charm.
If, however, I launch it via crontab - it fails. sqlite3 returns error code
32512, which I cannot decypher... Nor can I understand what happens with the
script when it is scheduled to run automatically.

Can anyone advise please?

I'm running SQLite 3.5.2 on Linux.

Thanks in advance!

With best regards,
J.R.


RE: [sqlite] Checking out the performance of sqlite3

2007-11-21 Thread Kalyani Tummala
Kirthana,
I have done memory and performance analysis on windows, linux and other
embedded platforms like Davinci,DM320,PNX0103 etc.,

With the same parameters memory on all the platforms is same but we
cannot take performance numbers(time) on PCs(win32,linux) because they
don't reflect the actual numbers.

How do you want to do this analysis?

-Original Message-
From: kirrthana M [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 21, 2007 2:55 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Checking out the performance of sqlite3

Hi all,
 I just want to compare the performance of sqlite on various os and in
embedded,
Just want to know the time it takes to read and write data,can anybody
give
me a suggestion of how to do this.


Regards
Kirrthana

The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain proprietary, confidential or privileged information. If
you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and
destroy all copies of this message and any attachments contained in it.

Contact your Administrator for further information.

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[EMAIL PROTECTED]
**


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Checking out the performance of sqlite3

2007-11-21 Thread kirrthana M
Hi all,
 I just want to compare the performance of sqlite on various os and in
embedded,
Just want to know the time it takes to read and write data,can anybody give
me a suggestion of how to do this.


Regards
Kirrthana

The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments contained in it.

Contact your Administrator for further information.