search

unioslo / pysquril

Versioned, queryable, auditable document oriented data stores for REST APIs
0 stars 2 forks source link

Support comments on schemas, and tables #75

Open leondutoit opened 1 month ago

leondutoit commented 1 month ago

https://www.postgresql.org/docs/current/sql-comment.html

"There is presently no security mechanism for viewing comments: any user connected to a database can see all the comments for objects in that database. For shared objects such as databases, roles, and tablespaces, comments are stored globally so any user connected to any database in the cluster can see all the comments for shared objects. Therefore, don't put security-critical information in comments."

https://stackoverflow.com/questions/7426205/sqlite-adding-comment-on-descriptions-to-tables-and-columns

leondutoit commented 1 month ago

Need to consider the tradeoffs of using the COMMENT system and sqlite DDL, versus offering a meta table as part of core functionality, similar to audit.