O well, read-only?
Then exclusive as well :)
- Original Message -
From: "Walter Meerschaert" <[EMAIL PROTECTED]>
To:
Sent: Sunday, August 21, 2005 2:04 AM
Subject: Re: [sqlite] Why can i open a textfile?
I agree, since that makes error/exception handling
D. Richard Hipp wrote:
I am running on linux, and I will need this to scale to at least
200,000 rows
If you upgrade to the vary latest code in CVS (version 3.2.2+)
and you create an index like this:
CREATE INDEX idx ON table(parent_name, name);
Then the query above should be very
Hi,
There was some recent discussion about timestamp triggers, something I
have been trying to get working on my own. Specifically, I have two
fields, insert_ts and last_upd_ts, which I would like to be the insert
time and last update time, respectively. However, when I try to write
a trigger
On Aug 21, 2005, at 9:20 AM, <[EMAIL PROTECTED]> wrote:
Hi,
There was some recent discussion about timestamp triggers, something I
have been trying to get working on my own. Specifically, I have two
fields, insert_ts and last_upd_ts, which I would like to be the insert
time and last update
> can someone explain to me why folks try to accomplish the above using
> TRIGGERs when the insert time can be set so easily by simply defining
> the column as
>
> insert_ts DATETIME DEFAULT CURRENT_TIMESTAMP
>
> and last_upd_ts (or its equivalent) can set in the application logic
> and
On Aug 21, 2005, at 9:55 AM, <[EMAIL PROTECTED]> wrote:
can someone explain to me why folks try to accomplish the above using
TRIGGERs when the insert time can be set so easily by simply defining
the column as
insert_ts DATETIME DEFAULT CURRENT_TIMESTAMP
and last_upd_ts (or its
On Sun, 2005-08-21 at 10:20 -0400, [EMAIL PROTECTED] wrote:
> There was some recent discussion about timestamp triggers, something I
> have been trying to get working on my own. Specifically, I have two
> fields, insert_ts and last_upd_ts, which I would like to be the insert
> time and last
Hello,
I'm pleased to announce the new beta of SQLite Analyzer
- New "Data Editor" allow to use "WHERE..., LIMIT.. OFFSET"
clause.
- Ability to view BLOB column as picture and as text.
- Ability to load BLOB data from file or save to file and edit BLOB
data.
You can
> Both insert_ts and last_upd_ts get updated when I try this.
> What version of SQLite are you using? What platform? What
> language binding?
I'm running sqlite 3.2.2 on Win XP, and I'm running things inside
sqlite itself, not another language.
Thanks for the help!
Bill
Hello,
I am trying to figure out a way to return
the actual or approximate table size in a
database.
Basically, in my application a table relates
to an object and I need to calculate the
approximate size of an object.
There is the sqlite3_column_bytes(), but I
understand that that function
On Sun, 2005-08-21 at 13:43 -0400, Kervin L. Pierre wrote:
> Hello,
>
> I am trying to figure out a way to return
> the actual or approximate table size in a
> database.
>
> Basically, in my application a table relates
> to an object and I need to calculate the
> approximate size of an object.
>
D. Richard Hipp wrote:
Are you trying to estimate the size of a table,
or a single row in that table? Your words say
the table but the context suggest you really
want the size of a row.
I need the table. But I thought if I could
have the row, calculating the total for the
table wouldn't
Version 3.2.3 of SQLite is now available on the website
http://www.sqlite.org/
In addition to fixing a lot of minor bugs, this release
adds a number of important new enhancements. Most of
the enhancements are centered around the much-improved
query optimizer, but there are some unrelated
On Sun, 21 Aug 2005, Puneet Kishor wrote:
>
> On Aug 21, 2005, at 9:20 AM, <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > There was some recent discussion about timestamp triggers, something I
> > have been trying to get working on my own. Specifically, I have two
> > fields, insert_ts and
On Sun, 21 Aug 2005, Mark de Vries wrote:
> > > I have tried two versions of the trigger:
> > >
> > > CREATE TRIGGER task_list_1
> > > AFTER INSERT ON task_list
> > > BEGIN
> > > UPDATE task_list
> > > SET insert_ts = datetime('now','localtime'),
> > >
D. Richard Hipp wrote:
Version 3.2.3 of SQLite is now available on the website
http://www.sqlite.org/
In addition to fixing a lot of minor bugs, this release
adds a number of important new enhancements. Most of
the enhancements are centered around the much-improved
query optimizer, but there
Khamis Abuelkomboz wrote:
D. Richard Hipp wrote:
Version 3.2.3 of SQLite is now available on the website
http://www.sqlite.org/
In addition to fixing a lot of minor bugs, this release
adds a number of important new enhancements. Most of
the enhancements are centered around the much-improved
>>In order to implement the ORDER BY clause, SQLite reads the entire result set
>>into memory and sorts it there. When your result set gets very large (13000
>>rows) and each row uses in excess of 1KB or memory,this is apparently causing
>>your machine to thrash.
If an index exists on the
On Mon, Aug 22, 2005 at 08:44:07AM +0800, Damian Slee wrote:
> >>In order to implement the ORDER BY clause, SQLite reads the entire result
> >>set into memory and sorts it there. When your result set gets very large
> >>(13000 rows) and each row uses in excess of 1KB or memory,this is
>
19 matches
Mail list logo