[sqlite] User-defined types -- in Andl

Just a quick progress report, in case anyone is interested. First, I added a RECURSE() function to Andl, similar to the CTE in SQLite. The Mandelbrot algorithm looks like this. xaxis := {{ x:=-2.0 }} recurse( {{ x:=x+0.05 }} [?(x<1.2)]) yaxis := {{ y:=-1.0 }} recurse( {{ y:=y+0.1 }} [?(y<1.1)])

[sqlite] Mozilla wiki 'avoid SQLite'

On 14 Jun 2015, at 9:19pm, Richard Hipp wrote: > There was a huge debate in > the software industry in the 1980s about whether applications should > be coded in assembly or C. Hand-coded assembly is theoretically > faster than machine-code generated by a C compiler (or at least it was > in the

[sqlite] Mozilla wiki 'avoid SQLite'

On 15/06/15 01:00, Simon Slavin wrote: Simon, > Perhaps the next generation of computer languages will be designed by > computer, to let us speak to them in an efficient manner. > I'm sure computer would insist on C, if not, then it's apparently a software bug. On a serious note, i think

[sqlite] User-defined types -- in Andl

If you have some test data I'll happily do that one. Meanwhile here is something similar, using the test data from the SQLite CTE page. orgchart name | boss - Alice | Bob | Alice Cindy | Alice Dave | Bob Emma | Bob Fred | Cindy Gail | Cindy ua := {{ name:= 'Alice', level := 0

[sqlite] Is recursive CTE fully capable?

>>>The task is to write some SQL code, including as many INSERT/UPDATE/DELETEs as you want to make other tables with information about the program, with a final SELECT which returns TRUE if and only if the program will halt. SQL with Recursive CTE is Turing Complete. The above is provably

[sqlite] Is recursive CTE fully capable?

>>>There are queries that cannot be formulated in first order predicate logic, and recursion is the single capability of SQL that exceeds FOPL power. True, wrt SQLite and its dialect, for which RCTE provides Turing Completeness. Untrue for dialects of SQL that include PSM. >>>Unless the

[sqlite] Mozilla wiki 'avoid SQLite'

I won't abuse the patience of our hosts by prolonging this debate, but I disagree strongly with this theme. I have almost certainly written more C/C++ code than you or most of the people on this list, and I never choose it first. I am personally at least 3 times as productive in C# as I am in C

[sqlite] Mozilla wiki 'avoid SQLite'

On 6/14/2015 11:28 PM, david at andl.org wrote: > I won't abuse the patience of our hosts by prolonging this debate, but I > disagree strongly with this theme. So you disagree with a disagreement? > I have almost certainly written more C/C++ code than you or most of the > people on this list,

[sqlite] Mozilla wiki 'avoid SQLite'

Oh dear. So you think that a high level language is one that does things by calling a lower level language? Stop embarrassing yourself. A high level language is one where the language designers are free to use whatever structural concepts best fit the problems that the language is designed

[sqlite] Mozilla wiki 'avoid SQLite'

As I said, I won't fuel the fire. This is the wrong place for this kind of debate, and you should realise that. Your post reflects immaturity and narrow experience, but I won't be the one to broaden your outlook. Your post contains provable errors of fact, but I won't be correcting them. The

[sqlite] Mozilla wiki 'avoid SQLite'

Ditto. My C# code routinely gets close to native C performance whenever I get around to benchmarking it, which is not often these days. And I can actually write code that runs safely on my 8 cores or on my teraflop GPU if I really need the speed. But as I said, I really don't think this is the

[sqlite] This mailing list seems to be public

I was under the impression that this mailing list was restricted to members. However: http://sqlite.1065341.n5.nabble.com/Under-what-circumstances-can-a-table-be- locked-when-the-database-is-first-opened-td82371.html http://comments.gmane.org/gmane.comp.db.sqlite.general/95119

[sqlite] This mailing list seems to be public

I thought it had always been open - you just need to subscribe to be able to post. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a

[sqlite] This mailing list seems to be public

On Jun 15, 2015, at 6:42 AM, wrote: > I was under the impression that this mailing list was restricted to members. > However: > > http://sqlite.1065341.n5.nabble.com/Under-what-circumstances-can-a-table-be- > locked-when-the-database-is-first-opened-td82371.html >

[sqlite] Mozilla wiki 'avoid SQLite'

This is not an answer to just the latest post, it is directed at multiple posts. 1. C# is typically compiled to Common Intermediate Language which very much is a form of "byte code" in that it is not directly executed by the processor. The .net environment will just in time compile that into a

[sqlite] Mozilla wiki 'avoid SQLite'

> On 15 Jun 2015, at 15:44, Scott Robison wrote: > > Too many of these technology based discussions (whether languages or > operating systems or text editors or database engines or whatever) break > down into almost a religious fervor of "this is the one true You mean like your comment from

[sqlite] Mozilla wiki 'avoid SQLite'

Perhaps you might want to consider an apology and check your headers next time. I'm pretty sure the comment you quoted from this morning was written by Scott Doctor, not Scott Robinson. -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] Mozilla wiki 'avoid SQLite'

What I'm thinking now is to what extent the developer who put up the Mozilla wiki page was entitled to put up opinions and statements either expressed or implied about a third-party product on behalf of the Mozilla Foundation (though is that the same Foundation that pays the Consortium member

[sqlite] Mozilla wiki 'avoid SQLite'

On Mon, Jun 15, 2015 at 9:08 AM, Marc L. Allen wrote: > Perhaps you might want to consider an apology and check your headers next > time. > > I'm pretty sure the comment you quoted from this morning was written by > Scott Doctor, not Scott Robinson. > Thanks for the reply to the list. I'd

[sqlite] MyJSQLView Version 7.03 Released

The MyJSQLView project is pleased to release v7.03 to the public. The release is to fix the plugin management tool proxy setting property. Remote HTTP repositories can not be created or loaded. The release also is for archiving purposes to finalize the last release before the move of the code

[sqlite] Mozilla wiki 'avoid SQLite'

> Mensaje original > De: Scott Hess > Para: General Discussion of SQLite Database mailinglists.sqlite.org> > Fecha: Sun, 14 Jun 2015 10:10:24 -0700 > Asunto: Re: [sqlite] Mozilla wiki 'avoid SQLite' > While certainly, the thread has derived from the concept of the OP, and even some

[sqlite] This mailing list seems to be public

Like most mailing lists about open source software, list archives are visible to the general public, which is what I think should be the norm. Generally restrictions to members just concern posting, its a simple way to keep spam out, one has to confirm an email address to post. -- Darren

[sqlite] relational algebra vs calculus (was Re: Mozilla wiki 'avoid SQLite')

Actually, SQL does a mixture of both relational calculus and relational algebra, but not necessarily all of either. Seeing the algebra is fairly straightforward, eg the UNION or WHERE etc. An example of the calculus is seen in SELECT...FROM... involving a JOIN, for example: SELECT