[sqlite] SQLite Extensions

Any chance of a GitHub etc repo for others to maybe fork? Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Keith Medcalf

[sqlite] SQLite Extensions

On Friday, 20 November, 2015 07:55, Gabor Grothendieck said: > Can you include in the distribution the precise code (make file or > .bat file, etc.) used to build these. Thanks. Done. The zip now contains a MakeExtGCC to compile with MinGW and a MakeExtMS to compile with MSVC You just need

[sqlite] SQLite crashes

On 20 Nov 2015, at 3:07pm, Harmen de Jong - CoachR Group B.V. wrote: > SQLITE crashes at least once a day on a heavily loaded database Can you run PRAGMA integrity_check on the database ? If you don't want to tie up your live copy, copy it somewhere else and run the PRAGMA on the copy.

[sqlite] Select values from a time series spaced at least a mininum distance apart

Ahh, thank you very much for not only solving my problem, but also showing me some features of the language I wasn't aware of. Greatly appreciated! Best regards, Ilja On 20/11/15 14:15, E.Pasma wrote: > 20 nov 2015, 09:19, Clemens Ladisch: > >> E.Pasma wrote: >>> An aggregate function can

[sqlite] SQLite crashes

SQLITE crashes at least once a day on a heavily loaded database (database size is approximately: 17 GB). On the same server we are running several other instances of SQLite that have databases that are much bigger in size with approximately the same load, however these are not crashing. The

[sqlite] Fw: very important message

Hello! New message, please read ronny.dierckx at telenet.be

[sqlite] Select values from a time series spaced at least a mininum distance apart

20 nov 2015, 09:19, Clemens Ladisch: > E.Pasma wrote: >> An aggregate function can still be used in a sub-query for a column >> value. For the example with integers: >> >> WITH RECURSIVE >> breaks(t) AS ( >> SELECT 1 >> UNION >> SELECT (SELECT min(x) FROM test WHERE x > t + 2 AND x < 10)

[sqlite] INSERT DEFAULT literal-value

It would be useful as a convenience, particularly on very?long?tables,?so the user could omit all names and just use a single DEFAULT in the particular value. It's also easier to programmatically decide whether to insert a DEFAULT, NULL,?or an alternate value rather than selectively omitting a

[sqlite] will aggregate functions be added to the json extension ?

Hello, Are there any plans to add aggregate functions to the json extension so that json arrays can be produced from a result set? I found a message on the json feedback thread from a few months ago that brought this up, but there didn't seem to be a response:

[sqlite] SQLite Extensions

Thanks for sharing this, Keith! 2015-11-20 6:42 GMT+01:00 Keith Medcalf : > > For anyone who is interested, I have compiled for 32-bit Windows all the > extensions that are included in the SQLite3 distribution /ext/misc > directory using MinGW (gcc 4.8.1) and have added a few others I have >

[sqlite] SQLite crashes

On 11/20/15, Harmen de Jong - CoachR Group B.V. wrote: > > Any ideas on how we could further investigate these crashes? > (1) Recompile with the following compile-time options: -DSQLITE_DEBUG -DSQLITE_OMIT_LOOKASIDE (2) Enable whatever AddressSanitizer tools

[sqlite] SQLite Extensions

Can you include in the distribution the precise code (make file or .bat file, etc.) used to build these. Thanks. On Fri, Nov 20, 2015 at 12:42 AM, Keith Medcalf wrote: > > For anyone who is interested, I have compiled for 32-bit Windows all the > extensions that are included in the SQLite3

[sqlite] Select values from a time series spaced at least a mininum distance apart

E.Pasma wrote: > An aggregate function can still be used in a sub-query for a column value. > For the example with integers: > > WITH RECURSIVE > breaks(t) AS ( >SELECT 1 >UNION >SELECT (SELECT min(x) FROM test WHERE x > t + 2 AND x < 10) >FROM breaks > ) > SELECT t FROM

[sqlite] INSERT DEFAULT literal-value

chromedout64 at yahoo.com wrote: > Is it possible to implement a DEFAULT literal-value in SQLite, which > would allow an individual column to be populated with a DEFAULT, similar > to how a NULL or CURRENT_TIMESTAMP is currently used? What is this needed for, when it is already possible to omit

[sqlite] SQLite Extensions

Thanks for sharing this, Keith! 2015-11-20 6:42 GMT+01:00 Keith Medcalf : > > For anyone who is interested, I have compiled for 32-bit Windows all the > extensions that are included in the SQLite3 distribution /ext/misc > directory using MinGW (gcc 4.8.1) and have added a few others I have >

[sqlite] SQLite Extensions

Slight changes made to the hash functions. The md2 / md4 / md5 / sha / sha1 / sha256 / sha384 / sha512 now return uppercase hex strings. This is because of the addition of functions that return the raw binary blob of the hash value, which will cut the bytes consumed to store that hashes in

[sqlite] INSERT DEFAULT literal-value

Is it possible to implement a DEFAULT literal-value in SQLite, which would allow an individual column to be populated with a DEFAULT, similar to how a NULL or CURRENT_TIMESTAMP is currently used? Thanks. for example, from http://www.postgresql.org/docs/9.4/static/sql-insert.html [ WITH [