On 12/19/06, Laszlo Elteto <[EMAIL PROTECTED]> wrote:
For this particular application it would NOT be a problem to lose like 2-5
seconds of transactions. I wonder if it is possible to tell SQLite to "hold
off" the transactions, ACCUMMULATE them until a certain time (or if cache
memory is
Hi,
I would like to implement a time zone independent function. So I get
the time zone information from user, and plans to convert the datetime
to the time zone specified. To make it clear I give an example
here StartTime is stored as an integer in the database
select
There are a few problems with your patch.
+# ifdef _WIN32_WCE
+static HANDLE loadLibraryUtf8(const char *z){
+ WCHAR zWide[MAX_PATH];
+ MultiByteToWideChar(CP_ACP,0,z,-1,zWide,MAX_PATH);
+ return LoadLibrary(zWide);
+}
+# define SQLITE_OPEN_LIBRARY(A) loadLibraryUtf8(A)
Can somebody with access to wince please test patch [3537]
for me and let me know if it works to fix ticket #2023.
http://www.sqlite.org/cvstrac/chngview?cn=3537
http://www.sqlite.org/cvstrac/tktview?tn=2023
--
D. Richard Hipp <[EMAIL PROTECTED]>
Laszlo Elteto <[EMAIL PROTECTED]> wrote:
> I DO need Durability, so I don't want to drop that. In fact, I need and want
> normal transactional updates - just not immediately flushed to disk.
If the information is not flushed to disk, how can it be durable?
--
D. Richard Hipp <[EMAIL
Rashmi Hiremath wrote:
Can anyone send me the code of C++ API for
SQLite3.3.8.
Check out http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers in
particular the section on C++.
I would suggest CppSQLite as it provides full access to sqlite with a
very thin interface.
HTH
Dennis Cote
i've a big database 8 Gb with few tables all necessary indexes and many
read-only access
i'v 4Gb ram a fast disk/network
update and delete are once at day and few record so i can stop the access in
that time.
I think to modify these parameters, which values to use??
PRAGMA default_cache_size
Shared cache won't help as my problem is the file flush operations at each
COMMIT, not the reading part. My original test was done in a single-threaded
program and it clearly shows the timing issue is with FileFlushBuffers.
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
The problem with that approach is that SQLite doesn't support nested
transactions. And I do have transactions which sometimes have to be rolled
back. Oh and there are multiple threads involved. I don't think it's really
good to start a transaction in one thread, add a few more from several other
Thanks!
-Original Message-
From: jphillip [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 19, 2006 4:24 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Is there a method for doing bulk insertion?
issue .help
look for .separator
example for a csv file with colon(:) separators
I DO need Durability, so I don't want to drop that. In fact, I need and want
normal transactional updates - just not immediately flushed to disk. I've
looked at the source and know there is no simple compile option for what I
want. My question was more like: Anybody already done this? (So I don't
issue .help
look for .separator
example for a csv file with colon(:) separators
issue .separator ':'
use an editor to change the existing separator character(s) to the
character you want to use.
On Tue, 19 Dec 2006, Anderson, James H (IT) wrote:
> So I can assume that there's no way to
Can anyone send me the code of C++ API for
SQLite3.3.8.
Thanks
Rashmi
--- Cory Nelson <[EMAIL PROTECTED]> wrote:
> On 12/15/06, Rashmi Hiremath
> <[EMAIL PROTECTED]> wrote:
> > Hi
> >
> > I would like to know wheather SQlite 3.3.8
> supports
> > internationalization.
>
> It will store UTF-8 or
Hi Jeff,
I'm not a Tcl user. I use C# and Robert Simpson's SQLite ADO.NET 2.0
provider to access SQLite databases.
SQLite allows you to define both scalar and aggregate user defined
functions. I think the way to approach your issue is to define a scalar user
defined function. I don't know how
Thanks!
-Original Message-
From: Jeff Godfrey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 19, 2006 4:01 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is there a method for doing bulk insertion?
Take a look at the ".separator" command. It seems to be what you
need...
Take a look at the ".separator" command. It seems to be what you
need...
Jeff
- Original Message -
From: "Anderson, James H (IT)" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, December 19, 2006 2:52 PM
Subject: RE: [sqlite] Is there a method for doing bulk
So I can assume that there's no way to use a delimiter other than a
comma to import a CSV file?
-Original Message-
From: jphillip [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 19, 2006 3:47 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Is there a method for doing bulk
.help pretty well sums it up.
On Tue, 19 Dec 2006, Anderson, James H (IT) wrote:
> How do I find doc on .import?
>
> Is there a way to specify the delimiter for the CSV file?
>
> Thanks,
>
> jim
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent:
Hi All,
New to SQLite, so bear with me... ;^)
I'm trying to migrate an MS-Access database over to SQLite. I have a VIEW
created from a SELECT statement that uses the mathematical "power" operator
("^") for both "square root" and "squared" operations. It seems that SQLite
doesn't support the
Hi,
I know that SQLite was written in C and I'm sure it's possible to port
it for Symbian OS. But I wonder - maybe there is already (ready to use
)any SQLite library for Symbian OS? It's really importent for to get information
about SQLite and Symbian - thanks in advance for any answers.
RGDS,
How do I find doc on .import?
Is there a way to specify the delimiter for the CSV file?
Thanks,
jim
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, December 18, 2006 9:12 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is there a method for
On Tue, 19 Dec 2006 13:52:19 -0500, you wrote:
>I've started to use SQLite and it works fine - except for performance. The
>application gets requests (possibly from many users) and does a few
>transactions on the database. (eg. create a context for the request; later
>it may be updated and when
Laszlo Elteto wrote:
For this particular application it would NOT be a problem to lose like 2-5
seconds of transactions. I wonder if it is possible to tell SQLite to "hold
off" the transactions, ACCUMMULATE them until a certain time (or if cache
memory is exhausted - which is not yet the case as
Laszlo Elteto <[EMAIL PROTECTED]> wrote:
> I've started to use SQLite and it works fine - except for performance. The
> application gets requests (possibly from many users) and does a few
> transactions on the database. (eg. create a context for the request; later
> it may be updated and when the
Richard,
Thanks for your reply.
I have tried CREATE INDEX IX_Post ON Post(CategoryID) and I have got the
same results. I did it before posting my first post :-), I guessed integer
primary key field is in every index, but not sure.
Regards:
Jesús López
-Mensaje original-
De: [EMAIL
Dennis,
Thanks for your reply.
Sorry for the typo, I wrote it directly on Outlook and I did not check it.
I will fill a bug report (a ticket)
Regards:
Jesús López
-Mensaje original-
De: Dennis Cote [mailto:[EMAIL PROTECTED]
Enviado el: martes, 19 de diciembre de 2006 16:30
Para:
I've started to use SQLite and it works fine - except for performance. The
application gets requests (possibly from many users) and does a few
transactions on the database. (eg. create a context for the request; later
it may be updated and when the user releases the record is deleted.)
I tried
[EMAIL PROTECTED] wrote:
In SQLite, every index has the INTEGER PRIMARY KEY as an implied
final column. So an index on
Post(CatagoryID, PostID)
Is really an index like this:
Post(CategoryID, PostID, PostID)
In other words, the extra PostID column is redundant. If you
omit it all
Dennis Cote <[EMAIL PROTECTED]> wrote:
> Jesús López wrote:
> > Given the table:
> >
> > CREATE TABLE Posts (
> > PostID INTEGER PRIMARY KEY,
> > CategoryID INT NOT NULL
> > )
> >
> > And the index:
> >
> > CREATE UNIQUE INDEX IX_Posts (CategoryID, PostID)
> >
>
> Your create index
Jesús López wrote:
Given the table:
CREATE TABLE Posts (
PostID INTEGER PRIMARY KEY,
CategoryID INT NOT NULL
)
And the index:
CREATE UNIQUE INDEX IX_Posts (CategoryID, PostID)
The query:
SELECT CategoryID, PostID
FROM Posts
ORDER BY CategoryID
LIMIT 10
Takes about 15 ms to
Thanks.
-Original Message-
From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
Sent: Monday, December 18, 2006 8:32 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is there a method for doing bulk insertion?
On 12/18/06, Anderson, James H (IT) <[EMAIL PROTECTED]>
wrote:
> I was hoping
Guy Hindell wrote:
Guy Hindell wrote:
[EMAIL PROTECTED] wrote:
Guy Hindell <[EMAIL PROTECTED]> wrote:
I would like to use sqlite (v3.3.8) on a linux box (fedora core 5)
to read/write a database file in a directory which is actually on a
windows share mounted via samba/cifs. I can open the
Guy Hindell wrote:
[EMAIL PROTECTED] wrote:
Guy Hindell <[EMAIL PROTECTED]> wrote:
I would like to use sqlite (v3.3.8) on a linux box (fedora core 5)
to read/write a database file in a directory which is actually on a
windows share mounted via samba/cifs. I can open the file, and read
from
33 matches
Mail list logo