> Don't know about ALTER TABLE, but having native corelated subqueries
> support would save on code and possibly speed up getting at
> the end result greatly.
With other products, I've actually found that using temporary tables can
yield definite performance increases that far outweigh the develo
Don't know about ALTER TABLE, but having native corelated subqueries
support would save on code and possibly speed up getting at the end result
greatly.
Vijay
- Forwarded by Vijay S Tenneti/Europe/Group 1 Software Europe Ltd on
21/04/2004 18:46 -
Forgive my ignorance, I have yet to use a transaction and therefore can you
give me an example.
Lloyd
- Original Message -
From: "Christian Smith" <[EMAIL PROTECTED]>
To: "Lloyd thomas" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 21, 2004 3:27 PM
Subject: Re: [sqlit
My guess is, since it would appear that Richard is a member of a facility of
a higher education institute, and somehow involved in computer education, I
would speculate there are "students" involved in SQLite coding. Why else
would a "Good to Excellent" C programmer have such an elaborate pre-rel
On Apr 21, 2004, at 8:37 AM, [EMAIL PROTECTED] wrote:
Puneet Kishor wrote:
my guess is because it can be done other ways (see the docs on this
specifically), and the idea is to keep SQLite as simple as possible.
The
more "conveniences" that are added to it, the more complicated it will
become.
On Tue, 20 Apr 2004, Lloyd thomas wrote:
>Which is the best way to backup rows which meet a certain date criteria?
>ie WHERE data is <= '2003-11-20'.
>Would I need to select and save the data to a temporary table and then DUMP the temp
>table.
>
Just begin a transaction to get a snapshot of the
On Wed, 21 Apr 2004 [EMAIL PROTECTED] wrote:
>
>Puneet Kishor wrote:
>
>> my guess is because it can be done other ways (see the docs on this
>> specifically), and the idea is to keep SQLite as simple as possible. The
>> more "conveniences" that are added to it, the more complicated it will
>> bec
> > I'm new to sqlite but as far as I can tell it does not support ALTER
TABLE
> > command. I could find that useful in future versions.
>
> That's right.
> ALTER TABLE would be very helpful.
> Are there any reasons it is not implemented yet ?
What do you mean by "ALTER TABLE"? The ability to add
Puneet Kishor wrote:
> my guess is because it can be done other ways (see the docs on this
> specifically), and the idea is to keep SQLite as simple as possible. The
> more "conveniences" that are added to it, the more complicated it will
> become.
> Usually, once the database is set, there i
9 matches
Mail list logo