Re: [sqlite] what are the limitations for IN() lists?

[Jay A. Kreibich]

On Wed, Jan 27, 2010 at 12:40:52AM +, Simon Slavin scratched on the wall:
> 
> On 27 Jan 2010, at 12:25am, Jean-Christophe Deschamps wrote:
> 
> > Why don't you use a :memory: database for this?
> 
> This has the advantage of removing the chance of a name-space collision.


  Can't happen with a temp database anyways.  Like in-memory databases,
  temp databases are only associated with one database connection.

  Also, if you set "PRAGMA temp_store=memory" then your temp database
  *is* an in-memory database.

  Regardless, temp database are always cleaned up when the database
  connection is closed.  And since temp tables and indexes go into the
  temp database, and not your main active database, there is no
  long-term maintenance.

   -j

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

"Our opponent is an alien starship packed with atomic bombs.  We have
 a protractor."   "I'll go home and see if I can scrounge up a ruler
 and a piece of string."  --from Anathem by Neal Stephenson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] what are the limitations for IN() lists?

[Dan Kennedy]

On Jan 26, 2010, at 7:41 PM, Tim Romano wrote:

> Thanks for the reply, Simon, and the suggestion. You asked if there  
> was
> a problem with creating a TEMP table. I was disinclined to use a  
> joined
> temporary table instead of the IN-list for several reasons.
>
> First and foremost, it is a query-only database and rarely will the
> number of items in the IN-list exceed several dozen. Max would be  
> about
> 1000 in the rarest of cases. SQLite performance is excellent; I don't
> mind a little performance lag when the user says "show me everything".
> My central concern is that the query not fail because the IN-list
> contained too many values.
>
> I am also somewhat in the dark about concurrency issues (if any) in a
> webservice scenario:
>   -- Do TEMP tables have database-connection-scope so that there is no
> need to name the TEMP table uniquely? Does the table get deleted
> automatically when the connection is closed if the client-app  
> neglected
> to DROP it?

Yes and yes.

> Maintenance:
>  Is the space occupied by a temp table reclaimed automatically when it
> is dropped?

I guess technically no. Temp tables are stored in a temporary file  
created
in (and automatically removed from) the filesystem. If you drop a table
the space will not be reclaimed until the connection is closed. It  
will be
reused if you put data into another temp table.

You cannot vacuum the temp database in which temp tables are stored.

Dan.


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

Re: [sqlite] what are the limitations for IN() lists?

[Jean-Christophe Deschamps]

Hello Simon,


>This has the advantage of removing the chance of a name-space collision.

That's true as well: it is an added free bonus.  But honestly I would 
say that for such transient usage a random generated name is fairly 
unlikely to cause real-world problem.

select hex(randomblob(16));
just gave "in a row":
207FA9389DDD09302E61D45E08571BD7
D8D15A725C34263099BCC95373596214
7458A094F3EF6673A7ADADFBF0F54EB3

I doubt somebody would be able to come up with a collision easily.

Even if a collision is utterly unlikely but still possible, I wouldn't 
worry that much for transient table names or transaction ID having only 
few seconds lifespan.

And NO, I don't open here the GUID can of worms for _permanent_ IDs, 
which is a very different story...

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

Re: [sqlite] what are the limitations for IN() lists?

[Simon Slavin]

On 27 Jan 2010, at 12:25am, Jean-Christophe Deschamps wrote:

> Why don't you use a :memory: database for this?

This has the advantage of removing the chance of a name-space collision.  
:memory: databases are not stored in any file on disk, and they can be seen 
only by the process which creates them.

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

Re: [sqlite] what are the limitations for IN() lists?

[Jean-Christophe Deschamps]

Hi Tim,



>I am also somewhat in the dark about concurrency issues (if any) in a
>webservice scenario:
>-- Do TEMP tables have database-connection-scope so that there is no
>need to name the TEMP table uniquely? Does the table get deleted
>automatically when the connection is closed if the client-app neglected
>to DROP it?
>My webservice establishes a new connection to the database before
>each query and immediately closes the connection after the results are
>returned.
>
>Maintenance:
>   Is the space occupied by a temp table reclaimed automatically when it
>is dropped? Or does the use of TEMP tables require periodic maintenance
>using VACUUM?

Why don't you use a :memory: database for this?  I'm doing this in some 
applications and it works very well with little fuss.  I open my main 
(disk-based) base(s) and also create a :memory: one which I attach to 
the main.  Now I can use it at will.  As has been discussed here 
recently, you can't have FK with parents/children in separate bases, or 
other types of split constraints/triggers.

