>Just the data returned by the SELECT command, expressed as an array of objects, one object per row.
That's what shell_callback() does inside shell.c. It outputs one row at a time in the current mode selected by the cases of a big switch() statement. Not sure I follow how your code would be subject to other intellectual property claims. You would merely be copying and pasting code from SQLite itself. For one, below is the row output code for MODE_html in shell.c. Your proposed MODE_json is probably a similar pattern with different decorations. The other modes are also there to be studied and copied. case MODE_Html: { if( p->cnt++==0 && p->showHeader ){ raw_printf(p->out,"<TR>"); for(i=0; i<nArg; i++){ raw_printf(p->out,"<TH>"); output_html_string(p->out, azCol[i]); raw_printf(p->out,"</TH>\n"); } raw_printf(p->out,"</TR>\n"); } if( azArg==0 ) break; raw_printf(p->out,"<TR>"); for(i=0; i<nArg; i++){ raw_printf(p->out,"<TD>"); output_html_string(p->out, azArg[i] ? azArg[i] : p->nullValue); raw_printf(p->out,"</TD>\n"); } raw_printf(p->out,"</TR>\n"); break; } Just copy, edit, compile and test until it produces sensible output you can demonstrate in an email. Incorporating relevant features from MySQL JSON output mode documentation that others will miss is also a good idea considering the entire json1.c API model was also cloned from MySQL. The only thing not to like about it would be if your design decisions make something that isn't generally useful. Not a waste of time if other JSON users are interested enough in your idea to provide feedback on the features they need. Most of the development work here is figuring out 'what' and 'why' rather than 'how'. The 'how' is trivial. Peter On Sun, Jan 21, 2018 at 3:04 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 21 Jan 2018, at 11:01pm, Simon Slavin <slav...@bigfraud.org> wrote: > > > Just the data that is stored in the table, expressed as a JSON object, > not an array. > > Sorry, what I meant was > > Just the data returned by the SELECT command, expressed as an array of > objects, one object per row. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users