[sqlite] editline/readline.h' file not found

Hello All, Is anyone else getting this strange fatal error when building sqlite from source: touch .target_source tclsh8.6 /home/jungle/fossil-repos/sqlite3/tool/mksqlite3c.tcl cp tsrc/shell.c tsrc/sqlite3ext.h . ./libtool --mode=compile --tag=CC cc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/home/jungle/fo

[sqlite] A little light reading

On 2015/11/08 6:11 PM, John McKown wrote: > I'm not a developer. So I guess that it's my ignorance as to why a program > would be confused by the string value of "null" or any variant thereof. I > do understand looking for a string of length 0. If I were to want a special > name for Some purpose,

[sqlite] A little light reading

On Sun, Nov 8, 2015 at 5:11 PM, John McKown wrote: > I'm not a developer. So I guess that it's my ignorance as to why a program > would be confused by the string value of "null" or any variant thereof. Consider this XML snippet, which very likely passes through some of the apps Mr. Null has bee

[sqlite] A little light reading

On 8 Nov 2015, at 4:11pm, John McKown wrote: > I'm not a developer. So I guess that it's my ignorance as to why a program > would be confused by the string value of "null" or any variant thereof. NULL has a special meaning in SQL and some other database languages. Depending on what the progra

[sqlite] A little light reading

On Sun, Nov 8, 2015 at 1:25 PM, Nicolas J?ger wrote: > > reminds me when, because of some "idiots database programmers", I got (during > the same month) three > cards automatically from the health care system with three times my name > wrongly printed (because of > the "?"). Of course having mo

[sqlite] A little light reading

El 08/11/15 a les 11:55, Simon Slavin ha escrit: > An article by Christopher Null on how database programmers are idiots. > > Come to think of it, if you stare at the above line for long enough you won't > need the article. But here it is anyway: > > Obligato

[sqlite] A little light reading

On Sun, Nov 8, 2015 at 2:42 PM, John McKown wrote: > (...) What if the person is alive? What if you don't now the birth day?). NULLs, as you mentioned, are questioned in many domains. They provide an easy solution, but never the only one there is. In an OOP system, for instance, LivingPerson and

[sqlite] Minor errors in the documentation, building sqlite

Hello. In this mail I'd like to point out some minor problems with the SQLite documentation. (By the way, let me thank you for adding named anchors to every heading in the docs so I can link to them easily. A lot of webpages don't do this.) 1. In Compilation Options For SQLite "http://sqlite.or

[sqlite] A little light reading

On Sun, Nov 8, 2015 at 15:28:06 -0200, Bernardo Sulzbach wrote : > On Sun, Nov 8, 2015 at 1:25 PM, Nicolas J?ger > wrote: > > > > reminds me when, because of some "idiots database programmers", I got > > (during the same month) > > three cards automatically from the health care system with thr

[sqlite] A little light reading

An article by Christopher Null on how database programmers are idiots. Come to think of it, if you stare at the above line for long enough you won't need the article. But here it is anyway: Simon.

[sqlite] A little light reading

On Sun, Nov 8, 2015 at 10:36 AM, Simon Slavin wrote: > > On 8 Nov 2015, at 4:11pm, John McKown > wrote: > > > I'm not a developer. So I guess that it's my ignorance as to why a > program > > would be confused by the string value of "null" or any variant thereof. > > NULL has a special meaning in

[sqlite] A little light reading

hi, > An article by Christopher Null on how database programmers are idiots. > > Come to think of it, if you stare at the above line for long enough you won't > need the article. > But here it is anyway: > > > > Simon. reminds me when, because of some "idi

[sqlite] Problem with sqldiff

Richard Thanks. That gives me what I would expect. John Gillespie sqlite-src-30902T 573 % ./sqldiff z1.db z2.db ALTER TABLE A ADD COLUMN category; UPDATE A SET category='' WHERE rowid=1; UPDATE A SET category='' WHERE rowid=2; UPDATE A SET category='' WHERE rowid=3; On 7 November 201

[sqlite] A little light reading

I'm not a developer. So I guess that it's my ignorance as to why a program would be confused by the string value of "null" or any variant thereof. I do understand looking for a string of length 0. If I were to want a special name for Some purpose, I'd likely use xyzzy. I thought of plugh as well, b