In this chapter, you learned how to interface your database with other analytical tools for further analysis and visualization. While SQL is powerful, there will still be those odd analyses that need to be undertaken in other systems. To solve this problem, SQL allows you to transfer data in and out of the database for whatever tasks you may require.
Initially, we looked at how you can use the psql command-line tool to query a database. From there, we were able to explore the
COPY command and the psql-specific
\COPY command, which enabled you to import and export data to and from the database in bulk. Next, you looked at programmatically accessing the database using analytical software such as Python. From there, you were able to explore some of the advanced functionality in Python, including
pandas, which enabled you to perform data manipulation and visualization using a programming language.
In the next chapter, you will examine data structures that...