Using an intermediate table like this also gives you more freedom for 
fancy behavior that would be much more difficult or even impossible to 
achieve using only SQL and the main base only (without a temp 
table).  I mean indexing and/or ordering (possibly with complex 
index/collation) your memory table so that a match occurs with best 
speed, a trigger to record which word did the client match in the list, 
a.s.o.

You can create separate tables having unique name or put some 
randomized client transaction_id in a unique table...

Simply drop the table as soon as you (or your client) don't need it 
anymore.

Cheers, 

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

[sqlite] Java and sqlite

[Miloud B.]

Hi guys,

I want to use SQLite in Java applications, what do you advice ? Which 
interface do you use ?
I found two:
http://www.ch-werner.de/javasqlite/ : Which I like a lot but seems no 
longer maintained
and
http://www.zentus.com/sqlitejdbc/

Which on do you think is  better to use ? Have you heard of any other 
interface ?

Thanks a lot

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

Re: [sqlite] what are the limitations for IN() lists?

[Tim Romano]

Thanks for the reply, Simon, and the suggestion. You asked if there was 
a problem with creating a TEMP table. I was disinclined to use a joined 
temporary table instead of the IN-list for several reasons.

First and foremost, it is a query-only database and rarely will the 
number of items in the IN-list exceed several dozen. Max would be about 
1000 in the rarest of cases. SQLite performance is excellent; I don't 
mind a little performance lag when the user says "show me everything". 
My central concern is that the query not fail because the IN-list  
contained too many values.

I am also somewhat in the dark about concurrency issues (if any) in a 
webservice scenario:
   -- Do TEMP tables have database-connection-scope so that there is no 
need to name the TEMP table uniquely? Does the table get deleted 
automatically when the connection is closed if the client-app neglected 
to DROP it?
   My webservice establishes a new connection to the database before 
each query and immediately closes the connection after the results are 
returned.

Maintenance:
  Is the space occupied by a temp table reclaimed automatically when it 
is dropped? Or does the use of TEMP tables require periodic maintenance 
using VACUUM?

Regards
Tim Romano

On 1/25/2010 11:47 AM, Simon Slavin wrote:
> On 25 Jan 2010, at 1:40pm, Tim Romano wrote:
>
>
>> What is the maximum number of literal values that can be put inside the IN ( 
>> ) list ?
>>
>>  select * from T  where aColumn in (1,2,3,4,...)
>>  
>


> How many more ?  1000 ?
>
> That limit is higher than you're worried about.  However, there are other 
> limits which are inherent in processing a SELECT command.  For instance 
> there's a limit on the total length of the SELECT command expressed as a 
> string.  And a limit on the total number of tokens the command is turned 
> into.   And, of course, the longer the command, the slower it will be 
> processed.
>
>
>> BTW, the remote client is passing these explilcit values over the internet 
>> to the server --i.e.  the query cannot be rewritten as follows:
>>
>> select * from T where aColumn in ( select values from T2 where...)
>>
>> at least not without creating temporary tables to hold the value-list sent 
>> by the client.
>>  
> Ah, you agree with my suggestion (the sub-select is more usually represented 
> as a JOIN, sometimes with T2 as the primary rather than the joined table).  
> Is there a problem creating the temporary table ?
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Conditional insertion syntaxe in SQLite

[Igor Tandetnik]

Tiberio, Sylvain  wrote:
> Is it possible to write something like that in SQL (for SQLite of
> course!): 
> 
> If [toDeleteMin,toDeleteMax] is include in an existing range
> Store the existing range value into min and max variables
> Delete [Min,Max]
> Create [Min,toDeleteMin-1]
> Create [toDeleteMax+1,max]
> endif

There are no variables, but you can use a temp table. Something like this:

create temp table Vars(rangeid, existingMin, existingMax);

insert into Vars
select rowid, roomIdMin, roomIdMax from range
where roomIdMin < toDeleteMin and roomIdMax > toDeleteMax;

delete from range where rowid = (select rangeid from Vars);
insert into range select 1, existingMin, toDeleteMin from Vars;
insert into range select 1, toDeleteMax, existingMax from Vars;

drop table Vars;

(Edge conditions are left as an exercise for the reader, I'm pretty sure I got 
them wrong).
-- 
Igor Tandetnik

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

Re: [sqlite] Conditional insertion syntaxe in SQLite

