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
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
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 there
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
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 statement is invalid as posted,
[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
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
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:
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
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 user
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
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 the
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
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,
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 ^
.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: Monday,
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
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: sqlite-users@sqlite.org
Sent: Tuesday, December 19, 2006 2:52 PM
Subject: RE: [sqlite] Is there a method for doing bulk insertion?
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...
Jeff
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
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 UTF-16, but
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 use
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
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
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
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]
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
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
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 PROTECTED]
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]
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)
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
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 exhausted -
33 matches
Mail list logo