2017-03-15 11:49 GMT-04:00 R Smith <rsm...@rsweb.co.za>: > Well, the advantage of having comments in DB tables (as some suggested) is > also that you have the entire SQL language functions available to > manipulate the comments
that's one firts reason that rely on the second, comment can handle (with the DBMS) the build in necesary documentation selft conained inside on the DB, that its helfull for all, (very) > - which you don't have when they are treated like Meta-data. > That said, only some DBs include comment in-schema specifiers, like > Postgres and MySQL as Richard pointed out, make this in master db can make obvously incompatible and can made grow the size depends of the comment size and amount of the tables and columns.. but, taking in considerations that today nobody of us take care about that (machines are so powerfully right?).... so makin a extra schema its enought > Your request has been noted, Thank you for the suggestion. > many thanks! really appreciated! this request was made prevously by another person, see archives.. many many years ago!!!! also was widelly requested in internet network by many years, but due the very complicated behavior of the request / bugtraking system for sqlite.. no much was received here > in MSSQL you have to add a comment by a whole other mechanism. ??? in my job we have complete SQL SERVER 2014 SP1 and performance need a complete dell r600 and usage of the compelte 1T of RAM need extra licences.. and more extra and extra "integrations" and then u mention that: > Easy sailor... There is no need for you use that specific "stupid guindows > tool", it's simply that the tool had solved the comment problem by parsing > the schema, and you could do something like it. > we use (again) MS-like soft due "recomended", these king of "recomendations" was the reason of the problem.. we have to paid, mid-usage of a software we cannot migrate easy now! and we cannot use "complete" today without a "grow-deep" dependence of the MS ... _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
