Re: [sqlite] Messages posted on Nabble not getting to list

27.5.2016, 2:48, Balaji Ramanathan kirjoitti: Why does SQLite use a mailing list instead of a proper web-hosted forum/bulletin board type setup? Is there any forum platform whose usability is not totally terrible compared to mailing lists? First of all, to keep track of who has replied to wh

Re: [sqlite] SQLite as a Logger: How to mimic "rotation of logs"?

El mar, 10-05-2011 a las 12:34 +0100, Simon Slavin escribió: > On 10 May 2011, at 11:42am, Lynton Grice wrote: > > > BTW: if I am using SQLIte as a logger, what PRAGMA statement can I use > > to say FIX the sqlite database size to say "5 MB"? > > There isn't one. SQLite would not know which rec

[sqlite] Aggregates in SELECT without GROUP BY

Hello, SQLite seems to be accepting SELECT queries that use aggregate functions without a GROUP BY. This is a little dangerous, because queries that should not work at all are returning sensible-looking results. Example: Let's have a simple table T with the following structure and content:

Re: [sqlite] malloc(0) in sqlite3_exec

D. Richard Hipp wrote: On Wed, 2005-06-29 at 15:19 +0300, Lauri Nurmi wrote: So, basically, is there a reason why sqlite3Malloc(n) & co should even try to allocate zero bytes, instead of just returning NULL if n==0? Does a pointer pointing to zero bytes of memory have any use anyway? Yes

Re: [sqlite] malloc(0) in sqlite3_exec

lly undefined. > (http://www.opengroup.org/onlinepubs/009695399/functions/malloc.html) > Are there any reason to invoke malloc(0) ? > > Sincerely, > > Mikio Kishi. > -- Lauri Nurmi Ksenos DVR Development