Re: [sqlite] HELP!!!! LINKING AND LOADING FTS - on Linux/Ubuntu

is the fts2 a library? if so you probably need to put it in a directory that is in the list of library directory's. You also may need to run ldconfig to update the dynamic linker as the the whereabouts of your new lib. use "man ldconfig" for the how-to Scott Uma Krishnan wrote: Hello,

Re: [sqlite] Re: Re: Merging two tables

How can this be used to "Merge two tables"? Scott RaghavendraK 70574 wrote: Thats great. If possible Can u please provide a sample, Will this function receive the database column values or indexes? regards ragha

Re: [sqlite] Eliminate duplicate entries

yes, after reflecting on it that may be the easiest and less processor intensive... Thanks, Scott John Elrick wrote: Scott Derrick wrote: I have an application that is inserting a record every second. There are thousands of periods from a few seconds to hours long where the data in all

[sqlite] Eliminate duplicate entries

I have an application that is inserting a record every second. There are thousands of periods from a few seconds to hours long where the data in all the columns is identical thus causing hundreds of thousands of duplicate rows. Is there a way to set up the INSERT statement to allow the

[sqlite] Merging two tables

Whats the procedure and rules for merging two tables? I have table #1, with a possible 86 thousand entries a day. an embedded application is storing sensor data. I have table #2, with a possible 50 entries a day. Both tables have a date/time field. Do I need duplicate columns in both

Re: [sqlite] remote access to sqlite db?

You could always use rails and get to your database through an html connection. You can take your choice of web servers though the built in mongrel-rails server will easily handle 20-30 concurrent connections. Scott Kees Nuyt wrote: On Sun, 2 Sep 2007 23:23:43 -0400, you wrote: Hi, Does

Re: [sqlite] Odd error on "BEGIN IMMEDIATE"

OK, I understand. Must have miss read teh docs.. thanks, Scott Trevor Talbot wrote: On 8/17/07, Scott Derrick <[EMAIL PROTECTED]> wrote: exec a "BEGIN IMMEDIATE", with a sleep loop if I can't acquire the reserved lock. Then prepare, step, finalize, exit the function

[sqlite] Odd error on "BEGIN IMMEDIATE"

I have a process that repeatedly, once a second, inserts data into the database. I open the database, on the class instantiation. once a second I call a function that; exec a "BEGIN IMMEDIATE", with a sleep loop if I can't acquire the reserved lock. Then prepare, step, finalize, exit the

[sqlite] UI question

This is probably a stupid question but has frustrated me a couple of times. When using the command line interface sqlite3, a couple of times I have forgotten to use the "." before a command. After that I get a "...>" prompt that I can't seem to escape from and accepts no commands? My only

Re: [sqlite] In-Memory Database: Delete rows on a Table increases the memory usage.

are you saying this is a memory leak? sqlite never gives back the unused memory? Christian Smith wrote: Lokesh Babu uttered: Hello Folks, When I perform the DELETE operation on a Table using In-Memory Database (":memory:"), the memory usage increases. I tried using PRAGMA auto_vacuum=1;

[sqlite] quickest way to duplicate table data?

I am using sqlite in an embedded application. The data store table will be in its own file. The data acquisition application will be storing a row every 1 to 5 seconds and cannot be interrupted for more than a couple seconds. A web server will access the table for read access in two