Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread Stephen Chrzanowski
2019 WISH LIST --- - A list of libraries that are known to be successfully added to SQLite. - Have a base instance, select some check-boxes, press SUBMIT, something somewhere somehow generates your .DLL, .SO, etc. so that you have everything you want built in - A million

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread Warren Young
On May 23, 2019, at 4:28 PM, R Smith wrote: > > it is very easy to add things to the base distro, but extremely hard to > impossible to ever take it away again, which means one should only ever "add" > with great caution. Easy fix: -DSQLITE_OMIT_EXTENDED_MATH_LIBRARY Include it by default, bu

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread R Smith
On 2019/05/23 1:26 PM, J. King wrote: On May 23, 2019 6:46:52 a.m. EDT, R Smith wrote: This is SQLite. Perhaps some of us could collaborate on a fork called SQLbloat //.. I find this a little condescending. There's a lot of reasons to like SQLite, and the aspect that sways me more than other

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread Jose Isaias Cabrera
J. King, on Thursday, May 23, 2019 07:26 AM, wrote... >On May 23, 2019 6:46:52 a.m. EDT, R Smith wrote: > >>This is SQLite. Perhaps some of us could collaborate on a fork called >>SQLbloat and put out standard libs/code/precompileds for versions of >>sqlite with everything - bbq sauce and all, fo

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread sky5walk
Thank you for bringing topic back to original intent. Clearly much is missing from the latest SQL standard. Debates aside, the URL is equally lacking. Yes, "own" extensions solve much of my needs. On Thu, May 23, 2019, 7:26 AM J. King wrote: > On May 23, 2019 6:46:52 a.m. EDT, R Smith wrote: >

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread J. King
On May 23, 2019 6:46:52 a.m. EDT, R Smith wrote: >This is SQLite. Perhaps some of us could collaborate on a fork called >SQLbloat and put out standard libs/code/precompileds for versions of >sqlite with everything - bbq sauce and all, for when you don't need >Lite >- then you can specify that

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread Thomas Kurz
riginal Message - From: R Smith To: sqlite-users@mailinglists.sqlite.org Sent: Thursday, May 23, 2019, 12:46:52 Subject: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement Ok, but you can't have it both ways. Either you want to write generic use-everywhere SQL, in which ca

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread R Smith
- Original Message - From: Hick Gunter To: 'SQLite mailing list' Sent: Thursday, May 23, 2019, 11:58:10 Subject: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement Put your function into a loadable extension and load it during application startup so that it

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread Thomas Kurz
other viewer that doesn't have the extension. - Original Message - From: Hick Gunter To: 'SQLite mailing list' Sent: Thursday, May 23, 2019, 11:58:10 Subject: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement Put your function into a loadable extensio

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread Hick Gunter
von Thomas Kurz Gesendet: Donnerstag, 23. Mai 2019 11:41 An: SQLite mailing list Betreff: Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement I want to define VIEWs that work equally well regardless of whether a default sqlite3.dll or a custom build with built-in extension

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread Thomas Kurz
custom build is used? That doesn't make any sense to me?!? - Original Message - From: Hick Gunter To: 'SQLite mailing list' Sent: Thursday, May 23, 2019, 10:02:30 Subject: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement Just write a functi

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019-05-23 Thread Hick Gunter
Just write a function that takes a function name, a default value and an unspecified number of arguments. function_present(,[,]) The implementation will then check if the named function is available; If so, prepare, execute and return the result of "SELECT ()" If not, just return . This is prob