If you're going to change the sqlite3 command shell, add a ".count" and maybe ".changes" display option.
On Wed, Oct 31, 2018 at 11:23 AM Don V Nielsen <donvniel...@gmail.com> wrote: > I really enjoy using JetBrains DataGrip. It connects to everything and has > great intellisense, find and replace tools, sql templates, all the goodies > a big IDE brings to the table. > > On Wed, Oct 31, 2018 at 11:05 AM Dominique Devienne <ddevie...@gmail.com> > wrote: > > > On Wed, Oct 31, 2018 at 3:55 PM Clemens Ladisch <clem...@ladisch.de> > > wrote: > > > > > David Fletcher wrote:> Hi all, > > > > Is there a mode in the sqlite shell, or some fancy extension, that > will > > > display a row > > > > number when outputting results? > > > > > > No. You'd have to modify the shell, or add the row_number() window > > > function to the query. > > > > > > Unless you need to use bleeding edge new features, use some GUI SQLite > tool > > instead. > > > > I use SQliteSpy myself for that. Gives me the time to process the query, > > how many rows, > > how many VM steps, Sort steps, that sort of thing. And shows me the > result > > in tabular fashion, > > with color-coding based on value types (useful for a ducktyping DB like > > SQLite). > > > > Windows only, very simple, but very fast. Uses SQLite 3.21, but updated > > once in a while. > > > > I typically keep several queries I'm playing with, and CTRL-F9 the > selected > > one to run it. > > > > Don't get me wrong, the CLI shell is great, but for many rows, or wide > > rows, > > or plain convenience, a GUI tool is often more practical IMHO. My $0.02. > > --DD > > _______________________________________________ > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users