Re: [sqlite] CREATE FUNCTION

2016-08-22 Thread Kees Nuyt
On Mon, 22 Aug 2016 18:46:30 +, "Rousselot, Richard A" wrote: > Are there any plans to add a CREATE FUNCTION function for SQLite? > Is this an SQLite4 type thing? Many things you would define a SQL function for can also be accomplished with Common Table Expressions (CTE, WITH) and/or trigge

Re: [sqlite] CREATE FUNCTION

2016-08-22 Thread J Decker
And every other scripting language you might suggest for the question 'if It did allow creating a function, what flavor of scripting would you like it to be?' has hooks for sqlite ... well except maybe TSQL. (could I script all my database access to a sqlite3 db from SQL Server? Or as the origin

Re: [sqlite] CREATE FUNCTION

2016-08-22 Thread Richard Hipp
On 8/22/16, Clemens Ladisch wrote: > > But it should be mentioned that SQLite is an _embedded_ database, i.e., it > is meant to be part of a program written in a 'real' programming language, > so with sqlite3_create_function(), there is no use case for the feature I was about to type the same. S

Re: [sqlite] CREATE FUNCTION

2016-08-22 Thread Clemens Ladisch
Rousselot, Richard A wrote: > This communication is the property of CenturyLink and may contain > confidential or privileged information. So, officially, you did not ask anything? Well, then I'm not going to answer. But it should be mentioned that SQLite is an _embedded_ database, i.e., it is

[sqlite] CREATE FUNCTION

2016-08-22 Thread Rousselot, Richard A
Are there any plans to add a CREATE FUNCTION function for SQLite? Is this an SQLite4 type thing? Something similar PostgreSQL? https://www.postgresql.org/docs/9.5/static/sql-createfunction.html This particular class of function is not mentioned in "SQL Features That SQLite Does Not Implement"

Re: [sqlite] Compatibility SEE and System.Data.SQLite

2016-08-22 Thread Bernd Schuhmacher
OK Thanks for the inof. So I know what to look for if needed. Regards Bernd Am 22.08.2016 um 12:18 schrieb Richard Hipp: On 8/22/16, Bernd Schuhmacher wrote: Hi Am 19.08.2016 um 13:43 schrieb Richard Hipp: On 8/19/16, Bernd Schuhmacher wrote: ... No. Databases encrypted by the legacy encr

Re: [sqlite] Compatibility SEE and System.Data.SQLite

2016-08-22 Thread Richard Hipp
On 8/22/16, Bernd Schuhmacher wrote: > Hi > > Am 19.08.2016 um 13:43 schrieb Richard Hipp: >> On 8/19/16, Bernd Schuhmacher wrote: >> ... >> No. Databases encrypted by the legacy encryption mechanism in SDS are >> not readable or writable with SEE, and vice versa. > Thanks for the information. >

[sqlite] sqlite-3.14.1: trace3.test fails on armv7hl

2016-08-22 Thread Jakub Dornak
Hi, I've experienced another test failure during build on architecture armv7hl. The test trace3.test fails. See the attached output. Regards, QB ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mai

[sqlite] sqlite-3.14.1: csv01.test hangs on armv7hl

2016-08-22 Thread Jakub Dornak
Hi, I wasn't able to build sqlite-3.14.1 in Fedora rawhide on architecture armv7hl: https://koji.fedoraproject.org/koji/taskinfo?taskID=15278935 The test csv01.test hangs forever. (I've let it run for whole weekend.) Current workaround in Fedora is to skip this test on armv7hl. Regards, QB _

Re: [sqlite] Multi-column indexing

2016-08-22 Thread R Smith
On 2016/08/22 9:51 AM, Dominique Devienne wrote: On Sun, Aug 21, 2016 at 6:26 PM, Igor Tandetnik wrote: Create your index on nn(rsid, gene). Order of the fields matters. Imagine a phonebook sorted by last name then first name. It's easy to find in it all people named John Smith, or all peopl

Re: [sqlite] Multi-column indexing

2016-08-22 Thread Dominique Devienne
On Sun, Aug 21, 2016 at 6:26 PM, Igor Tandetnik wrote: > Create your index on nn(rsid, gene). Order of the fields matters. Imagine > a phonebook sorted by last name then first name. It's easy to find in it > all people named John Smith, or all people with last name of Smith, but > it's of no help