Palimpzest Recipes: How to Get Data From a Database

[mikecafarella]

We should create a series of short "Palimpzest Recipes". These will be short 1-2 page documents that show how to accomplish a commonly-wished-for goal.

If PZ is perfect, this is basically a documentation task. But of course PZ probably has a lot of problems, which we will only realize when we try to write the "easy story on how to do X" and realize that we can't do it. So accomplishing this task will sometimes mean just writing a doc, but will often mean doing some design and writing code.

In this case, the Goal is: HOW TO GET DATA FROM A DATABASE.

This is pretty similar to the task of getting data from a REST API. The only difference is that we get it from a SQL client. It's a small difference, but let's hold people's hands and show them how it's done. I think the schema-handling part might be a bit different.