Re: [sqlite] An inconsistency between sqlite implementation and documentation of zlib API deflate

2019-10-11 Thread Dan Kennedy
On 11/10/62 06:18, 吕涛 wrote: Hi, there is an inconsistency between sqlite implementation and documentation of zlib API deflate in the file /ext/misc/zipfile.c:1003. 1000 deflateInit2(, 9, Z_DEFLATED, -15, 8, Z_DEFAULT_STRATEGY); 1001 res = deflate(, Z_FINISH); 1002 1003 if(

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

2019-10-11 Thread Tim Streater
On 11 Oct 2019, at 16:56, Brannon King wrote: > I agree that Mailman is archaic. I worry about the security on it. I don't > enjoy using 3rd-party mirrors for searching it. I'd like to propose that we > upgrade to something more modern and secure like Sympa or mlmmj, or even a > more drastic

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

2019-10-11 Thread Mike Bayer
Are there specific Mailman CVEs you can refer towards such that these settings could not be opened up? The read-only archives appear to be static files, so there is no additional security issue that isn't already presented by the existing cgi-bin already open for public access. Similarly for

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

2019-10-11 Thread Brannon King
I agree that Mailman is archaic. I worry about the security on it. I don't enjoy using 3rd-party mirrors for searching it. I'd like to propose that we upgrade to something more modern and secure like Sympa or mlmmj, or even a more drastic system upgrade to something like Redmine -- a project

[sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

2019-10-11 Thread Mike Bayer
Apologies if this has been asked before but what is the reason that the SQLite mailing list archives, linked at http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users, are private for members only in order to be read? The archives can be viewed at a mirror such as

Re: [sqlite] insertion of a single record taking more than 200 msec some times

2019-10-11 Thread David Raymond
Without more info it's impossible to say. The immediate possibility coming to mind would be if you're running in WAL mode, and that happened to be the commit that triggered a checkpoint, meaning you have both the commit time and the checkpoint time in there. Depending on how much there was to

Re: [sqlite] system.data.sqlite example code?

2019-10-11 Thread jones510
Nice to see about the information here, thanks for sharing https://trainsrunningstatus.live -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] insertion of a single record taking more than 200 msec some times

2019-10-11 Thread GopiKrishna Parisa
Hi, i have a requirement to store logs while my app is running. i am using sqlite3 to store logs. i was trying to get some benchmark data by inserting logs on top of 6 records. One weird thing is for some insertions, it's taking more than 200 msec for single record where as others takes around

[sqlite] An inconsistency between sqlite implementation and documentation of zlib API deflate

2019-10-11 Thread 吕涛
Hi, there is an inconsistency between sqlite implementation and documentation of zlib API deflate in the file /ext/misc/zipfile.c:1003. 1000 deflateInit2(, 9, Z_DEFLATED, -15, 8, Z_DEFAULT_STRATEGY); 1001 res = deflate(, Z_FINISH); 1002 1003 if( res==Z_STREAM_END ){ 1004