It would be nice if sqlite stored a change count in the database that was
easily accessible.
CREATE TABLE counter_table(n INTEGER);
INSERT INTO counter_table VALUES(0);
CREATE TRIGGER counter_trigger_insert
AFTER INSERT ON yourtable
FOR EACH ROW BEGIN
UPDATE counter_table SET n = n + 1;
END;
ok I got it figured out. I had to compile sqlite3>> ./configure
--disable-tcl
On 3/4/07, aaron smith <[EMAIL PROTECTED]> wrote:
Ultimately what I am trying to do is install the ruby wiki, Instiki. In
doing some research I found that rubys sqlite-lib wasn't compatible with
sqlite3. So i remove
[EMAIL PROTECTED] writes:
>> I also printed out and signed the copyright papers and mailed them in.
> Your copyright release and your patches arrived in today's post.
> The postmark is smeared somewhat but it does appear to say
> "2? DEC 2006" (where the ? is illegible.)
> So from Oakland, CA
- Original Message -
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
To: "SQLite"
Sent: Sunday, March 04, 2007 12:59 AM
Subject: [sqlite] Re: Newbie question about LIKE and ESCAPE
> For example, this query retrieves all rows where someField contains '%'
> character:
>
> SELECT * FROM someTab
I'm developing an SQlite database administration tool (web site is
there : http://litemanager.tuxamily.org) for Linux using Mono and GTK#.
If you want test it use svn version the last commit content all
features of next release (Available only in french for the moment if
someone can help me for tra
I'm developing an SQlite database administration tool (web site is
there : http://litemanager.tuxamily.org) for Linux using Mono and GTK#.
If you want test it use svn version the last commit content all
features of next release (Available only in french for the moment if
someone can help me for tra
What sort of SQL statements will benefit most from this change?
Large delete operations or vacuum? What about query speed?
Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games
Here are SQL statements that will generate a 24 MB database
of US baseball information:
http://danial.org/sqlite/lampsig/baseball.sql.bz2
The original data came from
http://baseball1.info/statistics/lahman52_csv.zip
and the schema is explained in http://baseball1.com/statistics/readme52.txt
On 3
lordphoenix wrote:
I'm developing an SQlite database administration tool (web site is
there : http://litemanager.tuxamily.org)
this link doesn't seem to work :-(
cheers,
Stef Mientki
-
To unsubscribe, send email to
Le Sun, 04 Mar 2007 22:01:30 +0100,
Stef Mientki <[EMAIL PROTECTED]> a écrit :
>
>
> lordphoenix wrote:
> > I'm developing an SQlite database administration tool (web site is
> > there : http://litemanager.tuxamily.org)
> this link doesn't seem to work :-(
Sorry for mistake here is the good one
Thanks! That answers my question perfectly.
Best,
Neil
On 3/3/07, Griggs, Donald <[EMAIL PROTECTED]> wrote:
Hi Neil,
Re: " I would like to perform regular expression queries interactively,
i.e. from the sqlite> prompt"I
I'm not sure what operating system you're using, but there are sqlite GUI
Stef Mientki wrote:
lordphoenix wrote:
I'm developing an SQlite database administration tool (web site is
there : http://litemanager.tuxamily.org)
this link doesn't seem to work :-(
There seems to have been a typo.
Try: http://litemanager.tuxfamily.org/
Gerry (who just made a lucky gues
Hi,
I'm wondering if there's any free addon for sqlite which would add a
transparent encryption layer to the database... can anyone provide any
information?
Thanks!
--
...it's only a matter of time...
lordphoenix wrote:
Le Sun, 04 Mar 2007 22:01:30 +0100,
Stef Mientki <[EMAIL PROTECTED]> a écrit :
lordphoenix wrote:
I'm developing an SQlite database administration tool (web site is
there : http://litemanager.tuxamily.org)
this link doesn't seem to work :-(
Sorry for
Hi all,
I have a database containing a following data:
Table Mieszalnia:
CREATE TABLE [Mieszalnia11]
(
[IdWpis] integer NOT NULL PRIMARY KEY AUTOINCREMENT ,
[IdMat] integer,
[Data] integer,
[Partia] varchar (10),
[Kontener] varchar (10),
[Uklad] va
woj <[EMAIL PROTECTED]> wrote:
Now, when I run a query:
SELECT Mieszalnia.IdMat, Mieszalnia.Partia, Mieszalnia.Kont,
Mieszalnia.Uk, Max(Mieszalnia.Data) FROM Mieszalnia;
I always get:
IdMat Partia KontUk Data
6 3 3 sl1 1172135769
In this result there is indeed max from Data f
Hi all,
sorry previous mail was not really readable...
I have a database containing a following data:
Table Mieszalnia:
CREATE TABLE [Mieszalnia11]
(
[IdWpis] integer NOT NULL PRIMARY KEY AUTOINCREMENT ,
[IdMat] integer,
[Data] integer,
[Partia] varchar (10),
Joe Wilson <[EMAIL PROTECTED]> wrote:
> What sort of SQL statements will benefit most from this change?
SQL statements that run on embedded platforms that lack a
OS filesystem cache.
--
D. Richard Hipp <[EMAIL PROTECTED]>
--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> woj <[EMAIL PROTECTED]> wrote:
> > Now, when I run a query:
> > SELECT Mieszalnia.IdMat, Mieszalnia.Partia, Mieszalnia.Kont,
> > Mieszalnia.Uk, Max(Mieszalnia.Data) FROM Mieszalnia;
> > I always get:
> > IdMat Partia KontUk Data
> > 6
19 matches
Mail list logo