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 it wasn't tragic...

2019-06-26 Thread Warren Young
On Jun 26, 2019, at 3:31 PM, James K. Lowden wrote: > > You won't find many examples included with your C compiler That depends a lot on the C compiler in question. Some C compilers include a *lot* of examples. Arguably, K is a bound book of examples for the AT Unix C compiler. Where is

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

2019-06-26 Thread James K. Lowden
On Sat, 22 Jun 2019 23:14:08 -0700 Ben Earhart wrote: > can't be bothered to write example sql code While I'm sure you're irritated, that criticism is misplaced. You might want to take a step back. Tools that work with standardized languages don't define the language they process. You won't

Re: [sqlite] Incorrect results after upgrading to 3.28.0

2019-06-26 Thread Dan Kennedy
Thanks for reporting this one. It is a bug. Now fixed here: https://sqlite.org/src/info/5fd20e09a522b62a Ticket: https://sqlite.org/src/info/9cdc5c46 Dan. > We recently updated from version 3.26.0 to version 3.28.0. Now we're seeing > different (incorrect) results for the following

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] porting sqlite on ARM cortex M7

2019-06-26 Thread Mateusz Wajchęprzełóż
https://www.sqlite.org/custombuild.html https://www.sqlite.org/vfs.html śr., 26 cze 2019 o 08:34 napisał(a): > Dear SQLite Team, > > > > I am very new to SQLite and want to use SQLite in my project which is based > on ARM Cortex M7 core. Do we have any examples available for porting SQLite > to

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

Re: [sqlite] porting sqlite on ARM cortex M7

2019-06-26 Thread Jens Alfke
> On Jun 25, 2019, at 11:34 PM, vi...@ngxtech.com wrote: > > I am very new to SQLite and want to use SQLite in my project which is based > on ARM Cortex M7 core. Do we have any examples available for porting SQLite > to cortex M series microcontroller?? It’s written in highly portable C, so

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

2019-06-26 Thread Stephen Chrzanowski
I've always been perturbed by the term "Real World Examples". Because... well.. Everything is different from one building to the next. How I make my SQL calls is going to be different than the company across the street. Heck, even the guy sitting across from me will come up with a different way

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

2019-06-26 Thread R Smith
On 2019/06/23 8:14 AM, Ben Earhart wrote: ...that the person(s) that has no problem writing small, but solid, walls of technical detail and drawing intricate circularly recursive syntax diagrams which require multiple levels of detail to coherently represent, can't be bothered to write example

[sqlite] porting sqlite on ARM cortex M7

2019-06-26 Thread vivek
Dear SQLite Team, I am very new to SQLite and want to use SQLite in my project which is based on ARM Cortex M7 core. Do we have any examples available for porting SQLite to cortex M series microcontroller?? Regards Vivek Aggarwal Firmware Team Lead NGX Technologies Pvt Ltd