In case the designer knows that the DB file will be accessed by a single
program-thread throught the run - then there should be some sort of flag
indicating that SQLITE should execute minimum locking-related code.
We were facing problems with flock over NFS mounted file systems. Since
we din't
Hi all,
I'm working on a system to add full-text indexing on top of SQLite in a
semi-automated way. The general idea is that users will call an API to
"register" a document table for indexing, and the system will take care of
everything from there.
When a row is added to a registered document
<[EMAIL PROTECTED]> wrote:
> Hi all
>
> it seems that I am running in a problem with the way sqlite accesses the disk
> when inserting rows of data in databases that are large in number of records
> but not necessary big on disk (I am talking millions of records in files that
> are in the
I would say that the best way to access a sqlite database mounted from a
remote file server, concurrently with other processes is through a database
server. My opinion is that the overhead of file sync and file locking for a
remote file system is higher than simple TCP/IP communication overhead.
All,
In order to provide locking support for database files mounted from
remote file systems (NFS, SMB, AFP, etc) as well as provide
compatible locking support between database clients both local and
remote, I would like to propose some additions to the existing
database file locking
Hi all
it seems that I am running in a problem with the way sqlite accesses the disk
when inserting rows of data in databases that are large in number of records
but not necessary big on disk (I am talking millions of records in files that
are in the order of a few hundred MBytes).
I reduced
I will be out of the office starting 2006-03-08 and will not return until
2006-03-12.
I am on vacation from Wed 8th March to Friday 10th March. I will not be
having access to the mails in this time. I will respond to your message
when I return on Monday 13th March.
On Tue, Mar 07, 2006 at 03:52:35PM -0500, [EMAIL PROTECTED] wrote:
> "Marvin K. Bellamy" <[EMAIL PROTECTED]> wrote:
> > Is there a safe way to open a database on Windows by passing in a file
> > HANDLE instead of a file path?
> >
>
> No. SQLite must know the name of the file so that it can
>
Thanks, that seems to have fixed the problem...
Steve
Eric Bohlman wrote:
Nathan Kurz wrote:
On Mon, Mar 06, 2006 at 06:24:13PM -0800, Steve Green wrote:
Hi,
I'm hoping that someone can shed some light on the following issue that
I'm seeing. When I attempt to create a temp table using
Is there a safe way to open a database on Windows by passing in a file
HANDLE instead of a file path?
--
Marvin Keith Bellamy
Software Engineer
Innovision Corporation
913.438.3200
It depends upon your application. What are you trying to do?
Ludovic Ferrandis wrote:
Thanks for your answers,
but that still don't explain me which method is the best to manage Busy
statement, to do a loop or to use a busy callback. And as I'm very curious,
especially why one method is
Thanks everyone for your prompt responses.
Here is what I found. I was running the correct executable, however
I had some stale .so files hanging around down in /usr/lib, while
the ones that I wanted to use where in /usr/local/lib .
I blew away the ones down in /usr/lib, reran ldconfig and
Chuck Lima <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I just compiled and installed sqlite-3.3.4 on FC4 and it seems to be
> running just fine, except for a few things.
>
> sqlite3 -version returns 3.1.4
>
> This in itself is not a problem, but I can't seem to get constraints
> to work and the
Chuck Lima wrote:
Hi,
I just compiled and installed sqlite-3.3.4 on FC4 and it seems to be
running just fine, except for a few things.
sqlite3 -version returns 3.1.4
This in itself is not a problem, but I can't seem to get constraints
to work and the documentation indicates that I need
On 3/7/06, Chuck Lima <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I just compiled and installed sqlite-3.3.4 on FC4 and it seems to be
> running just fine, except for a few things.
>
> sqlite3 -version returns 3.1.4
>
> This in itself is not a problem, but I can't seem to get constraints
> to work and
Hi,
I just compiled and installed sqlite-3.3.4 on FC4 and it seems to be
running just fine, except for a few things.
sqlite3 -version returns 3.1.4
This in itself is not a problem, but I can't seem to get constraints
to work and the documentation indicates that I need version >= 3.3 .
Is
On Mon, 6 Mar 2006, Dale Qualls wrote:
>Okay, here's a strange one. I have sqlite dbs for every day of the week.
>Every db is the same (contains 4 tables) as far as structure goes.
>
>Is there a method from the command line (on a win32 box) that I can use
>the sqlite.exe to merge 10 days (so 10
Great, I'll give it a shot!
Thanks much!
>>> [EMAIL PROTECTED] 3/7/2006 9:43:05 AM >>>
Dale Qualls wrote:
>Okay, here's a strange one. I have sqlite dbs for every day of the week.
>Every db is the same (contains 4 tables) as far as structure goes.
>
>Is there a method from the command
Dale Qualls wrote:
Okay, here's a strange one. I have sqlite dbs for every day of the week.
Every db is the same (contains 4 tables) as far as structure goes.
Is there a method from the command line (on a win32 box) that I can use the sqlite.exe to
merge 10 days (so 10 dbs) worth of data
Thanks a lot Jay, that seems to work.
On Tue, 2006-03-07 at 09:14 -0600, Jay Sprenkle wrote:
> On 3/7/06, Roger <[EMAIL PROTECTED]> wrote:
>
> > What i would like to do is to write for my reports with a column called
> > "Advertising Type" which when either one or more of the above fields has
>
On 3/7/06, Roger <[EMAIL PROTECTED]> wrote:
> What i would like to do is to write for my reports with a column called
> "Advertising Type" which when either one or more of the above fields has
> 1, it should show for instance if :
>
> Classified_Advertising = 1
> Display_Advertising = 1
>
"Ludovic Ferrandis" <[EMAIL PROTECTED]> wrote:
> I was wondering if there was limitations for one of the 2 methods. If they
> are identicals, I know which one I will use.
>
They are essentially different interfaces to the same underlying
mechanism.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Markus Kolb wrote:
> Hello,
>
> I open one connection to a sqlitedb and do a few successful autocommited
> sqlite3_exec() calls.
> Then I want to use the db handle to call another sqlite3_exec() with SQL
> code for a transaction.
> Before I close the connection I call again sqlite3_exec() with
I was wondering if there was limitations for one of the 2 methods. If they
are identicals, I know which one I will use.
Thanks a lot.
On 3/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> "Ludovic Ferrandis" <[EMAIL PROTECTED]> wrote:
> > Thanks for your answers,
> >
> > but that still
"Ludovic Ferrandis" <[EMAIL PROTECTED]> wrote:
> Thanks for your answers,
>
> but that still don't explain me which method is the best to manage Busy
> statement, to do a loop or to use a busy callback. And as I'm very curious,
> especially why one method is better than the other. :)
>
That is
"angshuman" <[EMAIL PROTECTED]> wrote:
> Hi,
> I have downloaded the binaries and the command line program for sqlite
> 3.3.4.
> I fired the following query
>
> "SELECT @BrandID=Brandid from M_SetOfCodes WHERE SetOFCodesID = 74;
> SELECT BrandName FROM M_Brands WHERE BrandID = @BrandID; "
>
>
Thanks for your answers,
but that still don't explain me which method is the best to manage Busy
statement, to do a loop or to use a busy callback. And as I'm very curious,
especially why one method is better than the other. :)
Thanks,
Ludovic
On 3/5/06, John Stanton <[EMAIL PROTECTED]> wrote:
Can someone please help
I have the following fields in my database
Classified_Advertising
Display_Advertising
Sponsored_Editorial
Recruitment_Advertising
Each of this fields can store either 0 or 1 with one indicating that the
mentioned advertising is available, i use this in my web application
an someone please help!
I have the following fields in my database
Recruitment_Advertising
Advertorial
Sponsored_Editorial
On 3/7/06, Stefan de Konink <[EMAIL PROTECTED]> wrote:
> On Tue, 7 Mar 2006, Firman Wandayandi wrote:
>
> > On 3/7/06, Stefan de Konink <[EMAIL PROTECTED]> wrote:
> > > Hello,
> > >
> > >
> > > We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs
> > > our TV Newspaper System. It
On Tue, 7 Mar 2006, Firman Wandayandi wrote:
> On 3/7/06, Stefan de Konink <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> >
> > We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs
> > our TV Newspaper System. It was running on a PIII-1GHz but due some
> > shifts for rendering
31 matches
Mail list logo