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
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
,
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
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
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
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>
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
22 matches
Mail list logo