[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Alessandro Marzocchi
ASFAIK also gcc uses some kind of intermediate rapresentation during compilation process... gimple (gcc -fdump-tree-all) and rtl (-dump-rtl-all) Il 16/giu/2015 22:40, "Simon Slavin" ha scritto: > Since this thread has ... become what it is ... I may as well add a couple > of details. > > The wide

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Marc L. Allen
I don't know. Back in the day, assembly was low-level because it was directly converted to machine code. C was high level because you could express more complex structures without worrying about the underlying architecture. I still like that distinction. I think people are trying to call C low

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Simon Slavin
Since this thread has ... become what it is ... I may as well add a couple of details. The widely-used compiler LLVM uses an intermediate representation of your code, called 'Bitcode'. In other words, it's not a simple case of compiling straight to object code. This feeds into some distinctio

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Simon Slavin
On 16 Jun 2015, at 7:44pm, James K. Lowden wrote: > wrote: > >> What would make a database programming better, or best? > > Two things I've often pointed to are namespaces and regular > expressions. Another is compound datatypes. I don't have your problem with namespaces since, to me, the

[sqlite] malformed database schema

2015-06-16 Thread Christian Nassau
Dear group, We encountered a somewhat obscure scenario that leaves an sqlite database in a corrupted state (tested with sqlite 3.8.8). Our case deals with - an in-memory database "db" with an attached file database "other.db". - "db" starts a transaction, - "db" tries to create a table

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Darren Duncan
On 2015-06-16 11:44 AM, James K. Lowden wrote: > On Tue, 16 Jun 2015 09:56:38 +1000 wrote: > >> The question is: what should a database language do? Andl can already >> match or surpass SQL on database programming tasks, but is that >> interesting enough? >> >> What would make a database programmi

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Jonathan Moules
p.s. The spellchecker just kindly advised that maybe changing the name of "andl" might help reduce future unfortunate typos / "corrections". :-) -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jon

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Jonathan Moules
> The question is: what should a database language do? Andl can already match > or surpass SQL on database programming tasks, but is that interesting enough? As much as anything, that depends on what problem you're targeting, and even your audience. At the risk of rekindling the High/low/assembl

[sqlite] Is recursive CTE fully capable?

2015-06-16 Thread James K. Lowden
On Mon, 15 Jun 2015 11:03:17 +1000 wrote: > >>>Unless the recursion is circular, I don't see how an SQL query > >>>over a finite database could fail to terminate. > > What does this mean? It is trivial to write a recursive CTE that does > not terminate, and the property of "circularity" is not

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread James K. Lowden
On Tue, 16 Jun 2015 09:56:38 +1000 wrote: > The question is: what should a database language do? Andl can already > match or surpass SQL on database programming tasks, but is that > interesting enough? > > What would make a database programming better, or best? Two things I've often pointed to

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread James K. Lowden
On Tue, 16 Jun 2015 10:36:45 +0200 Marco Bonardo wrote: > The contents of the page came out from actual bugs and misuses we hit > in years of use and experience with it and were discussed with > attention. Most also have workarounds or suggested fixes. While I'm sure that's true, the page is fil

[sqlite] What's the best way to pass function information to virtual table?

2015-06-16 Thread Jerry
Hi, I am working on sqlite+rocksdb, i.e., using rocksdb as the back-end using sqlite virtual table. With xBestIndex and xFilter, we can pass the constraint information (e.g., those from WHERE clause) to virtual table (through struct sqlite3_index_info), so that we can locate the cursor to narrow t

[sqlite] SQLite parser library

2015-06-16 Thread Kristoffer Danielsson
Hi, Some time ago I created a complete parser for SELECT statements in SQLite (based on the grammar found in the source code). Sample code below! Understanding how the Lemon parser works, creating the abstract syntax tree (AST), and implementing the parser classes turned out to be extraordinary h

[sqlite] malformed database schema

2015-06-16 Thread Richard Hipp
On 6/16/15, Christian Nassau wrote: > Dear group, > > We encountered a somewhat obscure scenario that leaves an sqlite database in > a corrupted state (tested with sqlite 3.8.8). Thanks for the bug report and for the reproducible test case. This problem goes back to before version 3.5.1 (circa 2

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Marco Bonardo
2015-06-16 1:36 GMT+02:00 Jean-Christophe Deschamps : > While I can agree with some of the most obvious "don't be dumb" remarks, > there are many things that can't be let unchallenged. And I don't > appreciate the overall tone: "WE at MozillaBigBalls are all clever enough > to use SQLite smartly b

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Christopher Vance
With a relational model you have a choice between relational calculus or relational algebra. SQL does one of them. I have used a language which did the other, long ago in a land far away. On Tue, Jun 16, 2015 at 9:56 AM, wrote: > >>>I think the best database language should reflect how earthlin

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Marco Bonardo
2015-06-15 18:05 GMT+02:00 Jean Chevalier : > 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

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread da...@andl.org
>>>I think the best database language should reflect how earthlings think about the data, and the best computer programming language would reflect easily the result we want get from them. Care to expand on that? I'm developing a new database language: Andl. My starting point has been the relation

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Kevin Youren
In my tool box, I have a tack hammer, a claw hammer and a nail gun. I broke my fingernail with the tack hammer. I still have the bandaid on my thumb from the claw hammer. Now I just have to read the instruction manual for the nail gun

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Jean-Christophe Deschamps
I've refrained to comment about the OP linked page but I can't resist that long. I won't enter the C, C--, C++, C#, Java, Python, COBOL, Basic, assembler, Ruby, YouNameIt sub-debate. I found the rant on MozillaWiki way too wrong on too many points to keep quiet. While I can agree with some of