Re: [sqlite] some questions about sqlite

[Pavel Ivanov]

> thanks a lot，
> but about the second question，I write java code，and find if the connection 
> exceeds 17990，then will throws exception

This probably happened because your OS restricts number of open file
descriptors or something like that.

Pavel


On Sat, Sep 1, 2012 at 7:52 PM,   wrote:
> thanks a lot，
> but about the second question，I write java code，and find if the connection 
> exceeds 17990，then will throws exception
> SQLite.Exception: unknown error in open
> at SQLite.Database._open4(Native Method)
> at SQLite.Database.open(Database.java:37)
> at SQLite.MyDay.main(MyDay.java:20)
> Exception in thread "main" java.lang.OutOfMemoryError: unable to get SQLite 
> handle
> at SQLite.Database._open4(Native Method)
> at SQLite.Database.open(Database.java:37)
> at SQLite.MyDay.main(MyDay.java:20)
>
> the source java code:
> public static void main(String[] args) {
> // TODO Auto-generated method stub
> int count=0;
>
> while(count<=17990){
> Database db = new Database();
>
> try {
> // open connection,but not close
> db.open("c:\\my1.db", 0666);
> count++;
> db.interrupt();
> db.busy_timeout(1000);
> db.busy_handler(null);
>
> } catch (Exception e) {
> e.printStackTrace();
> }
> }
>
> System.out.println(count);
> }
>
>
>> -Original E-mail-
>> From: "J Decker" 
>> Sent Time: 2012-9-2 10:37:04
>> To: "General Discussion of SQLite Database" 
>> Cc:
>> Subject: Re: [sqlite] some questions about sqlite
>>
>> On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin  wrote:
>> >
>> > On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote:
>> >
>> >> 1、Do the sqlite support job like oracle or sqlserver,such as
>> >>variable job1 number;
>> >>begin
>> >>sys.dbms_job.submit(job => :job,
>> >>what => 'prc_g_test;',
>> >> next_date => to_date('22-10-2008 10:06:41', 
>> >> 'dd-mm- hh24:mi:ss'),
>> >> interval => 
>> >> 'sysdate+1/1440');--每天1440分钟，即一分钟运行test过程一次
>> >> commit;
>> >>end;
>> >
>> > No.
>> >
>> >> 2、how many user connections the sqlite can handler
>> >
>> > There is no limit in SQLite for connections.
>>
>> It is not advised to have multiple processes connect to same file. ..
>> but in-process probably no limit of connections.
>>
>> >
>> > Simon.
>> > ___
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] some questions about sqlite

[Jay A. Kreibich]

On Sat, Sep 01, 2012 at 07:37:04PM -0700, J Decker scratched on the wall:
> On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin  wrote:
> > On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote:

> >> 2??how many user connections the sqlite can handler
> >
> > There is no limit in SQLite for connections.
> 
> It is not advised to have multiple processes connect to same file. ..
> but in-process probably no limit of connections.

  I'm not sure where this idea comes from, as it is perfectly
  acceptable to have multiple processes accessing the same database
  file.

  SQLite makes very little distinction between different connections
  from the same process and different connections from different
  processes, so there isn't any significant limit that applies to one
  situation that doesn't apply to the other.

  Concurrency is always an issue, and you don't want hundreds of
  connections banging on the same file, but that's true no matter if
  the connections come from the same process or not.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] some questions about sqlite

[shuifeng]

thanks a lot，
but about the second question，I write java code，and find if the connection 
exceeds 17990，then will throws exception
SQLite.Exception: unknown error in open
at SQLite.Database._open4(Native Method)
at SQLite.Database.open(Database.java:37)
at SQLite.MyDay.main(MyDay.java:20)
Exception in thread "main" java.lang.OutOfMemoryError: unable to get SQLite 
handle
at SQLite.Database._open4(Native Method)
at SQLite.Database.open(Database.java:37)
at SQLite.MyDay.main(MyDay.java:20)

the source java code:
public static void main(String[] args) {
// TODO Auto-generated method stub
int count=0;

while(count<=17990){
Database db = new Database();

try {
// open connection,but not close
db.open("c:\\my1.db", 0666);
count++;
db.interrupt();
db.busy_timeout(1000);
db.busy_handler(null);

} catch (Exception e) {
e.printStackTrace();
}
}

System.out.println(count);
}


