Tools and services for working with DuckDB effectively

Throughout this book, we’ve largely worked with the DuckDB command-line interface (CLI) client when creating and running DuckDB SQL queries, except for our explorations of the Python and R clients. The DuckDB CLI is a convenient tool to have in your toolkit for quickly prototyping and experimenting with DuckDB queries, as well as for performing some tactical data wrangling. However, if you start working with DuckDB regularly, you’ll likely encounter situations where a more fully featured development environment will enable you to work much more effectively. We’ve seen a couple of these already. In Chapter 7 and Chapter 8, we saw how we can use the DuckDB Python client to work with DuckDB in a Jupyter Notebook, while in Chapter 11, we saw how the JupySQL library allows us to use DuckDB SQL directly via SQL-dedicated cells. Similarly, in Chapter 9, we saw how we can use the DuckDB R client to work with DuckDB...