Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-27 Thread R Smith
On 2019/06/27 10:57 AM, Adolfo J. Millan wrote: I must apologize, because I feel that muy comment has been misinterpreted, proably because my weak english. ... If this had been a technical or theoretical issue, I would probably have refrained from expressing my opinion, due to my lack of

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-27 Thread Adolfo J . Millan
I must apologize, because I feel that muy comment has been misinterpreted, proably because my weak english. I did not mean to say that "out there" there are not zillions of books, tutorials, SQL examples, but: I refer to information "close" to the point where the doubt occurs. In the case of

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-26 Thread Keith Medcalf
On Wednesday, 26 June, 2019 10:59, a...@zator.com wrote: >Irreproachable argumentation, which in my humble opinion is little or >nothing useful to those who want to enter in the diabolic world of >SQL. Especially, if you have not yet managed to change the chip and >find out that for example, you

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-26 Thread Warren Young
On Jun 26, 2019, at 2:58 PM, ingo wrote: > > On 26-6-2019 22:22, Warren Young wrote: >> 3. Lack of types. > > Not being a programmer, that was a revelation to me Behind my prior two posts isn’t an attitude of criticism of SQLite’s design and implementation, but rather an itch created by the

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-26 Thread ingo
On 26-6-2019 22:22, Warren Young wrote: > 3. Lack of types. Not being a programmer, that was a revelation to me, I started with Postgresql (upgrading to SQLite now) and wasted way to many hours on deciding the type. In SQLite it is straight forward. If I use CURRENT_TIMESTAMP in the shell it

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-26 Thread Warren Young
On Jun 26, 2019, at 2:22 PM, Warren Young wrote: > > 3. …types…table…more comprehensive, so that whatever weird data type you > search for, you either get a simple mapping to one of SQLite’s few base data > types or to a recipe showing how to construct a suitable alternative. …or a pointer to

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-26 Thread Warren Young
On Jun 26, 2019, at 11:11 AM, Simon Slavin wrote: > > I too have missed sample code from the SQLite documentation. I agree that > there are some drawbacks to including it. But there are some things, like > the correct sequence is for understanding ROLLBACKs, which are strange and >

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-26 Thread Robert Hairgrove
On 26.06.19 18:58, a...@zator.com wrote: Irreproachable argumentation, which in my humble opinion is little or nothing useful to those who want to enter in the diabolic world of SQL. Especially, if you have not yet managed to change the chip and find out that for example, you must carry out a

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-26 Thread Jens Alfke
> On Jun 26, 2019, at 9:58 AM, a...@zator.com wrote: > > the sad reality is that it is difficult to find examples of SQL, apart from > being attentive to these pages where sometimes you learn a lot in the code of > some answers. I don’t know what to say to that! Have you looked outside the

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-26 Thread Simon Slavin
On 26 Jun 2019, at 5:58pm, a...@zator.com wrote: > I understand and empathize absolutely with the O.P. and must add that in the > documentation of SQLite, I have always missed examples and comments that, for > example, can be found in the PHP doc. Likewise. The PHP system of documentation,

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

2019-06-26 Thread ajm
Irreproachable argumentation, which in my humble opinion is little or nothing useful to those who want to enter in the diabolic world of SQL. Especially, if you have not yet managed to change the chip and find out that for example, you must carry out a program without using variables. All the