> -Original E-mail-
> From: "J Decker" 
> Sent Time: 2012-9-2 10:37:04
> To: "General Discussion of SQLite Database" 
> Cc: 
> Subject: Re: [sqlite] some questions about sqlite
> 
> On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin  wrote:
> >
> > On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote:
> >
> >> 1、Do the sqlite support job like oracle or sqlserver,such as
> >>variable job1 number;
> >>begin
> >>sys.dbms_job.submit(job => :job,
> >>what => 'prc_g_test;',
> >> next_date => to_date('22-10-2008 10:06:41', 
> >> 'dd-mm- hh24:mi:ss'),
> >> interval => 
> >> 'sysdate+1/1440');--每天1440分钟，即一分钟运行test过程一次
> >> commit;
> >>end;
> >
> > No.
> >
> >> 2、how many user connections the sqlite can handler
> >
> > There is no limit in SQLite for connections.
> 
> It is not advised to have multiple processes connect to same file. ..
> but in-process probably no limit of connections.
> 
> >
> > Simon.
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] some questions about sqlite

[J Decker]

On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin  wrote:
>
> On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote:
>
>> 1、Do the sqlite support job like oracle or sqlserver,such as
>>variable job1 number;
>>begin
>>sys.dbms_job.submit(job => :job,
>>what => 'prc_g_test;',
>> next_date => to_date('22-10-2008 10:06:41', 
>> 'dd-mm- hh24:mi:ss'),
>> interval => 
>> 'sysdate+1/1440');--每天1440分钟，即一分钟运行test过程一次
>> commit;
>>end;
>
> No.
>
>> 2、how many user connections the sqlite can handler
>
> There is no limit in SQLite for connections.

It is not advised to have multiple processes connect to same file. ..
but in-process probably no limit of connections.

>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] some questions about sqlite

[Simon Slavin]

On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote:

> 1、Do the sqlite support job like oracle or sqlserver,such as
>variable job1 number; 
>begin 
>sys.dbms_job.submit(job => :job, 
>what => 'prc_g_test;', 
> next_date => to_date('22-10-2008 10:06:41', 
> 'dd-mm- hh24:mi:ss'), 
> interval => 
> 'sysdate+1/1440');--每天1440分钟，即一分钟运行test过程一次 
> commit; 
>end; 

No.

> 2、how many user connections the sqlite can handler

There is no limit in SQLite for connections.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database size

[Ted Rolle, Jr.]

This is so good to hear!  The advances in database theory and practice
have put the old ideas to rest.

Hooray for today!

Ted

On 09/01/2012 07:08 PM, Richard Hipp wrote:
> On Sat, Sep 1, 2012 at 6:34 PM, Ted Rolle, Jr.  wrote:
>
>> Back in the olden days we predicted a database's storage to be about 5
>> times the size of the data.
>> By 'olden' I mean IBM's IMS, VSAM, DB2. ..., 70s, 80s.
>> I hope this is still not the case...
>>
> A lot depends on your data, of course.
>
> But the Fossil  repository (an SQLite database)
> that holds the complete 12.5 year revision history of SQLite is about 69.4%
> efficient at holding data overall (meaning that the content held is about
> 69.4% of the total database size, and about 82.8% efficient if you exclude
> indices.  That is a lot better than your 20% rule-of-thumb.  On the other
> hand, you can make the overall storage efficiency as small as you want by
> creating enough useless indices...
>
> You can measure the storage efficiency of your on SQLite databases using
> sqlite3_analyzer.exe binary available on the download
> page
> .
>
>
>> Ted
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database size

[Ted Rolle, Jr.]

This is so true!

Remember Y2K?  That was caused by a three-letter blue company.  They
wanted to save 1 (one!) byte by not storing the century in critical
operating system fields.  The comments were (1960s) "Well, we won't be
around to fix it...wink, wink, nudge, nudge."  I was.  Most companies
got through it with few problems --- a tribute to the programming staff.

Ted

On 09/01/2012 07:51 PM, Simon Slavin wrote:
> On 1 Sep 2012, at 11:34pm, "Ted Rolle, Jr."  wrote:
>
>> Back in the olden days we predicted a database's storage to be about 5
>> times the size of the data.
>> By 'olden' I mean IBM's IMS, VSAM, DB2. ..., 70s, 80s.
> Back in the old days you had 72 or 80 columns to a punched card, and any 
> columns you didn't use were wasted.  You could double your database 
> capacity/speed/cost by saving one bit per record.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] some questions about sqlite

[shuifeng]

1、Do the sqlite support job like oracle or sqlserver,such as
variable job1 number; 
begin 
sys.dbms_job.submit(job => :job, 
what => 'prc_g_test;', 
 next_date => to_date('22-10-2008 10:06:41', 
'dd-mm- hh24:mi:ss'), 
 interval => 
'sysdate+1/1440');--每天1440分钟，即一分钟运行test过程一次 
 commit; 
end; 

2、how many user connections the sqlite can handler
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database size

[Simon Slavin]

On 1 Sep 2012, at 11:34pm, "Ted Rolle, Jr."  wrote:

