Database Access

In Chapter 6, Working with Data, we looked at working with data that is stored in disk files: we looked at plain text files and also datasets taking the form of R data files, CSV, HDF5, and so on.

In this chapter, we will consider data stored in databases but will exclude the “big data” data repositories as networking and remote working are the subjects of the next chapter.

There are several databases of various hues, and as it will not be possible to deal with all that Julia currently embraces, we will pick one specific example for each category as they arise.

Specifically, we will look at the following topics:

• Relational databases and SQL queries
• NoSQL databases
• The REpresentational State Transfer (REST) API
• The Queryverse

This chapter doesn’t intend to delve into the workings 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...