Hi,
I've read many things, some conflicting, about concurrent users on a Sqlite
database.
The feeling I get is that Sqlite is good for a standalone desktop database, but
should not be used in a concurrent user situation (like a website with many
users).
Is there a definitive answer?
thanks!
_
:( That's pretty sad -- some people need to go out and get real lives or
something...
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Monday, August 16, 2004 8:36 AM
To: [EMAIL PROTECTED]
Subject: [sqlite] Re: www.sqlite.org broken?
Christian Smith wrote:
> Rich
Question: Does or will 3.0 offer support for the ALTER TABLE command?
Shawn
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 8:33 AM
To: [EMAIL PROTECTED]
Subject: [sqlite] Version 3.0.0 ALPHA now available
Version 3.0.0 (alpha) of SQLite
Is there a reason you don't want to use a begin transaction, then insert
everything, then end the transaction? It is extremely efficient to do this.
Shawn
-Original Message-
From: Xuer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 14, 2004 11:56 PM
To: [EMAIL PROTECTED]
Subject: [sqlite
mplement sqlite yet, but i bet they did and else
they probably will do so soon.
just my 2 cents..
rene
Op vrijdag, juni 4. 2004 17:50:01 schreef "Shawn Anderson"
<[EMAIL PROTECTED]> :
> Yes, but it you right the component around TdataSet you get to use all
> of the great
Yes, but it you right the component around TdataSet you get to use all of
the great database functionality that Borland's VCL offers, as well as tons
of 3rd party components.
Shawn
-Original Message-
From: Jay Macaulay [mailto:[EMAIL PROTECTED]
Sent: Friday, June 04, 2004 11:34 AM
To: [
Question: Why not use the totally free version of C++Builder and just
create a VCL component for SQLite -- the VCL component can then be used from
either C++ Builder or Delphi.
Shawn
-Original Message-
From: Fred Williams [mailto:[EMAIL PROTECTED]
Sent: Friday, June 04, 2004 10:18 AM
To
I would be interested in the PDF file.
Shawn
-Original Message-
From: Stéphane Rivière [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 10:22 AM
To: D. Richard Hipp
Cc: [EMAIL PROTECTED]
Subject: Re: [sqlite] Newbie questions
> place? What doe a descending index give you that you
about the HAVING clause, so I will give that a try.
Thanks again :)
Shawn
-Original Message-
From: Darren Duncan [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 12:40 AM
To: [EMAIL PROTECTED]; Shawn Anderson
Subject: Re: [sqlite] Question about expected query result??
At 11:05 PM
I have the following table/data
ClientIPClientDomain
63.149.28.33mail.serverlocation.com
63.149.28.33mail.serverlocation.com
63.149.28.33mail.serverlocation.com
63.149.28.33mail.serverlocation.com
211.141.67.7xmailserver.org
211.141.67.7xmailserver.org
211.1
Question about support for new intrinsic types, any chance you can add
support for DATETIME as well? I mean I really like the date time options
available at the moment, but it would be nice if we could do SQL standard
queries on datetime columns.
Shawn
--
I agree, I would like to see compatibility with results from other SQL
engines...
Shawn
-Original Message-
From: Keith Herold [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 8:38 PM
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] SQLite version 3 design question: '500'=500?
In MS
On draw back to these is that they are pretty much non portable to other
RDBMS. But they look good...
Shawn
-Original Message-
From: Kurt Welgehausen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 11, 2004 11:50 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Sort by TIMESTAMP?
> May try
7;) but I might be wrong.
Lloyd
- Original Message -
From: "Shawn Anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 3:33 PM
Subject: RE: [sqlite] Sort by TIMESTAMP?
> You right, I should have tried it :)
>
> A couple of oth
ED]
Sent: Tuesday, May 11, 2004 10:23 AM
To: Forum SQLite
Subject: Re: [sqlite] Sort by TIMESTAMP?
On May 11, 2004, at 7:17 AM, Shawn Anderson wrote:
> Is it possible to do an ORDER BY on a col marked as TIMESTAMP and have
> the order come back sorted correctly?
>
Su
Is it possible to do an ORDER BY on a col marked as TIMESTAMP and have the
order come back sorted correctly?
Shawn
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Howdy,
I was wondering if anyone had any ideas on either of these options?
Basically I have about 300 mb of data that I want to insert in a database
using SQLite, and I am trying to find the most efficient way of doing it.
My thoughts are either to find a fast bulk insert method, or maybe using an
17 matches
Mail list logo