Re: [sqlite] Downloadable SQLite documentation

-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:

[sqlite] Multiple process using the same database

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

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

"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

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

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

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

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

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,

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

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

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

"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

[sqlite] SQLite 3.5.2 - Unix - Memory issue?

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

RE: [sqlite] Checking out the performance of sqlite3

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?)

[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

Re: [sqlite] Resetting a Primary Key

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

Re: [sqlite] Resetting a Primary Key

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

[sqlite] Can't checkout from cvs

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

[sqlite] Downloadable SQLite documentation

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

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

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

RE: [sqlite] Checking out the performance of sqlite3

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

[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