Practical Database Queries

Summary

This chapter offered insight into some of the most common general tasks you’ll encounter when developing data-driven applications. The chapter started by providing a PostgreSQL data class and offering some basic usage examples involving this class. Next, you learned a convenient and easy method for outputting data results in a tabular format, and then learned how to add actionable options for each output data row. Building upon this material, you saw how to sort output based on a given table field. Finally, you learned how to spread query results across several pages and create linked page listings, enabling the user to navigate the results in a nonlinear fashion.

The next chapter introduces PostgreSQL’s implementation of views and rules, which help you to implement and maintain your full data model.