Perhaps this is too heavy weight (and perhaps it's really obvious), but
a sensible approach might be to provide a set views to the users, rather
than direct table access?
* These could probably provide more suitable information for
scripting than raw tables,
* They would provide abstraction from the tables, which might change
with new versions,
* They would (I think?) be read only, which seems like a good thing
for a query interface.
* They might encourage an environment where people provide additional
views (on the existing views, or on the underlying data) that are useful
for particular query tasks.
On the other hand, it might be useful to be able to slice and dice and
write to the database as you see fit...
Cheers,
Benjohn
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