[Tiberio, Sylvain]

Thank you Igor for you quick answer!

I would like to implement the range deletion algorithm in SQL to avoid to
maintain several implementation (C++, PHP...). If there is no other solution
I will do it in C++ and in PHP!

Your SQL statements doesn't work in my case, because I have a trigger that
ignore the insertion of existing range. For instance:
INSERT INTO range VALUES(1,100,199)
Do nothing if the entry (1,100,400) exist because [100,199] is already set
to level=1 by [100,400].

So I must delete the range [100,400] before create [100,199] and
[201,400]...

Is it possible to write something like that in SQL (for SQLite of course!):

If [toDeleteMin,toDeleteMax] is include in an existing range
Store the existing range value into min and max variables
Delete [Min,Max]
Create [Min,toDeleteMin-1]
Create [toDeleteMax+1,max]
endif

Regards,

Sylvain

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik
Sent: Monday, January 25, 2010 5:06 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Conditional insertion syntaxe in SQLite

Tiberio, Sylvain  wrote:
> So I would like to write something like that:
> CASE WHEN
>  EXISTS( SELECT @max=suid_max, @min=roomIdMin FROM range
>WHERE 200 BETWEEN roomIdMin AND roomIdMax
>  AND 400 BETWEEN roomIdMin AND roomIdMax) THEN  DELETE 
> FROM range WHERE roomidm...@min AND roomidm...@max;  INSERT INTO range 
> VALUES (1, @min, 199  );  INSERT INTO range VALUES (1, 301 , @max ); 
> END

Things like this are best done in your application code, rather than a
trigger. SQLite in particular has a limited trigger language, nowhere near
Turing-complete (the way Transact-SQL or PL/SQL are).

However, if you absolutely insist, you can do something like this:

insert into range
select 1, roomIdMin, 199 from range
WHERE 200 BETWEEN roomIdMin AND roomIdMax
AND 400 BETWEEN roomIdMin AND roomIdMax;


insert into range
select 1, 301, roomIdMax from range
WHERE 200 BETWEEN roomIdMin AND roomIdMax
AND 400 BETWEEN roomIdMin AND roomIdMax;

delete from range where rowid =
(select rowid from range
 WHERE 200 BETWEEN roomIdMin AND roomIdMax
AND 400 BETWEEN roomIdMin AND roomIdMax);

Note that if the condition doesn't hold (there is no row encompassing both
200 and 400), all three statements are simply no-ops.

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

Re: [sqlite] Crash inside sqlite3_step

[Kavita Raghunathan]

I found that you are correct. I wasn't reading the valgrind log properly.
Thank you.
Kavita

On 1/25/10 10:26 PM, "Dan Kennedy"  wrote:

