how its the status of this work? a limited implementation will be good!
Lenz McKAY Gerardo (PICCORO) http://qgqlochekone.blogspot.com 2017-03-15 12:24 GMT-04:00 Simon Slavin <slav...@bigfraud.org>: > > On 15 Mar 2017, at 4:09pm, Dominique Devienne <ddevie...@gmail.com> wrote: > > > On Wed, Mar 15, 2017 at 4:57 PM, R Smith <rsm...@rsweb.co.za> wrote: > > > >> I wonder, sqlite Devs, if a pragma or other adaption (such as the > current > >> pragma table_info()) or such could produce the same exact data but with > an > >> added field called "Comment" that simply gives the parsed comment from > >> after each column definition (if any) like the above table example. This > >> would probably be a very small adaptation, be completely backwards > >> compatible, doesn't break any standard (since there isn't any) and > answer > >> the need expressed by this thread and others before it. > > > > That's one way to solve it, in a mostly BC (Backward Compatible) way. > > (modulo the output from table_info() changing, which could be opt-in to > > make it fully BC). > > Problem is, it requires parsing the CREATE command looking for comments in > a certain format. Notoriously difficult, considering that they can contain > CR, LF, tab, and unforeseen Unicode characters. > > I’m utterly against anything that tries to read C-style comments. > Comments are comments. Computers are meant to ignore them to the point > that they don’t even know they exist. > > On the other hand, if we establish a standard for storing comments in > database tables — which would require a consistent table name, column > names, and values — it might take too much extra time to show those > comments as an extra column in the response to PRAGMA tale_info() and > similar PRAGMAs. But I think it’s overkill. Anyone who would want that > would know how to retrieve the information. > > 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