In Chapter 5, Working with Data, we looked at working with data that is stored in disk files, looked at plain text files, and also datasets that take the form of R datafiles and HDF5.
In this chapter, we will consider data residing in databases but will exclude the "big data" data repository as networking and remote working is the theme of the next chapter.
There are a number of databases of various hues, and as it will not be possible to deal with all that Julia currently embraces, we will to pick one specific example for each category as they arise.
It is not the intention of this chapter to delve into the working of the various databases or to set up any complex queries, nor to go in depth into any of the available packages in Julia. All we can achieve in this section is to look at the connection and interfacing techniques of a few common examples.
