POSTGRESQL is the most advanced open source database server. In this chapter, you will learn about databases, open source software, and the history of POSTGRESQL.
There are three basic office productivity applications: word processors, databases, and spreadsheets. Word processors produce text documents critical to any business. Spreadsheets are used for financial calculations and analysis. Databases primary function is data storage and retrieval. You can use a word processor or a spreadsheet to store small amounts of data, but with large volumes of data or data that must be retrieved and updated frequently, databases are the best choice. Databases allow orderly data storage, rapid data retrieval, and complex data analysis, as you will see in the coming chapters.