[sqlite] SQLite vs GPLed software

2016-05-02 Thread Richard Hipp
On 5/2/16, Roger Binns wrote: > On 02/05/16 16:42, Richard Hipp wrote: >> But some of the discussion did get me >> thinking about the extent of GPLed software versus SQLite. > > Something that needs be made abundantly clear is the GPL is *not* about > popularity. The GPL is about freedom (think f

[sqlite] SQLite vs GPLed software

2016-05-02 Thread Richard Hipp
On 5/2/16, Simon Slavin wrote: > > How about libjpeg ? Or libpng or whatever ? Neither is GPL software. -- D. Richard Hipp drh at sqlite.org

[sqlite] SQLite vs GPLed software

2016-05-02 Thread Roger Binns
, Music Player is using it, Browser is using it). Roger -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 181 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqli

[sqlite] SQLite vs GPLed software

2016-05-02 Thread Scott Robison
On Mon, May 2, 2016 at 6:10 PM, Richard Hipp wrote: > On 5/2/16, Scott Robison wrote: > > I don't have an answer, but given that each linux distro of dozens or > > hundreds of independently sourced packages has many separate instances of > > the GPL, that would begin to eat into SQLITE'S lead. B

[sqlite] SQLite vs GPLed software

2016-05-02 Thread Richard Hipp
On 5/2/16, Scott Robison wrote: > I don't have an answer, but given that each linux distro of dozens or > hundreds of independently sourced packages has many separate instances of > the GPL, that would begin to eat into SQLITE'S lead. But probably not > enough to win. What GPLed packages are on A

[sqlite] SQLite vs GPLed software

2016-05-02 Thread Roger Binns
8< Roger -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 181 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160502/db351213/attachment.pgp>

[sqlite] SQLite vs GPLed software

2016-05-02 Thread Richard Hipp
There is a discussion over on HN (https://news.ycombinator.com/item?id=11577917) about the relative merits of GPL versus other kinds of free and public domain software. I won't enter into that debate. But some of the discussion did get me thinking about the extent of GPLed software versus SQLite.

[sqlite] Extended Text Functions

2016-05-02 Thread Simon Slavin
On 2 May 2016, at 6:07pm, Eric Kestler wrote: > I'm looking for a release of SQLite that included extended text > functionality; specifically, the SQL Server charindex function. Won't happen. Sorry. > Is there any reason not to include more text functions into the core SQLite > release? I'm

[sqlite] SQLite vs GPLed software

2016-05-02 Thread Darren Duncan
On 2016-05-02 6:24 PM, dandl wrote: >>From a purely numerical point of view, the largest numbers would be found in > devices, eg phones, cars, TVs, clocks/timers, etc. Lots of GPL in there, but > also lots of other licences too. I have no idea how the GSM stack is > licensed, for example, but I thi

[sqlite] Extended Text Functions

2016-05-02 Thread Tim Streater
On 02 May 2016 at 18:07, Eric Kestler wrote: > I'm looking for a release of SQLite that included extended text > functionality; specifically, the SQL Server charindex function. > > Is there any reason not to include more text functions into the core SQLite > release? I'm sure many of us would li

[sqlite] SQLite vs GPLed software

2016-05-02 Thread Scott Robison
I don't have an answer, but given that each linux distro of dozens or hundreds of independently sourced packages has many separate instances of the GPL, that would begin to eat into SQLITE'S lead. But probably not enough to win. On May 2, 2016 5:42 PM, "Richard Hipp" wrote: > There is a discussio

[sqlite] Make mmap_size dynamic?

2016-05-02 Thread Richard Hipp
On 5/2/16, Mikael wrote: > > If I just force it on (by hacking the build script), as long as mmap_size > always is 2^63, will Sqlite access the file via memory accesses only, and > never using fread/fwrite which would lead to undefined behavior because of > the absence of a UBC? > SQLite only rea

[sqlite] Make mmap_size dynamic?

2016-05-02 Thread Mikael
Dear Dr. Hipp & list, What about making Sqlite's memory mapping adapt to the current database size, in increments of say 100MB? The at least 48 bits (256TB) of addressing space that modern 64bit architectures give per process is not suffering any risk of depletion, as long as the space not is use

[sqlite] Make mmap_size dynamic?

2016-05-02 Thread Scott Hess
If you're enabling mmap on a platform where it is intentionally not enabled by SQLite, then you probably need to get in and thoroughly verify that it's going to work correctly. You'll need to enable SQLITE_MMAP_READWRITE, obviously, but I don't think there's anything in there which makes the guara

[sqlite] Extended Text Functions

2016-05-02 Thread Eric Kestler
I'm looking for a release of SQLite that included extended text functionality; specifically, the SQL Server charindex function. Is there any reason not to include more text functions into the core SQLite release? I'm sure many of us would like to see them and ease the burden of workarounds. For t

[sqlite] Differences for DELETE with EXISTS

2016-05-02 Thread Rob Golsteijn
Hi List, I observe a difference in results of a DELETE query using the EXISTS operator between Sqlite version 3.8.11.1 and 3.9.0. After executing DELETE the number of remaining rows in the table differs. I can't figure out if this is regression, an improvement, or that the behavior is just undef

[sqlite] Make mmap_size dynamic?

2016-05-02 Thread Scott Hess
The existing mmap functionality only maps the actual blocks associated with the file. So if your file is 16kb and your mmap_size is 1GB, only 16kb is used. Unless you add data to the file, then the mmap area grows, obviously. -scott On Mon, May 2, 2016 at 2:01 AM, Mikael wrote: > Dear Dr. Hi

[sqlite] Version 3.13.0 coming soon

2016-05-02 Thread Richard Hipp
We hope to have the 3.13.0 release of SQLite ready soon. Your assistance in testing the latest snapshot (available at https://www.sqlite.org/download.html) is greatly appreciated. A change summary for 3.13.0 is at https://www.sqlite.org/draft/releaselog/3_13_0.html The first bullet in the change

[sqlite] Recent downloads gone? Bad http returns

2016-05-02 Thread Richard Hipp
On 4/28/16, Roger Binns wrote: > On 28/04/16 12:56, Richard Hipp wrote: >> I intentionally removed 3.12.0 and 3.12.1 because they can (under >> obscure circumstances) generate incompatible databases. > > I have no problems with removing the links to those downloads, but > removing the downloads th

[sqlite] Differences for DELETE with EXISTS

2016-05-02 Thread Richard Hipp
On 5/2/16, Rob Golsteijn wrote: > > I observe a difference in results of a DELETE query using the EXISTS > operator between Sqlite version 3.8.11.1 and 3.9.0. Thanks for the bug report. Ticket: https://www.sqlite.org/src/info/dc6ebeda9396087 Candidate fix: https://www.sqlite.org/src/info/3f221f5

[sqlite] Illegal SQL not rejected

2016-05-02 Thread Hick Gunter
This is the much discussed and misunderstood feature that enables SQLite to process statements like SELECT A, B, MAX(C) FROM TABLE GROUP BY B; and return the (or one of the) value(s) of A associated with the maximum value of C within each group of B in just one full table scan. By extension, t

[sqlite] Processing arguments in a user-defined function

2016-05-02 Thread Hick Gunter
The Pointer you received calling sqlite3_value_test16() on the FIRST argument is not invalidated by calling the same function on the SECOND argument. Value conversions may (and do for specific calling sequences) happen only when calling a different sqlite3_value_x() function on the SAME argument