Book Image

Mastering Julia - Second Edition

By : Malcolm Sherrington
Book Image

Mastering Julia - Second Edition

By: Malcolm Sherrington

Overview of this book

Julia is a well-constructed programming language which was designed for fast execution speed by using just-in-time LLVM compilation techniques, thus eliminating the classic problem of performing analysis in one language and translating it for performance in a second. This book is a primer on Julia’s approach to a wide variety of topics such as scientific computing, statistics, machine learning, simulation, graphics, and distributed computing. Starting off with a refresher on installing and running Julia on different platforms, you’ll quickly get to grips with the core concepts and delve into a discussion on how to use Julia with various code editors and interactive development environments (IDEs). As you progress, you’ll see how data works through simple statistics and analytics and discover Julia's speed, its real strength, which makes it particularly useful in highly intensive computing tasks. You’ll also and observe how Julia can cooperate with external processes to enhance graphics and data visualization. Finally, you will explore metaprogramming and learn how it adds great power to the language and establish networking and distributed computing with Julia. By the end of this book, you’ll be confident in using Julia as part of your existing skill set.
Table of Contents (14 chapters)

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...