Summary

In this chapter, we installed the sqlite3 command-line utility and installed the necessary SQLite3 libraries for working with data in the IHaskell environment. Most data doesn't come in SQLite3 format, but in CSV format. So, we covered how to convert a CSV file into an SQLite3 table. We explored the versatility of SELECT queries in SQLite3 by means of the WHERE clause, the ORDER BY clause, and the LIMIT clause. We also explored how to create our own custom module of descriptive statistics, and then we used that module in order to study earthquake data in the IHaskell environment. In our next chapter, we're going to take a look at regular expressions in Haskell.