1 very important one. I use it to insert events into a queue with a version and the version has to monotonously increase.
However, if I had to maintain the known max manually, that wouldn't really be a problem. On Mon, Mar 19, 2018, 3:52 AM Rowan Worth, <row...@dug.com> wrote: > 5/10 > 1/11 > 5/10 > > Always in conjunction with INTEGER PRIMARY KEY fwiw. > > > Also the following command is perhaps more portable: > > sqlite3 yourfile.db .schema | grep -ic autoincrement > > The sqlite3 shell on my system is too old to understand .schema --indent > and doesn't output anything so there's always zero lines to count :) > > -Rowan > > > On 16 March 2018 at 23:37, Richard Hipp <d...@sqlite.org> wrote: > > > This is a survey, the results of which will help us to make SQLite > faster. > > > > How many tables in your schema(s) use AUTOINCREMENT? > > > > I just need a single integer, the count of uses of the AUTOINCREMENT > > in your overall schema. You might compute this using: > > > > sqlite3 yourfile.db '.schema --indent' | grep -i autoincrement | wc -l > > > > Private email to me is fine. Thanks for participating in this survey! > > -- > > D. Richard Hipp > > d...@sqlite.org > > _______________________________________________ > > 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