Re: [sqlite] Re: sqlite3_total_changes() and multiple connections

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;

Re: [sqlite] sqlite3 shared object question.

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

[sqlite] Re: developers mailing list, ignored patches

[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

Re: [sqlite] Re: Newbie question about LIKE and ESCAPE

- 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

[sqlite] I Need database fot some test

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

[sqlite] I Need database for some test

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

[sqlite] question regarding Check-in [3671]: Changes to the btree and pager that reduce the amount of I/O when dealing with the freelist.

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

Re: [sqlite] I Need database for some test

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

Re: [sqlite] I Need database for some test

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

Re: [sqlite] I Need database for some test

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

Re: [sqlite] Question about regexp function

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

Re: [sqlite] I Need database for some test

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

[sqlite] Database security

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...

Re: [sqlite] I Need database for some test

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

[sqlite] Why it does not work properly?

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

[sqlite] Re: Why it does not work properly?

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

[sqlite] Why it does not work properly?-now written correctly...

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),

Re: [sqlite] question regarding Check-in [3671]: Changes to the btree and pager that reduce the amount of I/O when dealing with the freelist.

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]>

Re: [sqlite] Re: Why it does not work properly?

--- 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