On Mon, 16 Jul 2018 at 20:14, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote: > > On 07/16/2018 05:08 PM, Alvaro Herrera wrote: > > > > Sounds like wiki pages could solve need this pretty conveniently. If > > and when the content is mature enough and migrates to the tutorial main > > documentation pages, the wiki pages can be replaced with redirects to > > those. > > Anyone who writes a lot is going to rebel against using a wiki. They are > one of the worst to write in from a productivity perspective. I would > rather write in Docbook, at least then I can template everything and we > could have a standard xsl sheet etc... Indeed. I think it would be a fine idea to have some proposals for improved examples for the tutorial pages. By putting them there, it becomes easy to reference material either in reference sections or in the manual pages on SQL commands. (As "for instances." It would also be nice to have examples that make reference to executable programs, whether pg_dump, pg_ctl, or ...) I'd be willing to help write something of the sort; if I'm to shoot my mouth off on what we ought to do, best to volunteer to actually make some of it happen. Having some small sample applications that do interesting things with different Postgres facilities seems like a neat approach. It would be interesting to have an example that makes decent use of LISTEN/NOTIFY; people keep asking how to have PostgreSQL send email, and writing a small example that handles it via queueing requests into a table, where a daemon stops in to send queued email once in a while. Another idea would be an app that captures messages into tables and enables full text search would be nice. Doing some somewhat simplistic partitioning of a perhaps large (but simplistic, so it fits into docs) data set would help motivate use of partitioning facilities. Applications need to be kept fairly tiny so that they represent good examples without being of dominant size. -- When confronted by a difficult problem, solve it by reducing it to the question, "How would the Lone Ranger handle this?"