> 
> On Jan 26, 2010, at 6:16 AM, Kavita Raghunathan wrote:
> 
>> Following Sql query crashes in allocateCursor inside of sqlite3_step
>> 
>> INSERT INTO EntityTbl (AttrName, AttrEnum, AttrType, AttrValue,
>> ReadWrite, Entity_id) VALUES(Œimage_crc¹, 6008, 16, Œ0¹, 1, 34013184);
>> 
>> I¹m not able to get an understanding of what I might be doing wrong.
>> Please note:
>> 
>> 1.  I have successfully created EntityTbl
>> 2.  I have added n rows successfully into table this is row n+1 that
>> causes a crash
>> 3.  I know previously this group asked me to use valgrind to see if
>> the crash was elsewhere and I did that. I¹ve enclosed the results.
> 
> The valgrind output seems to indicate the problem is not in SQLite, no?
> Function get_default_database() has a buffer overrun in it.
> 
>> 
>> Thanks,
>> Kavita
>> 
>> ==28525== Memcheck, a memory error detector
>> ==28525== Copyright (C) 2002-2009, and GNU GPL'd, by Julian Seward
>> et al.
>> ==28525== Using Valgrind-3.5.0 and LibVEX; rerun with -h for
>> copyright info
>> ==28525== Command: cm
>> ==28525==
>> updating hw address
>> sh: ifconfig: command not found
>> ==28525== Syscall param write(buf) points to uninitialised byte(s)
>> ==28525==at 0x62A44B: ??? (in /lib/libpthread-2.5.so)
>> ==28525==by 0x80661F3: unixWrite (in /home/kraghunathan/views/
>> sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x805F1A3: sqlite3OsWrite (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x8069E19: writeJournalHdr (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x806D416: pager_open_journal (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x806D4E1: sqlite3PagerBegin (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x8071BB3: sqlite3BtreeBeginTrans (in /home/
>> kraghunathan/views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x80852F5: sqlite3VdbeExec (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x808084F: sqlite3Step (in /home/kraghunathan/views/
>> sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x8080A00: sqlite3_step (in /home/kraghunathan/views/
>> sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x80C2866: sf_database_mgr::set_cache_size(sqlite3*,
>> int) (in /home/kraghunathan/views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x80C2AF4:
>> sf_database_mgr::create_database(sqlite3**, char const*) (in /home/
>> kraghunathan/views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==  Address 0x40757b9 is 9 bytes inside a block of size 2,056
>> alloc'd
>> ==28525==at 0x4005903: malloc (vg_replace_malloc.c:195)
>> ==28525==by 0x805F746: sqlite3MemMalloc (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x8060062: mallocWithAlarm (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x806010A: sqlite3Malloc (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x80683CD: pcache1Alloc (in /home/kraghunathan/views/
>> sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x8068541: sqlite3PageMalloc (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x806BA08: sqlite3PagerSetPagesize (in /home/
>> kraghunathan/views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x80713A2: sqlite3BtreeSetPageSize (in /home/
>> kraghunathan/views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x80A3BF5: sqlite3Pragma (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x80BDA6A: yy_reduce (in /home/kraghunathan/views/
>> sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x80BE3CF: sqlite3Parser (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x80BF01E: sqlite3RunParser (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==
>> ==28525== Use of uninitialised value of size 4
>> ==28525==at 0x4007D3C: strcpy (mc_replace_strmem.c:303)
>> ==28525==by 0x804FEB9:
>> fls_entity::get_default_database(sf_db_tbl_t**) (in /home/
>> kraghunathan/views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x804B4E6:
>> cm_entity_manager::update_entity_database(sf_entity*) (in /home/
>> kraghunathan/views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x804B601:
>> cm_entity_manager::update_entity_database() (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x804BB59:
>> cm_entity_manager::do_init_database(char*) (in /home/kraghunathan/
>> views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x804BCDC: cm_entity_manager::cm_entity_manager()
>> (in /home/kraghunathan/views/sfdev-2.0/out/usr/bin/cm)
>> ==28525==by 0x80499FD: main (in /home/kraghunathan/views/
>> sfdev-2.0/out/usr/bin/cm)
>> ==28525==
>> ==28525== Invalid write of size 1
>> ==28525==at 0x4007D3C: strcpy (mc_replace_strmem.c:303)
>> ==28525==by 

Re: [sqlite] Append data to a BLOB field

[Dan Kennedy]

On Jan 26, 2010, at 4:15 PM, cp wrote:

> I'd like to be able to append some data to a binary field (BLOB)
> without reading the original data, concatenating it, and then setting
> it all back. Is this possible?

Append is not possible. But if you preallocate space using
zeroblob() or similar, you can write to it using the incremental
blob API:

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



>
> If matters, I want to append pictures to a field, probably using a
> struct like
>
> struct {
> int   pic_type,
> int   pic_size,
> byte*   pic_data
> }
>
> thanks in advance
> ___
> 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] Append data to a BLOB field

[Igor Tandetnik]

cp wrote:
> I'd like to be able to append some data to a binary field (BLOB)
> without reading the original data, concatenating it, and then setting
> it all back. Is this possible?

As far as I can tell, no.

> If matters, I want to append pictures to a field

Instead of a single field holding multiple pictures, consider a separate table 
where each row would have a blob field storing one picture, and a one-to-many 
relationship between the original table and this new table.

Igor Tandetnik


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

Re: [sqlite] Append data to a BLOB field

[Pavel Ivanov]

No, it's not possible. You can try something like this:

update table_name set blob_value = blob_value||appendix where ...

But here SQLite will still need to read original data, concatenate and
write new, although you by yourself won't read and concatenate
anything. And I'm not sure whether it will work if your blob contains
nulls or any incorrect UTF-8/UTF-16 bytes.


Pavel

On Tue, Jan 26, 2010 at 4:15 AM, cp  wrote:
> I'd like to be able to append some data to a binary field (BLOB)
> without reading the original data, concatenating it, and then setting
> it all back. Is this possible?
>
> If matters, I want to append pictures to a field, probably using a
> struct like
>
> struct {
>  int       pic_type,
>  int       pic_size,
>  byte*   pic_data
> }
>
> thanks in advance
> ___
> 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] Append data to a BLOB field

[cp]

I'd like to be able to append some data to a binary field (BLOB)
without reading the original data, concatenating it, and then setting
it all back. Is this possible?

If matters, I want to append pictures to a field, probably using a
struct like

struct {
 int   pic_type,
 int   pic_size,
 byte*   pic_data
}

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

[sqlite] Crash Calling sqlite3_vfs_unregister

[Israel Lins Albuquerque]

if I call sqlite3_vfs_unregister without initialize the sqlite I have a crash. 
Or if i execute the pseudo-code above too: 
sqlite3_vfs_register(vfs); 
db = sqlite3_open(..., "vfs"); 
sqlite3_close(db); 
sqlite3_vfs_unregister(vfs); 

I'm talking about 3.6.22 version. 

I have maked a patch for this, see file attached. 

-- 

Israel Lins Albuquerque 
Desenvolvimento 
Polibrás Brasil Software Ltda. 


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

[sqlite] Crash Calling sqlite3_vfs_unregister

[Israel Lins Albuquerque]

De: "Israel Lins Albuquerque"  
Para: "sqlite-users-bounces"  
Enviadas: Quarta-feira, 20 de Janeiro de 2010 16:48:52 (GMT-0200) Auto-Detected 
Assunto: Crash Calling sqlite3_vfs_unregister 


if I call sqlite3_vfs_unregister without initialize the sqlite I have a crash. 
Or if i execute the pseudo-code above too: 
sqlite3_vfs_register(vfs); 
db = sqlite3_open(..., "vfs"); 
sqlite3_close(db); 
sqlite3_vfs_unregister(vfs); 

I'm talking about 3.6.22 version. 

I have maked a patch for this, see file attached. 

-- 

Israel Lins Albuquerque 
Desenvolvimento 
Polibrás Brasil Software Ltda. 




-- 

Israel Lins Albuquerque 
Desenvolvimento 
Polibrás Brasil Software Ltda. 


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

Re: [sqlite] how can I get a evaluation copy of CEROD?

[肖韧]

Hi, Simon

I did sent mail to the author - sql...@hwaci.com - twice, but there's no 
response, I guess it might because of too many mails everyday in his mailbox, 
he just don't have time to reply every mail one by one, and that is why I came 
here to look for help. Thank you very much!

--   
Ren
2010-01-26

-
发件人：Simon Davies
发送日期：2010-01-26 16:43:08
收件人：General Discussion of SQLite Database
抄送：
主题：Re: [sqlite] how can I get a evaluation copy of CEROD?

2010/1/26 肖韧 :
> Hi, there
>
> I'm studying sqlite and have a feeling that it might be suitable for my 
> project in plan. But there is a problem, the data need to be managed in this 
> project is huge, up to 200GB per DataBase or even more. So I found this 
> sqlite extension - CEROD, but I don't know how to get the evaluation version 
> of CEROD to do some performance test. My decision of using sqlite or not on 
> the project are based on this test.  Would anybody who knows how to get it 
> give me some kind of hint? Thanks a lot!

See last para in:
http://www.hwaci.com/sw/sqlite/cerod.html

>
> --
> Ren
> 2010-01-26
>
>

Regards,
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] how can I get a evaluation copy of CEROD?

[Simon Davies]

2010/1/26 肖韧 :
> Hi, there
>
> I'm studying sqlite and have a feeling that it might be suitable for my 
> project in plan. But there is a problem, the data need to be managed in this 
> project is huge, up to 200GB per DataBase or even more. So I found this 
> sqlite extension - CEROD, but I don't know how to get the evaluation version 
> of CEROD to do some performance test. My decision of using sqlite or not on 
> the project are based on this test.  Would anybody who knows how to get it 
> give me some kind of hint? Thanks a lot!

See last para in:
http://www.hwaci.com/sw/sqlite/cerod.html

>
> --
> Ren
> 2010-01-26
>
>

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

[sqlite] how can I get a evaluation copy of CEROD?

[肖韧]

Hi, there

I'm studying sqlite and have a feeling that it might be suitable for my project 
in plan. But there is a problem, the data need to be managed in this project is 
huge, up to 200GB per DataBase or even more. So I found this sqlite extension - 
CEROD, but I don't know how to get the evaluation version of CEROD to do some 
performance test. My decision of using sqlite or not on the project are based 
on this test.  Would anybody who knows how to get it give me some kind of hint? 
Thanks a lot!

--
Ren
2010-01-26


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