On Thu, Aug 03, 2017 at 12:25:00PM +0200, Sylvain Pointeau wrote: > On Thu, 3 Aug 2017 at 08:04, Hick Gunter <h...@scigames.at> wrote: > > A sequence is very easily implemented as a virtual table that keeps the > > current values in a separate table my_sequences (name text primary key, > > initial integer, current integer, increment integer). > > > > (...) Or whatever else tickles your fancy. Just think table <=> class, > > virtual field <=> method > > What do you all recommend? UDF or Virtual tables?
I recommend a UDF because that's how it works in PG, so your code will be more portable that way. That said, the two approaches are basically equivalent. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