> Back in the olden days we predicted a database's storage to be about 5
> times the size of the data.
> By 'olden' I mean IBM's IMS, VSAM, DB2. ..., 70s, 80s.

Back in the old days you had 72 or 80 columns to a punched card, and any 
columns you didn't use were wasted.  You could double your database 
capacity/speed/cost by saving one bit per record.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database size

[Richard Hipp]

On Sat, Sep 1, 2012 at 6:34 PM, Ted Rolle, Jr.  wrote:

> Back in the olden days we predicted a database's storage to be about 5
> times the size of the data.
> By 'olden' I mean IBM's IMS, VSAM, DB2. ..., 70s, 80s.
> I hope this is still not the case...
>

A lot depends on your data, of course.

But the Fossil  repository (an SQLite database)
that holds the complete 12.5 year revision history of SQLite is about 69.4%
efficient at holding data overall (meaning that the content held is about
69.4% of the total database size, and about 82.8% efficient if you exclude
indices.  That is a lot better than your 20% rule-of-thumb.  On the other
hand, you can make the overall storage efficiency as small as you want by
creating enough useless indices...

You can measure the storage efficiency of your on SQLite databases using
sqlite3_analyzer.exe binary available on the download
page
.


>
> Ted
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How do you load a ".csv" and skip the first line?

[Ted Rolle, Jr.]

Text editor to remove the offending line(s)?
This way you can see what you've removed.
The other solutions (tail, less, more) would work better for LARGE files.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Database size

[Ted Rolle, Jr.]

Back in the olden days we predicted a database's storage to be about 5
times the size of the data.
By 'olden' I mean IBM's IMS, VSAM, DB2. ..., 70s, 80s.
I hope this is still not the case...

Ted
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How do you load a ".csv" and skip the first line?

[Udi Karni]

If all else fails - after the import issue  DELETE FROM XYZ WHERE ID = 'id'
;

But - yes - adding the "skip=y" and  "load=x" parameters  (skip the first y
rows in the .csv file, and stop after loading x rows) - to the .import
utility would be most desirable.

On Sat, Sep 1, 2012 at 12:31 PM, Petite Abeille wrote:

>
> On Sep 1, 2012, at 9:19 PM, joe.fis...@tanguaylab.com <
> joe.fis...@tanguaylab.com> wrote:
>
> > Is there some way to load a ".csv" file into a SQLite database table
> when the first row (record) of the file contains headers?
>
> On *nix, any of tail +2, more +2, etc would do.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How do you load a ".csv" and skip the first line?

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 01/09/12 12:19, joe.fis...@tanguaylab.com wrote:
> Is there some way to load a ".csv" file into a SQLite database table
> when the first row (record) of the file contains headers?

You may want to consider using the APSW shell.  It has a .autoimport
command that automatically figures out separators, what fields are
text/date/numeric etc.  You can then use the resulting database with
whatever you use for SQLite.

   http://apidoc.apsw.googlecode.com/hg/shell.html

Example usage (a few .dump lines trimmed) against your test csv:

  $ python -c "import apsw;apsw.main()" test.db
  SQLite version 3.7.13 (APSW 3.7.13-r1)
  Enter ".help" for instructions
  Enter SQL statements terminated with a ";"
  sqlite> .autoimport test.csv
  Detected Format excel  Columns 4  Rows 4
  Auto-import into table "test" complete
  sqlite> .dump test
  CREATE TABLE test(id, barcode_id, light, bpm);
  INSERT INTO test VALUES(1,'02455',1,180.2);
  INSERT INTO test VALUES(2,'02455',1,168.3);
  INSERT INTO test VALUES(3,'02455',1,189.4);

You'll note that it figured out barcode field was a string despite
consisting of only digits.  This is the .help for autoimport:

.autoimport FILENAME ?TABLE?  Imports filename creating a table and
  automatically working out separators and data
  types (alternative to .import command)

The import command requires that you precisely pre-setup the table and
schema, and set the data separators (eg commas or tabs).  In many cases
this information can be automatically deduced from the file contents which
is what this command does.  There must be at least two columns and two rows.

If the table is not specified then the basename of the file will be used.

Additionally the type of the contents of each column is also deduced - for
example if it is a number or date.  Empty values are turned into nulls.
Dates are normalized into -MM-DD format and DateTime are normalized
into ISO8601 format to allow easy sorting and searching.  4 digit years
must be used to detect dates.  US (swapped day and month) versus rest of
the world is also detected providing there is at least one value that
resolves the ambiguity.

Care is taken to ensure that columns looking like numbers are only treated
as numbers if they do not have unnecessary leading zeroes or plus signs.
This is to avoid treating phone numbers and similar number like strings as
integers.

This command can take quite some time on large files as they are effectively
imported twice.  The first time is to determine the format and the types for
each column while the second pass actually imports the data.

Roger

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAlBCclIACgkQmOOfHg372QQV2QCg3s6VpgCbvGG9xQqvQ1fSvBpj
OjkAn1afh25GTDpjPUYuHoJASmHdQ/3Z
=2S51
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How do you load a ".csv" and skip the first line?

[Petite Abeille]

On Sep 1, 2012, at 9:19 PM, joe.fis...@tanguaylab.com 
 wrote:

> Is there some way to load a ".csv" file into a SQLite database table when the 
> first row (record) of the file contains headers?

On *nix, any of tail +2, more +2, etc would do.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How do you load a ".csv" and skip the first line?

[joe.fis...@tanguaylab.com]

Is there some way to load a ".csv" file into a SQLite database table 
when the first row (record) of the file contains headers?


This does not work?
--
.separator ,
.import test.csv ld_assay

Here's my database / table:
CREATE TABLE [ld_assay] (
  [id] INTEGER PRIMARY KEY,
  [barcode_id] NCHAR(9),
  [light] BOOLEAN,
  [bpm] REAL);

Here's my "test.csv":
id,barcode_id,light,bpm
1,02455,1,180.2
2,02455,1,168.3
3,02455,1,189.4
--

This works (example from different program):
--
When R loads a ".csv" file it uses the [header = TRUE] flag to skip the 
first row of the file:
data.frame_ld_assay <- read.table("test.csv", header = TRUE, sep = ",", 
colClasses = c("integer", "character", "integer", "numeric"))


Most likely utilizing the "skip, integer: the number of lines of the 
data file to skip before beginning to read data." option.

--

Joe
Oregon State University




___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Compiling SQLite on VxWorks 6.3 (DKM)

[Udon Shaun]

Hi all.

Finally got Sqlite 3.7.13 working on VxWorks 6.3 in DKM.
Thanks for all the help.

Shaun
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Setting initial database size.

[Simon Slavin]

On 1 Sep 2012, at 3:46pm, Roger Binns  wrote:

> What tool did you use to work out that this is a problem?

Actually I've done it myself on a handsized device which didn't have good error 
testing.  It had an 8 Meg SD card and various other parts of the system would 
simply crash if they ran out of filespace.  So the problem was not to do with 
any weakness of SQLite, just that knowing that the SQLite database was always 
going to take up exactly the same amount of filespace reduced the number of 
growing/shrinking files I had to worry about.

I did it the simple way: writing dummy data until the filesize was 4 Meg, then 
deleting the dummy rows and not doing a VACUUM.  It worked fine.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Setting initial database size.

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 31/08/12 05:28, kjell.gunnars...@sungard.com wrote:
> Does somebody know if it's possible to set an initial database size
> when the database is created ?. (A large file doesn't have to be
> incremented in size when records are inserted).

You can use sqlite3_file_control.  See:

  http://www.sqlite.org/c3ref/c_fcntl_chunk_size.html

SQLITE_FCNTL_CHUNK_SIZE would be the most useful - set it to something you
have measured as useful to your data patterns and filesystems.

SQLITE_FCNTL_SIZE_HINT is implemented for the Unix (also used for Mac) and
Windows VFS.

What tool did you use to work out that this is a problem?

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAlBCH8QACgkQmOOfHg372QRBfACeNFKOniQ7ifSDmZMnLC0KTQbL
Gy4AoORHiFi7bCJInxAN0pjM+ethHoFO
=cDIX
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Setting initial database size.

[Mohit Sindhwani]

Hi Kjell,

On 31/8/2012 8:28 PM, kjell.gunnars...@sungard.com wrote:

Hi,

Does somebody know if it's possible to set an initial database size when the 
database is created ?.
(A large file doesn't have to be incremented in size when records are inserted).


I have never seen any thing that suggests that this can be done by 
design - generally, the database grows as we go along.  In practice, you 
could emulate this by creating your base schema, then creating a 
temporary table with some schema and inserting 10s of millions of 
records into it so that the database size grows.  Once it's got to a 
level that makes you happy, you can drop the table.  SQLite does not 
reduce the database size by itself till you do a "VACUUM;" - so, that 
initial size will be maintained and the previously allocated pages will 
be reused as you insert your live data.


Out of curiosity, what's the use case?

Best Regards,
Mohit.
1/9/2012 | 10:08 PM.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Setting initial database size.

[kjell.gunnarsson]

Hi,

Does somebody know if it's possible to set an initial database size when the 
database is created ?.
(A large file doesn't have to be incremented in size when records are inserted).

Rgds
Kjell Gunnarsson



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users